Snowflake - Snowflake architect and lead. onsite role
Location: NY - Need local and hybrid.
Employment: FTE
Hands on Snowflake architect and lead.
Responsibilities
Enhance an existing implementation in Snowflake to ingest and publish additional datasets to consumers
Design and implement schema – tables, views – across each of the Snowflake layers and any sql based transformation that meets performance requirements for accessing data.
Design and implement Snowflake entitlements to secure the data, through Snowflake policies and data models within the schema (row and column based entitlements, dynamic masking of columns for a specific period within the database), ensuring performance requirements are met
Write Snowflake stored procedures and Snowflake SQLs
Lead an offshore team, assisting them as well as required.
Coordinate with other stakeholders like product owners and data source system owners to understand the requirements and the data
Write sqls to test data transformation and migration
Having experience of
Snowflake data architecture composed of four layers – Raw, Staging, Core and Consumer
Extract, Load, Transform implementation using Snowflake data architecture
Implementing Data Quality framework for Snowflake
Row and Column level security in Snowflake for currently available data
Implementing with CI/CD pipelines
Nice to have – ETL Experience in sourcing data from REST APIs to Snowflake
Nice to have – ETL Experience in sourcing data from databases to Snowflake
Nice to have – Human resource data sets experience
The approximate annual base compensation range for this position is $80,000 to $100,000. The actual offer, reflecting the total compensation package plus benefits, will be determined by a number of factors which include but are not limited to the applicant’s experience, knowledge, skills, and abilities; geographic location; and internal equity.