Description
Across government, analytics engineering is playing an increasingly important role in transforming how organisations use data to inform decisions, deliver insight and enable digital services.
As a Lead Analytics Engineer at Ofgem, you will play a key role in shaping how data is structured, modelled and consumed across the organisation. You will lead the design and implementation of analytical data models, working closely with stakeholders and multidisciplinary teams to ensure data supports both operational and strategic needs.
Responsibilities:
- Leading the design, build and maintenance of analytical data models that support reporting, analytics, AI and business intelligence.
- 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.
Requirements:
- Experience designing and optimising complex data models in a cloud-based environment.
- Strong experience with tools such as Azure Data Factory, Azure Synapse Analytics or equivalent platforms.
- Experience working with programming languages such as Python and SQL.
- Knowledge of data transformation, modelling and metadata management practices.
- The ability to balance technical design with business needs and stakeholder requirements.
- Strong communication skills, with the ability to translate technical concepts into clear, actionable insights.
Benefits:
- Salary of £49,452 - £62,699 per year.
- Contribution of £14,326 towards Civil Service Defined Benefit Pension scheme.
- 30 days annual leave after 2 years.
- Excellent training and development opportunities.
- Hybrid working (currently 1 day a week in the office).
- Flexible working hours and family friendly policies.