Data Engineer

Hadrian Automation • Los Angeles, CA

2d • $150,000 - $230,000

About The Position

Hadrian's Data Analytics team builds and owns the semantic layer that every dashboard, board metric, and AI Analyst answer at Hadrian resolves to. As Hadrian scales from a handful of factories to twenty and beyond, this team makes sure a metric means the same thing in every factory, every dashboard, and every decision — one definition, one number, no matter who's asking. This is the foundation that drives operational intelligence at scale: the layer that turns raw factory data into metrics people can trust and act on. You'll build it in close partnership with Data Platform Engineering, Data Analysts, and the business domains the team serves.
You will architect and own Hadrian's semantic and metric layer — the canonical definitions, calculation logic, ownership, and refresh cadence that keep every team, and the AI Analyst, pulling the same number. Day to day, you'll build certified data marts from cross-domain raw datasets, model them dimensionally to scale from one factory to twenty and beyond, and set the analytical standards the whole team works to — naming, metric definitions, testing, documentation, and CI/CD. You'll run data-quality programs end to end, from profiling and anomaly detection to root-cause analysis, partner with Data Platform Engineering on pipeline architecture, data contracts, and quality SLAs, and mentor analysts on modeling and testing discipline. When a plant manager, a board deck, and the AI Analyst all cite the same yield or on-time-delivery number, it's because you defined it once, in one place.

Requirements

• Production ownership of data models (years scale with level; see Level & Justification).
• Expert SQL (window functions, CTEs) with a real grasp of query performance and cost.
• Ships production data pipelines with Spark, dbt, and Dagster or equivalents.
• Strong data-modeling foundation (normalization, denormalization, star/snowflake schemas).
• Familiar with lake and warehouse internals (columnar stores, Iceberg catalog, partitioning, materializations).
• Builds semantic layers with dbt, Snowflake, or Databricks.
• Python for reusable pipeline and data-app utilities.
• End-to-end ownership, with a quality bar that doesn't stall progress.

Nice To Haves

• Cross-functional data marts and pipelines.
• ClickHouse optimization (materialized views, projections, TTL).
• Manufacturing statistics: SPC, control charts, process capability.
• Data mesh and data-product concepts.
• Orchestration depth (Dagster, Airflow).
• Scaling analytics across multiple sites or business units.
• Background in Operations Research, industrial engineering, or quantitative finance.

Responsibilities

• Architect and maintain the certified dataset layer in dbt: models, tests, documentation, and SLAs the whole company trusts.
• Build well-modeled, context-rich datasets that power self-service analytics, operations research, and LLM-based data apps at company scale.
• Define metric standards: canonical definitions, calculation logic, ownership, refresh cadence.
• Implement canonical data models and semantic layer that scale from 1 to 20+ factories.
• Partner with Data Platform Engineering to harden the unified data platform and set standards.
• Partner with OR Scientists and Data Scientists on feature-set prep and model-output stores.
• Evaluate and recommend analytical tooling (BI platforms, notebook environments, metric layers).
• Define analytical-engineering standards: naming, testing, CI/CD for the dbt project, documentation.
• Mentor the Data Analysts to drive consistency and governance across datasets.

Benefits

• Medical, dental, vision, and life insurance plans for employees
• 401k
• Relocation support may be provided for certain situations, based on business need.
• Flexible vacation policy
• Equity

What This Job Offers

• Job Type: Full-time
• Education Level: No Education Listed