Senior Snowflake Data Engineer - Snowpark & ADF Migration

City: Burbank, CA

Onsite/ Hybrid/ Remote: Hybrid (4 days onsite per week, no flexibility)

Duration: 12 Months

Rate Range: Upto $96/hr on W2

Work Authorization: GC, USC, All valid EADs except OPT, CPT, H1B

Must Have:

Snowflake

Snowpark

Python

Advanced SQL

Azure Data Factory

ETL / ELT pipeline migration

Snowflake Tasks and Streams

Medallion Architecture (Bronze / Silver / Gold)

REST API integration

Agile / Scrum

Responsibilities:

Migrate existing Azure Data Factory pipelines into native Snowflake solutions

Analyze existing ADF pipeline logic and replicate workflows using Snowpark and Python

Build native Snowflake pipelines using Snowpark libraries, Tasks, Streams, and SQL transformations

Develop Python scripts and scheduled jobs directly inside Snowflake

Optimize Snowflake warehouse sizing, compute usage, and job performance

Support the transition from analytics-focused workflows into a scalable enterprise data warehouse platform

Build and support Bronze, Silver, and Gold medallion data layers

Join and transform data from multiple systems for reporting, KPIs, and analytics

Work from clearly defined technical requirements and task assignments from engineering leadership

Ensure secure, scalable, and performant Snowflake implementations

Use AI-assisted development tools such as Cursor or Copilot to accelerate engineering delivery

Qualifications:

5+ years of hands-on Data Engineering experience

Strong hands-on Snowflake experience in production environments

Deep Snowpark experience including Snowpark libraries and native Snowflake processing

Strong Python coding skills for data engineering and automation

Advanced SQL experience including complex transformations and performance tuning

Experience reviewing and translating Azure Data Factory pipeline logic into Snowflake-native solutions

Experience with Snowflake warehouse optimization and cost management

Experience building scheduled jobs, Tasks, and orchestration workflows inside Snowflake

Experience with Medallion Architecture and enterprise data warehousing concepts

Experience in Agile/Scrum delivery environments

Ability to work independently in a task-oriented engineering role without ramp-up time

Nice to Have:

Snowflake Cortex

Cursor, Claude, or Microsoft Copilot experience

AWS experience

CI/CD pipelines for data engineering

Snowflake Private Data Sharing

Real-time or streaming data pipeline experience