Enterprise Analytics Engineer

Company Overview

Metrea delivers effects-as-a-service to national security partners across five domains and more than a dozen mission areas. These include airborne ISR, electronic warfare, secure communications, aerial refueling, special air missions, aerial firefighting, and advanced simulation. We own the whole stack: designing, building, and operating turnkey capabilities that give our partners decisive, asymmetric advantage against rapidly evolving threats.

Our operating model is built around three interlocking pillars. The Support Groups provide a global shared-service – spanning people, finance, platform, operations, legal, and engagement. This frees up our Core Groups, who develop and own mission capabilities end-to-end, to focus entirely on delivery. The Market Groups apply a regional lens, ensuring that our agile and adaptable capabilities remain aligned to the wicked problems that matter most to our partners across the Americas, EMEA, and Asia-Pacific.

At the heart of our model is a simple but powerful idea: be a true partner with skin in the game. Our partners need effects, not just equipment. By owning the full stack – from the lab to the field – we are able to drive a continuous cycle of innovation that keeps our partners ahead. It's a fast-moving, intellectually demanding environment where talented people are given real responsibility, work on problems that matter, and contribute to an enterprise that is growing quickly and deliberately.

Headquartered in Washington, DC, with facilities across the United States, the United Kingdom, as well as Continental Europe and Asia-Pacific.

Position Summary

In this role you will primarily be responsible for owning the business logic and semantic data layer for our Enterprise reporting. You will be responsible for writing custom SQL views that merge data between disparate systems in our data lake, then transforming this data into elegant dashboards that enable all levels of Metrea to manage their relevant Capability Areas and FILES. 

What You'll Do

• Design, develop, and maintain curated Gold-layer data models that provide trusted, analytics-ready data for enterprise reporting and decision-making
• Define, standardize, and govern KPIs, business metrics, and data definitions to ensure consistent reporting across the organization
• Design and implement dimensional data models and star schemas optimized for analytics and reporting
• Translate complex business requirements into scalable data models, transformation logic, and reporting solutions
• Partner with business and technical stakeholders to ensure data quality, accuracy, consistency, and alignment with business needs