Apply Now

Lead Snowflake Developer

Midtown, NY, US • Posted 1 hour ago • Updated 43 minutes ago

Contract Corp To Corp

Contract W2

On-site

Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

sql
python
ETL
Snowflake

Summary

Job Title: Lead Snowflake Developer
Location: Midtown, NYC

Position Overview:

We are seeking a certified Lead Snowflake Developer to lead an enterprise data migration from a legacy source system into Snowflake. The role combines hands-on ETL/ELT pipeline engineering using Python, API integration development, and deep Snowflake platform expertise - including data modeling, Cortex AI, and Snowpark. This is a lead-level position with ownership over architecture, delivery, and engineering standards.

Key Responsibilities:

Lead end-to-end data migration from legacy systems into Snowflake - data profiling, mapping, transformation, validation, and cutover.
Design and build Python-based ETL/ELT pipelines and REST API integrations for data ingestion into Snowflake.
Implement CDC (change data capture), incremental load strategies, and robust error-handling to ensure data consistency and reliability.
Architect multi-layered Snowflake environments (raw, curated, presentation) using dimensional modeling, star/snowflake schemas, or Data Vault 2.0.
Leverage Snowflake-native features: Dynamic Tables, Streams & Tasks, Time Travel, Materialized Views, Zero-Copy Cloning, and clustering keys.
Develop Cortex AI-powered capabilities - COMPLETE, EMBED_TEXT, SUMMARIZE, SENTIMENT, Cortex Analyst, and Cortex Search for NL querying.
Build Snowpark Python UDFs, stored procedures, and ML-powered features (classification, anomaly detection, forecasting) within Snowflake.
Enforce data governance: RBAC, column-level security, row-access policies, data masking, and object tagging.
Drive CI/CD practices for Snowflake deployments (dbt, SchemaChange, Flyway, Git-based workflows) and mentor junior engineers.
Partner with analysts, BI developers, and stakeholders to translate requirements into performant, scalable data solutions.

Required Qualifications:

Active SnowPro Core Certification; SnowPro Advanced: Data Engineer strongly preferred.
7+ years in data engineering; 4+ years of hands-on Snowflake development in production environments.
Proven experience leading a full-cycle enterprise data migration into Snowflake.
Strong Python skills - pandas, SQLAlchemy, Snowpark Python, REST API development, and OOP design patterns.
Expert SQL with deep knowledge of Snowflake SQL extensions, window functions, and query optimization.
Experience with Snowflake Cortex AI or equivalent LLM/ML integration within a data platform.
Solid data modeling background: star/snowflake schema, Data Vault 2.0, or entity-relationship modeling.
Familiarity with orchestration tools: Apache Airflow, Prefect, or dbt workflow scheduling.

Preferred Qualifications:

Exposure to streaming data with Snowflake Dynamic Tables or Kafka connectors.
Cloud platform experience: AWS, Azure, or Google Cloud Platform in a Snowflake-hosted deployment.
Certifications:
SnowPro Core Certification - Required
SnowPro Advanced: Data Engineer - Strongly Preferred
SnowPro Advanced: Architect - A Plus
AWS / Azure / Google Cloud Platform Data or Cloud Certification - A Plus

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10106248
Position Id: 2026-4106/110159
Posted 1 hour ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Lead Snowflake Data Engineer

New York, New York

•

5d ago

Position: Lead snowflake data engineerLocation: NYC, NY(onsite)Duration: 12 months(W2 Only)Glider test-yesSkills Needed: +10 years with end-to-end data pipeline development and deployment in Snowflake, Python + PySpark, Cortex AI, etc

Easy Apply

Contract

60 - 65

Snowflake Data Engineer

New York, New York

•

28d ago

Need W2 Candidates / -EAD / OPT-EAD Senior Snowflake Data Engineer Location: NYC | Fully Onsite | Need Local Candidates 7+ years of experience in data engineering or backend development roles Strong hands-on experience with Python, PySpark, and Snowflake Proven expertise in Snowflake data modeling, performance tuning, and optimization Experience working with Snowflake Cortex AI or similar AI-enabled data platform capabilities Solid understanding of modern data warehousing concepts (dimensional m

Easy Apply

Contract

60 - 65

SnowflakeArchitect

Hybrid in Jersey City, New Jersey

•

11d ago

HI, Location: Jersey City (hybrid) 12+ Months (only W2) Qualifications: Experience in data engineering with strong hands-on expertise in Snowflake and SQLProven ability to design analytics-ready data models and enterprise BI solutionsDeep understanding of ELT/ETL patterns, data warehousing concepts, and performance tuningStrong experience in Snowflake architecture design, including multi-cluster warehouses, workload isolation, and scaling strategies

Easy Apply

Contract

$70 - $80

Big Data Engineer - Intermediate/Thomas

New York, New York

•

10d ago

Title: Big Data Engineer - Intermediate Location: Manhattan West, NY - Onsite Duration: Right to hire - W2 (USC) Job Summary We are seeking a skilled Data Engineer to design, build, and manage scalable ETL pipelines supporting a centralized data lake and Snowflake data warehouse. The role focuses on automating data ingestion, transformation, and aggregation workflows to enable reliable analytics and data-driven decision-making. Key Responsibilities Design, develop, and maintain robust ETL pip

Easy Apply

Contract

$60 - $70

Search all similar jobs