Senior Snowflake Data Engineer

Job Description 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