Lead Snowflake Developer

AIT Global, Inc.

New York, United States of America

2 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Senior

Compensation

$ 216K

Job location

New York, United States of America

Tech stack

Artificial Intelligence

Airflow

Amazon Web Services (AWS)

ARM

Azure

Business Intelligence

Cloud Computing

Continuous Integration

Information Engineering

Data Governance

Data Infrastructure

ETL

Data Masking

Data Migration

Data Profiling

Data Vault Modeling

Software Design Patterns

Dimensional Modeling

Entity Relationship Models

Python

Object-Oriented Software Development

Query Optimization

Role-Based Access Control

SQL Stored Procedures

SQL Databases

SQLAlchemy

Data Streaming

Workflow Management Systems

Data Ingestion

Large Language Models

Snowflake

Change Data Capture

Pandas

Build Management

Angular

Git Flow

Star Schema

Kafka

Machine Learning Operations

REST

Data Pipelines

Legacy Systems

Job description

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., * 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., Job Description: The Role As a Principal Front End/Full Stack Developer in a Quantitative Development team, you will play a key role as a technical leader responsible for desig…

16 hours ago

Requirements

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: