Data Engineer

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 - Manufacturing the Future

Hadrian is building autonomous factories to reindustrialize America. By combining AI, advanced software, robotics, and full-stack manufacturing, we help aerospace and defense companies build rockets, satellites, aircraft, ships, and other mission-critical systems up to 10x faster and at significantly lower cost.

Following our $1.37B Series D at a $7.87B valuation, Hadrian is rapidly expanding our manufacturing footprint, launching new capabilities across welding, casting, forging, electronics, additive manufacturing, and more, while scaling our Factory-as-a-Service platform to transform how critical products are built.

Backed by leading investors including JPMorgan Chase, Valor Equity Partners, Andreessen Horowitz, Founders Fund, 137 Ventures, Lux Capital, T. Rowe Price, and Morgan Stanley, we’re building the future of American manufacturing—and looking for exceptional people to help make it happen.

If you’re ready to take on the most challenging and rewarding work of your career while helping create American manufacturing jobs for generations to come, you’re exactly who we’re looking for.

The Role

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.

What You’ll Do

• 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.

What We’re Looking For

• 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.

What Will Set You Apart

• 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.

Compensation

For this role, the target salary range is $150,000- $230,000 (actual range may vary based on experience).

This is the lowest to highest salary we reasonably and in good faith believe we would pay for this role at the time of this posting. We may ultimately pay more or less than the posted range, and the range may be modified in the future. An employee's pay position within the salary range will be based on several factors, including, but not limited to, relevant education, qualifications, certifications, experience, skills, geographic location, performance, and business or organizational needs.

Benefits for Full-time Employees

• 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

ITAR Requirements

To conform to U.S. Government space technology export regulations, including the International Traffic in Arms Regulations (ITAR) you must be a U.S. citizen, lawful permanent resident of the U.S., protected individual as defined by 8 U.S.C. 1324b(a)(3), or eligible to obtain the required authorizations from the U.S. Department of State. Learn more about the ITAR here.

Use of AI in hiring

Hadrian uses AI-assisted tools in our recruiting and hiring processes to help our team work more efficiently. This may include tools that help organize and analyze recruiting data, as well as an AI-powered notetaker that can record and transcribe interviews and help coordinate feedback. These tools support our team and are not used to make hiring decisions. All candidate evaluations and hiring decisions are performed by humans. If an interview will be recorded, you will be notified in advance and may opt out at any time with no impact on your candidacy. Candidate data processed through these tools is subject to the same protections described in our Privacy Policy.

Hadrian Is An Equal Opportunity Employer

It is the Company’s policy to provide equal employment opportunity for all applicants and employees. The Company does not unlawfully discriminate on the basis of race inclusive of traits historically associated with race (including, but not limited to, hair texture and protective hairstyles, such as braids, locks and twists), color, religion, sex (including pregnancy, childbirth, or related medical conditions), gender identity, gender expression, transgender status, national origin (including, in California, possession of a drivers license), ancestry, citizenship, age, physical or mental disability, height or weight, medical condition, family care status, military or veteran status, marital status, domestic partner status, sexual orientation, genetic information, exercise of reproductive rights, any other basis protected by local, state, or federal laws, or any combination of the above characteristics. When necessary, the Company also makes reasonable accommodations for disabled candidates and employees, including for candidates or employees who are disabled by pregnancy, childbirth, or related medical conditions.