Data Engineer, Semantic Layer for Scaled Manufacturing

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

Benefits offered by this job

Medical, dental, vision, and life ins.

401k

Relocation support

Flexible vacation policy

Equity

Job summary

Hadrian is building autonomous factories to reindustrialize America. Our Data Analytics team owns the semantic layer that turns raw factory data into metrics you can trust.

You will architect and own the canonical definitions, calculation logic, and refresh cadence that keep dashboards and the AI Analyst aligned. You will build certified data marts, model them dimensionally, and ensure consistent definitions across multiple factories and dashboards.

Qualifications

• Production ownership of data models across multiple factories and dashboards.
• Expert SQL with performance and cost awareness in large datasets.
• Experience shipping production data pipelines with Spark, dbt, and Dagster or equivalents.
• Strong data-modeling foundation (normalization, denormalization, star/snowflake schemas).
• Familiarity with lake and warehouse internals (columnar stores, Iceberg catalog, partitioning).
• Construct semantic layers with dbt, Snowflake, or Databricks.
• Proficiency in Python for reusable pipeline and data-app utilities.
• End-to-end ownership with a strong quality bar.

Responsibilities

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

Skills

Expert SQL

Data modeling

dbt

Spark

Dagster

Snowflake

Databricks

Python

Tools

dbt

Spark

Dagster

Snowflake

Databricks

Job description

Hadrian is building autonomous factories to reindustrialize America. Our Data Analytics team owns the semantic layer that turns raw factory data into metrics you can trust.

You will architect and own the canonical definitions, calculation logic, and refresh cadence that keep dashboards and the AI Analyst aligned. You will build certified data marts, model them dimensionally, and ensure consistent definitions across multiple factories and dashboards.