Senior Snowflake Data Engineer: Snowpark, ADF Migration

aKube; Burbank (IL); On-site; Full time

Job description

Burbank, United States | Posted on 05/22/2026

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
• 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
• Snowflake Private Data Sharing
• Real-time or streaming data pipeline experience