Location: Santa Monica CA (4 days a week onsite)
Contract: 12 Months+
DATA ENGINEERING / ANALYTICS ENGINEERING
Build reliable pipelines and trusted analytical models that turn enterprise data into business value.
OUR AMBITION
Build the #1 Data & Analytics team in CPG.
We are looking for A players who want to help build it. For us, that means a consistent record of strong results, technical depth, integrity, hunger to learn, and personal ownership. Bring evidence of what you delivered, what you learned, and how you raised the standard around you.
Where we are today
Our work spans SAP BW, Snowflake, and AI-powered analytics for Sales, Distribution, Operations, and Finance. We are connecting established enterprise data and business logic with new ways for teams to get answers. The next step is to make those capabilities consistently trusted, reusable, and useful at scale.
Your outcome scorecard
- Most of your time is outside BW, building in Snowflake and the wider data stack. Use BW fundamentals to understand source data and preserve its business meaning. Agree baselines, targets, and delivery dates with the Technical Delivery Manager at the start of the assignment.
- Reliable data pipelines. Move agreed BW datasets into Snowflake using SNP Glue. Meet agreed freshness and reliability targets, with monitoring, reconciliation, and tested recovery.
- Trusted analytical models. Deliver reusable models, clear metric definitions, and documented lineage. Validate grain, joins, and calculations against business-approved benchmarks.
- Useful business outcomes. Translate stakeholder needs into accepted data products. Track adoption, time saved, and reduced rework; communicate progress, trade-offs, and risks clearly.
Own the outcome.
- Build and operate pipelines. Use SNP Glue to move data from BW to Snowflake. Own mappings, incremental loads, monitoring, recovery, and source-to-target reconciliation.
- Engineer reusable analytics. Build SQL transformations, dimensional models, and curated datasets in Snowflake. Define grain, joins, metrics, and tests; tune performance and cost.
- Apply BW fundamentals. Understand providers, master data, hierarchies, transformations, and key figures well enough to interpret source logic and investigate discrepancies with BW specialists.
- Communicate and own delivery. Clarify requirements, explain technical choices in business language, and agree acceptance criteria. Drive testing, release, and support; keep Jira current and raise blockers with a proposed next step.
What you bring
- Typically 3–5+ years in data engineering or enterprise analytics. Demonstrated capability and ownership matter more than tenure.
- Data and analytics engineering. Strong SQL, analytical modeling, ETL/ELT, and hands-on Snowflake delivery. Working knowledge of Python, orchestration, testing, version control, and releases.
- SAP BW fundamentals. Understand how BW structures data and applies business logic. Reconcile Snowflake outputs to source definitions; most day-to-day development is outside BW.
- Data integration. Practical extraction or replication, incremental processing, data quality, and recovery experience. SNP Glue is the tool used in this role; prior hands-on experience is strongly preferred.
- Strong communication. Clear written and verbal communication with business and technical teams. Ask focused questions, explain discrepancies and trade-offs, document decisions, and surface risks early.
Additional experience that helps
DBT, Dagster, GitHub, and BI or semantic modeling. Exposure to Cortex Agents, ontology, knowledge vaults, and an Enterprise Context Layer helps you build data foundations for AI; specialist agent development is not a core requirement.