Enterprise Analytics Engineer

Enterprise Analytics Engineer is a hybrid full-time role at Metrea in London, UK, posted 9 Oct 2026.

Company OverviewMetrea 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 SummaryIn 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 DoDesign, develop, and maintain curated Gold-layer data models that provide trusted, analytics-ready data for enterprise reporting and decision-makingDefine, standardize, and govern KPIs, business metrics, and data definitions to ensure consistent reporting across the organizationDesign and implement dimensional data models and star schemas optimized for analytics and reportingTranslate complex business requirements into scalable data models, transformation logic, and reporting solutionsPartner with business and technical stakeholders to ensure data quality, accuracy, consistency, and alignment with business needsDesign and optimize datasets and semantic models for Power BI performance, usability, and scalabilityEstablish and maintain documentation for data definitions, business rules, data lineage, and model relationshipsInventory, catalog, and organize existing Power BI reports, dashboards, datasets, and analytics assets to improve discoverability, governance, and reduce duplicationWhat You BringMinimum of 3 to 5 years of Computer Science, Management of Information Systems, Application Development, Data Analytics or related technical experienceBS in Computer Engineering, Computer Science, Data Engineering, Data Scientist, or a technical degree, or equivalent experience, is preferredAbility to work independently and as part of a teamA visionary mindset and desire to handle wicked problemsProven ability to estimate and calculate project ROI3+ years of PowerBI report writing and SQL development2+ years of Azure exposureExperience interacting and setting up Microsoft FabricHands-on experience with Dynamics 365 Finance & Operations (D365 F&O) data, including knowledge of core tables, data entities, financial dimensions, table relationships, and extracting / modeling D365 data for Power BI and Microsoft Fabric analyticsSkilled at analyzing data, identifying patterns, and ensuring a high level of accuracy and attention to detail in all workAbility to set priorities, work independently, and consistently deliver results with minimal directionAdditional Eligibility QualificationsPL-300, DP-600, or DP-700 certification is a plus.BenefitsPrivate Medical Insurance Subsided gym membership / plans through Wellhub Electric Car scheme Cycle to work scheme Salary sacrificed pension scheme Free lunch on office days Enhanced Parental Leave 30 days annual PTO plus b/hBonus SchemePersonal development opportunitiesWork Authorization / Security ClearanceThe employee will have the legal right to work in the UK and will be able to produce right to work documentation. AAP/EEO StatementMetrea Management Limited is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or other characteristics protected by law.Position Type and Expected Hours of WorkThis is a full-time position with typical working hours of Monday through Friday, 9:00 a.m. to 6:00 p.m. Hours and work shifts may change in accordance with department and business needs.Work EnvironmentThis job operates in an office setting, 3 days a week.Travel20% travel.Our FirmwareAt Metrea, our single core value is Rooted in Humility, and our four cornerstone attributes are Entrepreneurial, Systematic, Discerning, and Over-Deliver. These form what we call our Teammate Firmware. Just like technical firmware connects software and hardware, our Firmware is the constant interface between our mission and our people. It defines how we show up, how we work together, and how we solve complex problems.Our team Firmware creates a web-like, hyper-collaborative, dynamically hierarchical way of working that helps us adapt quickly, communicate openly, and distribute decision-making to where expertise actually lives. It enables groups to self-organize around hard problems, shift fluidly as priorities evolve, and operate with the trust, curiosity, and discipline required in a complex mission space. This foundation allows us to deliver elegant, effective solutions and uphold our purpose: protecting our precious inheritance. Show more Show less