About the role

  • Senior Analytics Engineer at Bauer Media Outdoor transforming data into trusted datasets for decision making. Design and maintain data models, ensuring analytical usability and quality across the business.

Responsibilities

  • Design, build and maintain scalable dimensional and analytical data models
  • Define and enforce data grain, keys and relationships
  • Own slowly changing dimensions, historisation strategies and conformed dimensions
  • Translate business requirements into clear, well documented and high performing models
  • Create and maintain a stable Gold layer suitable for Power BI and downstream analytics
  • Profile staged datasets to assess completeness, accuracy and consistency
  • Define and implement validation rules and data quality checks
  • Partner with upstream engineers to resolve issues at the right layer
  • Act as the gatekeeper for what is considered analytics ready data
  • Build and optimise datasets specifically for Power BI consumption
  • Ensure metrics are clearly defined, consistent and reusable
  • Reduce duplication and semantic drift across reports
  • Work closely with analysts to ensure models are intuitive and performant
  • Work closely with stakeholders across Finance, Commercial and Operations to clarify definitions, validate assumptions, sense check outputs, and translate business questions into structured, modelled datasets
  • Be the bridge between technical teams and business users.

Requirements

  • Deep SQL expertise, including complex transformations, window functions and performance tuning in a cloud environment
  • Proven experience designing analytical or data warehouse models
  • Strong dimensional modelling knowledge such as Kimball approaches, star schemas and aggregates
  • Experience working with BI tools, ideally Power BI
  • Hands on ownership of curated data layers used by the business
  • Strong understanding of data quality, profiling and validation techniques
  • Confident communicator, comfortable engaging senior stakeholders and non technical users

Benefits

  • Hybrid working model with regular office presence to build team culture and relationships.
  • 25 paid holidays
  • Company Pension Scheme paid up to 8%
  • Healthcare Cash Plan
  • Life Insurance and group income protection scheme
  • Cycle to work scheme
  • Enhanced Maternity & Paternity Cover

Job title

Senior Analytics Engineer

Job type

Experience level

Senior

Salary

Not specified

Degree requirement

No Education Requirement

Tech skills

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job