Data Engineer

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…