Lead Analytics Engineer

Job summary

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. By structuring, modelling and optimising data for analysis, analytics engineers ensure that data is accessible, reliable and aligned with business needs. Ofgem plays a vital role in the UKs energy system, protecting consumers and enabling a more secure, fair and sustainable energy future, and strong analytics engineering capability is central to unlocking the value of data.

Ofgem is on an ambitious transformation journey. Within the Digital, Data and Security Services (DDSS) directorate, we are building modern data platforms and analytical capabilities that support data-driven decision-making across the organisation. As our data maturity grows, there is an increasing need to ensure that data is structured effectively, enabling analytics, AI and business intelligence at scale.

As a Lead Analytics Engineer, you will play a key role in shaping how data is structured, modelled and consumed across Ofgem. 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. You will define standards, drive best practice and contribute to the continuous improvement of data transformation and modelling processes.

This is a senior, hands-on technical role that combines data engineering, analytics and stakeholder engagement. You will work across complex data environments, ensuring that data is optimised for use while maintaining quality, consistency and governance.

Job description

You will be responsible for:

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

We are looking for:

A technically strong and analytically minded professional who can lead the development of robust, scalable data models in a modern cloud environment. You will bring experience in analytics engineering or data engineering, alongside the ability to work closely with stakeholders to deliver practical solutions.

You may come from a data engineering, analytics or BI background, but you will demonstrate:

• 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
• Experience in government or regulated environments, and in supporting analytics, AI or business intelligence use cases, would be beneficial.

This is an opportunity to play a key role in shaping how Ofgem uses data to support decision-making and innovation. You will ensure that data is structured and accessible in a way that enables insight, driving value across the organisation at a time when data capability has never been more important.

Person specification

Essential Criteria

• Knowledge and experience of optimising complex data models in a modern cloud environment (Lead Criteria)

• Practical experience of working with OFGEMs primary toolset (e.g. Azure Data Factory, Azure Synapse Analytics) (Lead Criteria)

• Knowledge and experience of continuous improvement techniques for complex systems

• Experience of metadata management

• Experience of coding programs, scripts and/or components for a complex platform/codebase using Python. Experience with SQL is desirable.

Desirable Criteria

• Experience of communicating technical concepts in a non-technical language.

#LI-DNI

Behaviours

We'll assess you against these behaviours during the selection process:

• Making Effective Decisions
• Working Together
• Managing a Quality Service

Technical skills

We'll assess you against these technical skills during the selection process:

• You will also be asked to conduct a Technical Test. Full details of the Technical Test will be disclosed if you progress through sift stage.

Benefits

Alongside your salary of 49,452, OFGEM contributes 14,326 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides (opens in a new window).

Ofgem can offer you a comprehensive and competitive benefits package which includes; 30 days annual leave after 2 years; Excellent training and development opportunities; The opportunity to join the generous Civil Service pension which also includes a valuable range of benefits; hybrid working (currently 1 day a week in the office but this is kept under review), flexible working hours and family friendly policies. Plus lots of other benefits including clean and bright offices based centrally, engaged networks and teams and an opportunity to contribute to our ambitious and important targets of establishing a Net Zero energy system by 2050. This exciting blend of professional challenge and personal reward identifies career opportunities at Ofgem as something to get excited about.

Things you need to know

Artificial intelligence
Artificial intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, as your own) applications may be withdrawn and internal candidates may be subject to disciplinary action. Please see our candidate guidance (opens in a new window) for more information on appropriate and inappropriate use.

Selection process details

This vacancy is using Success Profiles (opens in a new window) , and will assess your Behaviours, Experience and Technical skills.

When you press the Apply now button, you will be asked to complete personal details (not seen by the sift panel), your career history and qualifications.

You will also be asked to provide a 1250 word supporting statement evidencing how your experience meets the essential and desirable criteria on the attached role profile. Please ensure you demonstrate clearly how you meet each of the person specification criteria.

The personal information we have collected from you will be shared with Cifas who will use it to prevent fraud, other unlawful or dishonest conduct, malpractice, and other seriously improper conduct. If any of these are detected, you could be refused certain services or employment. Your personal information will also be used to verify your identity. Further details of how your information will be used by us and Cifas, and your data protection rights, can be found by [ https://www.cifas.org.uk/fpn ].

At Ofgem, we expect our staff to carry out their roles with honesty, fairness and openness. They should follow the Civil Service code and be free from any influence or bias. We are committed to making sure interests are recognised, declared and managed appropriately so that we can fulfil our duties as an energy regulator. Our Conflicts of Interest policy outlines the types of interests Ofgem staff must declare before onboarding, and the rules they must follow throughout employment so that we can clearly demonstrate that our decisions are not influenced by private interests.

Feedback will only be provided if you attend an interview or assessment.

Security

Successful candidates must undergo a basic (or equivalent) criminal record check.

Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window) .

See our vetting charter (opens in a new window) .

People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Nationality requirements

This job is broadly open to the following groups:

• UK nationals
• nationals of the Republic of Ireland
• nationals of Commonwealth countries who have the right to work in the UK
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window)
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
• individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
• Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Further information on nationality requirements (opens in a new window)

Working for the Civil Service

Please note this Post is NOT regulated by the Civil Service Commission.

The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.

The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.

Diversity and Inclusion
The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window) .

Apply and further information

This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative.

The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment (opens in new window) .

Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Contact point for applicants
Job contact :

• Name : Amber Shankland
• Email : [email protected]

Recruitment team

• Email : [email protected]

Further information

Appointment to the Civil Service is governed by the Civil Service Commissions Recruitment Principles. You have the right to complain if you feel there has been a breach of these Recruitment Principles. In the first instance, you should raise the matter directly via [email protected]. If you are not satisfied with the response, you may bring your complaint to the Commission. For further information on bringing a complaint to the Civil Service Commission, please visit their website.

Attachments DDSS Role Profile Lead Analytics Engineer (2B) Opens in new window (pdf, 205kB) DDSS Candidate Pack, Lead Analytics Engineer Opens in new window (pdf, 3442kB) Terms and Conditions Opens in new window (pdf, 335kB)