Senior Data Engineer - Snowflake Migration & Python
Role summary
Seeking a Senior Data Engineer with 3-5+ years of experience for a 12-month contract in Burbank, CA. This hybrid role focuses on migrating existing Azure Data Factory pipelines to Snowflake using Snowpark, Python, and SQL. Responsibilities include building and optimizing data pipelines, implementing secure data solutions, and leveraging AI-assisted development tools. Requires strong Snowflake, Python, SQL, ADF, ETL migration, REST API integration, and Agile/Scrum experience. Understanding of data security and governance is essential. Nice-to-haves include Snowflake Tasks/Streams, AWS/Azure experience, and CI/CD.
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
- SQL
- Azure Data Factory
- ETL / data pipeline migration
- REST API integration
- Agile / Scrum
- AI-assisted development tools such as Cursor or Microsoft Copilot
Responsibilities:
- Build, refactor, and support enterprise data pipelines for data collection, transformation, and delivery
- Develop and maintain Snowflake-based data solutions using Snowpark, Python, and SQL
- Migrate existing Azure Data Factory pipelines into Snowflake Snowpark solutions
- Join and transform data from multiple source systems for reporting, dashboards, KPIs, and analytics use cases
- Implement infrastructure that supports secure data storage, processing, and retrieval in Snowflake
- Execute work from defined requirements, technical designs, and priorities set by team leads and architects
- Identify delivery risks, technical issues, or blockers and escalate as needed
- Manage assigned tasks and deliverables against project timelines and sprint commitments
- Apply performance tuning and optimization across Python and SQL workflows
- Use AI-assisted development tools to support coding, refactoring, debugging, and documentation while following engineering standards
- Validate AI-generated output to ensure security, quality, performance, and governance requirements are met
- Share AI tool usage patterns and best practices with the broader engineering team
Qualifications:
- 3 to 5+ years of experience in Data Engineering or Data Integration roles
- Strong hands-on experience with Snowflake in a production environment
- Strong hands-on experience with Snowpark pipeline development
- Senior-level Python skills for data engineering and integration workloads
- Advanced SQL skills, including complex transformations and query tuning
- Experience working with Azure Data Factory and translating pipeline logic into Python-based implementations
- Experience migrating ETL or data pipelines across cloud platforms, especially from Azure to Snowflake
- Experience working with REST APIs using Python
- Experience in Agile/Scrum teams with sprint-based delivery
- Understanding of data security, governance, and enterprise engineering standards
- Bachelor’s degree or equivalent practical experience
Nice to Have:
- Snowflake Tasks and Streams
- Snowflake warehouse configuration and optimization
- AWS experience
- Azure experience
- CI/CD for data engineering workflows
- Experience with large-scale cloud data migration projects