Semantic Data Engineer: Scalable Factory Analytics

Hadrian Automation; Los Angeles (CA); On-site; USD 150,000 - 230,000; Full time

Benefits offered by this job

Medical, dental, vision, and life

401k

Relocation support may be provided

Flexible vacation policy

Equity

Job summary

Hadrian is seeking a data analytics leader to architect and own the semantic and metric layer, defining canonical metrics, data contracts, and CI/CD for the dbt project.

You will build certified data marts and model datasets at scale, from 1 to 20+ factories, enabling trusted analytics for dashboards and AI applications. You will mentor analysts and collaborate with Data Platform Engineering to ensure data quality.

Qualifications

• Production ownership of data models.
• Expert SQL with performance tuning.
• Experience with Spark, dbt, and Dagster.
• Strong data-modeling foundation.
• Familiar with lake and warehouse internals.
• Builds semantic layers with dbt, Snowflake, or Databricks.
• Python for reusable pipeline and data-app utilities.
• End-to-end ownership with a quality bar.

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.

Skills

SQL

dbt

Spark

Dagster

Python

Data modelling

Snowflake

Databricks

ETL pipelines

Tools

dbt

Snowflake

Databricks

Dagster

Airflow

Job description

Hadrian is seeking a data analytics leader to architect and own the semantic and metric layer, defining canonical metrics, data contracts, and CI/CD for the dbt project.

You will build certified data marts and model datasets at scale, from 1 to 20+ factories, enabling trusted analytics for dashboards and AI applications. You will mentor analysts and collaborate with Data Platform Engineering to ensure data quality.