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