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