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