Senior Data Engineer

Location: Burbank, CA | Hybrid (4 days onsite per week, no flexibility) | Duration: 12 months | Rate: Up to $96/hr on W2 | Work authorization: GC, USC, all valid EADs except OPT, CPT, H1B

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

Requirements

• 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
• 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

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