Senior Analytics Engineer: Data Modeling & Platform Lead

Ofgem; Cardiff, Greater London, Glasgow; Hybrid; GBP 75,000 - 110,000; Full time

Benefits offered by this job

Hybrid work

Office locations in Cardiff/London/Gla

Travel to office as needed

Job summary

Ofgem is seeking a Lead Analytics Engineer to shape data structures, modelling and consumption across the organisation. You will define standards, drive best practice and lead analytical data modelling for reporting, AI and BI.

This senior, hands-on role combines data engineering with stakeholder engagement, in a cloud-first environment using Azure Data Factory and Synapse. You will mentor colleagues and ensure data quality, governance and reusability.

Qualifications

• Experience designing and optimising complex data models in a cloud-based environment.
• Strong experience with Azure Data Factory and Azure Synapse Analytics.
• Proficiency in Python and SQL for data transformation and analysis.
• Ability to translate business needs into scalable data solutions.

Responsibilities

• Leading the design, build and maintenance of analytical data models that support reporting, analytics, AI and BI.
• Working with stakeholders to understand business processes and translate requirements into effective data structures and models.
• Developing and maintaining data transformation standards across platforms such as Azure Data Factory, Azure Synapse and related technologies.
• Ensuring data quality, consistency and interoperability, enabling reuse and effective analysis across the organisation.
• Collaborating with data engineers, data scientists and analysts to ensure alignment between platform design and analytical needs.
• Driving continuous improvement in data modelling, transformation and analytics engineering practices.
• Establishing and maintaining standards for documentation, ensuring transparency and maintainability of data solutions.
• Supporting metadata management, ensuring that data assets are discoverable, well‑defined and effectively governed.
• Identifying and resolving issues within data pipelines and models, implementing preventative measures and optimisations.
• Providing technical leadership and guidance to colleagues, promoting best practice and building capability across teams.

Skills

Analytics engineering

Data modelling

Data transformation

Stakeholder engagement

Python

SQL

Data governance

Cloud data platforms

Tools

Azure Data Factory

Azure Synapse Analytics

Python

SQL

Job description

Ofgem is seeking a Lead Analytics Engineer to shape data structures, modelling and consumption across the organisation. You will define standards, drive best practice and lead analytical data modelling for reporting, AI and BI.

This senior, hands-on role combines data engineering with stakeholder engagement, in a cloud-first environment using Azure Data Factory and Synapse. You will mentor colleagues and ensure data quality, governance and reusability.