Enterprise Analytics Engineer

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

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.

• 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
• Design and optimize datasets and semantic models for Power BI performance usability and scalability
• Establish and maintain documentation for data definitions business rules data lineage and model relationships
• Inventory catalog and organize existing Power BI reports dashboards datasets and analytics assets to improve discoverability governance and reduce duplication

• Minimum of 3 to 5 years of Computer Science Management of Information Systems Application Development Data Analytics or related technical experience
• BS in Computer Engineering Computer Science Data Engineering Data Scientist or a technical degree or equivalent experience is preferred
• Ability to work independently and as part of a team
• A visionary mindset and desire to handle wicked problems
• Proven ability to estimate and calculate project ROI
• 3 years of PowerBI report writing and SQL development
• 2 years of Azure exposure
• Experience interacting and setting up Microsoft Fabric
• Hands-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 analytics
• Skilled at analyzing data identifying patterns and ensuring a high level of accuracy and attention to detail in all work
• Ability to set priorities work independently and consistently deliver results with minimal direction

• Private Medical Insurance
• Subsided gym membership / plans throughWellhub
• 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/h
• Bonus Scheme
• Personal development opportunities

The employee will have the legal right to work in theUKand will be able to producerightto work documentation.

Metrea Management Limitedis 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.

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

This job operates in an office setting 3 days a week.

20% travel.