Responsibilities
- Design, build, and maintain data pipelines using modern orchestration tools (e.g., Dagster, Airflow, or equivalent)
- Develop and optimize Snowflake data models — including dynamic tables, streams, tasks, and materialized views — for performance and reliability
- Ingest and process structured and semi-structured data (CSV, JSON, Parquet) via automated ELT workflows
- Write Python for data manipulation, automation, and pipeline development — following engineering best practices including testing, documentation, and code optimization
- Manage version control and collaboration through GitHub, adhering to branching strategies and code review standards
- Build and maintain CI/CD pipelines to automate testing, validation, and deployment of data assets
- Contribute to data lake design and maintenance, ensuring data integrity, lineage, and quality standards
- Build clean, AI-ready data layers that support agentic analytics and intelligent querying use cases on Snowflake Cortex
- Contribute to semantic layer development alongside senior engineers, supporting clean, consistent data access patterns for AI and analytics consumers
- Support the team's work in AI for analytics on Snowflake Cortex — executing on agent-driven workflows and automated insight pipelines under the guidance of senior engineers
- Monitor and troubleshoot pipelines to ensure uptime, data quality, and SLA compliance
- Implement testing frameworks within your transformation layer to validate accuracy and catch issues early
- Identify opportunities to optimize pipeline performance, reduce latency, and lower compute cost
- Partner with business analysts and Sales, Distribution, Operations, and Finance teams to translate requirements into technical solutions
- Engage business stakeholders with a service-first mindset — proactively communicating, setting clear expectations, and following through
- Document pipeline designs, data flows, and technical decisions to support team knowledge and auditability
- Build relationships with global data engineering teams to align on standards and shared solutions
- Contribute to the Analytics roadmap for short, medium, and long-term business needs
- Innovate and enhance our data lakes and data fabric, ensuring alignment with business goals
- Stay current with industry trends and emerging technologies, particularly in the Snowflake ecosystem and AI-driven analytics
- Own your work end-to-end — manage priorities, track commitments in Jira, and don't wait to be asked
- Collaborate openly across engineering, analytics, and business teams in a high-trust, low-bureaucracy environment
- Bring a white-glove mindset to business stakeholders — responsive, clear, and solutions-oriented
Requirements
- Hands-on experience with Snowflake, dbt, Dagster, and Python
- Experience developing, implementing, and maintaining robust data pipelines and analytical solutions
- Ability to interact directly with business stakeholders to transform business requirements into technical solutions
- Service mindedness, a white-glove-service approach, communication skills, and pro-activity
Nice to Have
- Experience with modern orchestration tools such as Airflow
- Familiarity with Snowflake Cortex for AI and intelligent analytics
- Experience contributing to semantic layer development
- Knowledge of industry trends and emerging technologies in the Snowflake ecosystem and AI-driven analytics
Work Arrangement
On-site — Santa Monica, CA
Additional Information
- This position is required to sit onsite in Santa Monica, CA
- We are in the office 4 days per week with the 5th business day being remote