Senior Snowflake Data Engineer - 1615

aKUBE; Burbank (CA); On-site; USD 109,000 - 155,000; Full time

Job summary

Doist in Burbank, CA is seeking a Data Engineer to migrate and optimize data pipelines in Snowflake, leveraging Snowpark, Python and SQL. You will translate Azure Data Factory logic into Snowflake-native workflows and build scalable, cost-efficient pipelines.

You will work from engineering requirements to deliver Bronze/Silver/Gold medallion data layers, implement Tasks and Streams, and optimize compute usage for enterprise analytics.

Qualifications

• 5+ years hands-on Data Engineering experience.
• Strong hands-on Snowflake experience in production environments.
• Deep Snowpark experience including native Snowflake processing.
• Strong Python coding skills for data engineering and automation.
• Advanced SQL experience with complex transformations and performance tuning.
• Experience translating Azure Data Factory 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.

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.

Skills

Snowflake

Snowpark

Python

Advanced SQL

Azure Data Factory ETL / ELT pipeline迁

Snowflake Tasks and Streams

Medallion Architecture

REST API integration

Agile / Scrum

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 Skills

• 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