Lead in NYC

Pleasure mailing you. Please go through the below requirement and let me know if you are comfortable for the position.

Please send me your updated resume along with the best hourly rate, work authorization status and availability. An early response is really appreciated.

Job Title: Snowflake Lead

Location: NYC, NY

Duration: 6+ months

Job description

Hands on Snowflake lead, who can act as a lead for a Bangalore team as well, based out of NY

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