Enterprise Analytics Engineer

About the role

The Enterprise Analytics Engineer will own the business logic and semantic data layer for enterprise reporting. This role involves writing custom SQL views to merge data from disparate systems and transforming it into dashboards that support decision-making across the organization.

Responsibilities

• Design, develop, and maintain curated Gold-layer data models for enterprise reporting.
• Define, standardize, and govern KPIs, business metrics, and data definitions.
• Design and implement dimensional data models and star schemas.
• Translate complex business requirements into scalable data models and reporting solutions.
• Partner with stakeholders to ensure data quality, accuracy, and alignment with business needs.
• Design and optimize datasets and semantic models for Power BI performance.
• Establish and maintain documentation for data definitions, business rules, and data lineage.
• Inventory and organize existing analytics assets to improve discoverability and governance.

Required skills

• SQL
• Power BI
• Azure
• Microsoft Fabric
• Dynamics 365 Finance & Operations
• Dimensional modeling
• Data governance

Nice to have

• Data modeling

Qualifications

• Bachelor's degree in Computer Engineering, Computer Science, Data Engineering, Data Science, or a related technical field
• Equivalent practical experience

Certifications

• PL-300
• DP-600
• DP-700

Benefits

• Private Medical Insurance
• Subsidised gym membership
• Electric Car scheme
• Cycle to work scheme
• Salary sacrificed pension scheme
• Free lunch on office days
• Enhanced Parental Leave
• 30 days annual PTO
• Bonus Scheme
• Personal development opportunities

About the Company

Metrea delivers effects-as-a-service to national security partners across five domains and more than a dozen mission areas. They own the full stack, from design to operation, to provide turnkey capabilities for complex mission challenges.