Data Engineer

About the company

Hadrian is a defense tech company building automated manufacturing facilities to mass-produce parts for military vehicles.

About this role

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 author