Back to jobs

Enterprise Analytics Engineer

Pay
Pay not listed
Work setting
Not stated
Employment
Full-time — employment source
Position Type and Expected Hours of Work 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. Work Environment
Read the full posting

Before you apply

Work authorization
Must already have the right to workWork Authorization / Security Clearance

What you’ll work on

Full posting

In this role you will primarily be responsible for owning the business logic and semantic data layer for our Enterprise reporting.

  • Design and maintain curated Gold-layer data models for enterprise reporting

  • Write custom SQL views that merge data across systems in the data lake

  • Define and govern KPIs, business metrics and data definitions

  • Build dimensional models and star schemas for analytics

  • Optimize datasets and semantic models for Power BI performance

From the employer’s posting
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
writing custom SQL views that merge data between disparate systems in our data lake
Define, standardize, and govern KPIs, business metrics, and data definitions
Design and implement dimensional data models and star schemas optimized for analytics and reporting
Design and optimize datasets and semantic models for Power BI performance

What you’ll bring

All qualifications

Core experience

  • Ability to work independently and as part of a team
  • 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
Qualification wording
Ability to work independently and as part of a team
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
Education & alternatives
- 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

Benefits in the posting

Full benefits wording
  • Private Medical Insurance
  • Subsided gym membership / plans through Wellhub
  • Electric Car scheme
  • Cycle to work scheme

From the employer’s posting.

Apply at Metrea

Posting record

Report an error
Status in our records
Live
First seen by us
Oct 9, 202625 days ago
Recorded sightings
54
Last seen by us
Nov 3, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 25

Similar jobs usually come down between day 6 and day 47.

From 1,409 similar postings that came down. Coming down is not always a hire.

Metrea is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Azure
  • Power BI
Where the posting names them
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
- Proven ability to estimate and calculate project ROI - 3+ years of PowerBI report writing and SQL development - 2+ years of Azure exposure
- 3+ years of PowerBI report writing and SQL development - 2+ years of Azure exposure - Experience interacting and setting up Microsoft Fabric
- 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
- 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 What You Bring
- 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

Your next step

Complete your application on www.metrea.aero. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

About the role

We file this job under Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Job description

View original posting ↗

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
  • 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

What You Bring

  • 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

Additional Eligibility Qualifications

 

PL-300, DP-600, or DP-700 certification is a plus.

Benefits

  • Private 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/h
  • Bonus Scheme
  • Personal development opportunities

Work Authorization / Security Clearance

The employee will have the legal right to work in the UK and will be able to produce right to work documentation.   

AAP/EEO Statement

Metrea 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 Work

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.  

Work Environment

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

Travel

20% travel. 

 

Our Firmware

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

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

London, England

Working pattern and location restrictions need checking in the full posting.

Work authorization
- Personal development opportunities Work Authorization / Security Clearance The employee will have the legal right to work in the UK and will be able to produce right to work documentation. AAP/EEO Statement

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.