Job Description

Details

-----------

Reference number

420574

Salary

47,895 - 62,699
National 47,895-58,519


London 50,748-62,699. Please ensure that you read the Pay and Reward information for civil service and internal colleagues before applying.
A Civil Service Pension with an employer contribution of 28.97%
GBP

Job grade

Grade 7
Level 2b

Contract type

Permanent

Business area

Financial Resilience & Controls directorate - Markets Strategic Data team

Type of role

Analytical


Architecture and Data

Information Technology

Working pattern

Flexible working, Full-time

Number of jobs available

1

Contents

------------

Location About the job Benefits Things you need to know Apply and further information

Location

------------


Successful candidates may be based in any of our office locations - Cardiff, Glasgow, or London. We especially welcome applicants from Cardiff and Glasgow.

About the job

-----------------

Job summary

At the heart of the energy market, data tells the story of the challenges consumers face and how we at Ofgem fight to protect them. We're looking for a Senior Data Modeller to join us and lead on shaping the data frameworks that underpin key regulatory decisions, strengthening our ability to respond to issues that affect millions of households.



Ofgem is Great Britain's independent energy regulator. We're at the forefront of change across the energy sector, driving toward Net Zero whilst protecting energy consumers, especially vulnerable people.



We're offering a permanent position with the chance to work at the centre of one of the most vital data initiatives in the UK's energy landscape. As part of our Markets Data Office, you'll play a critical role in ensuring that our data structures reflect real-world needs and support powerful, evidence-based decision making. This is an opportunity to drive smarter, more consistent use of data across our organisation.



You'll be part of an interdisciplinary team delivering a collaborative service that helps Ofgem's Markets Directorate users "do data better." Working alongside analysts, data professionals, and stakeholders, you'll create scalable models that support major areas of our work and help ensure we can act quickly and decisively in response to market shifts.



We're looking for someone with strong technical skills and the ability to translate complex business needs into clear, robust data models. You'll be confident working across diverse teams and equally comfortable engaging technical colleagues and non-technical decision-makers, all while promoting best practice in data strategy and structure.



Join a team that's inquisitive, collaborative and committed to improving the way we use data. Based in London, Glasgow or Cardiff, we offer hybrid working, a welcoming and inclusive culture, and a strong focus on meaningful impact through data-led transformation.



We have a critical purpose to enable consistent, scalable, and business-aligned data structures across the energy market. In this role, you'll help ensure that vital consumer data is structured, accessible, and actionable, strengthening our ability to safeguard fairness and transparency across the sector.



Read on and find out more.

Job description

Key Responsibilities

Develop and maintain the Markets strategic data model (conceptual) to provide a high-level view of data domains, entities and their relationships, and related logical data models with detailed attributes, data relationships, and normalization rule, ensuring alignment with business rules and objectives. Work closely with business stakeholders to understand data requirements and translate them into structured data model artifacts that meet organisational needs. Ensure conceptual and logical data models are reusable, scalable and adaptable to evolving business demands. Partner with business stakeholders, SMEs and enterprise data architects to validate data models and incorporate feedback. Collaborate with technology colleagues on model implementation in the data ecosystem housing Markets data. Support data services created and delivered by the Markets Data Office to help Markets data users do data better.

Person specification

Essential Criteria

Strong experience in developing conceptual data models, defining data domains, entities and their relationships. (Lead criteria) Strong experience of translating business users needs to structured data model artifacts. (Lead criteria) Demonstrable experience using data modelling tools and industry standard techniques to capture and document data artefacts. Demonstrable experience working successfully in cross-functional teams and collaborating with a wide variety of stakeholders. Ability to communicate in technical detail on topics of data lineage, data usage, and data structures.

Desirable Criteria

Track record of working within a cloud-based technology landscape. Experience in integrating complex, cross-organisation processes and data models, ideally within a highly regulated environment.

Behaviours

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


Seeing the Big Picture Changing and Improving Working Together Delivering at Pace

Benefits

------------


Alongside your salary of 47,895, OFGEM contributes 13,875 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.
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

---------------------------

Selection process details

This vacancy is using Success Profiles , and will assess your Behaviours and Experience.
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 then be asked to provide a 1250 word 'personal statement' evidencing how you meet the essential and desirable skills and capabilities listed in the role profile. Please ensure you demonstrate clearly, within your supporting statement, how you meet each of the essential and desirable skills and capabilities.


The Civil Service values honesty and integrity and expects all candidates to abide by these principles. You must ensure that any evidence submitted as part of your application or used during interview, including your CV and any statements or examples, are truthful and factually accurate. Ofgem takes any incidences of cheating very seriously. Please ensure all examples provided are of your own experience. Any instances of plagiarism or other forms of cheating will be investigated and, if proven, the relevant applications will be withdrawn from the process. Please note that plagiarism can include presenting the ideas and experiences of others, or generated by artificial intelligence, as your own.


Please refer to Civil Service candidate advice on the acceptable use of artificial intelligence within the recruitment and selection process - Artificial intelligence and recruitment , Civil Service Careers

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

].



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

Security

Successful candidates must undergo a criminal record check.
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) 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

Working for the Civil Service

The Civil Service Code sets out the standards of behaviour expected of civil servants.



We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles .
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 and the Civil Service Diversity and Inclusion Strategy .

Apply and further information

---------------------------------


This vacancy is part of the Great Place to Work for Veterans 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 : Jamie Wright Email : recruitment@ofgem.gov.uk
#

Recruitment team

Email : recruitment@ofgem.gov.uk

Further information

Appointment to the Civil Service is governed by the Civil Service Commission's 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 recruitment@ofgem.gov.uk. 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.