Senior Snowflake Data Engineer - Snowpark & ADF Migration - 1615
About The Position
This role is for a Senior Snowflake Data Engineer focused on Snowpark and Azure Data Factory migration. The position is a 12-month contract with a hybrid work model, requiring 4 days onsite per week in Burbank, CA. The engineer will be responsible for migrating existing Azure Data Factory pipelines into native Snowflake solutions, analyzing and replicating workflows using Snowpark and Python, and building native Snowflake pipelines. The role also involves optimizing Snowflake performance, supporting the transition to an enterprise data warehouse, building medallion data layers, and ensuring secure, scalable, and performant implementations. The engineer will work from technical requirements provided by leadership and utilize AI-assisted development tools.
Requirements
- 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 Haves
- 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
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
