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.
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.
Selection process details
This vacancy is using Success Profiles (opens in a new window), 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].
Click 'apply now' to be redirected to the Civil Service Jobs website to apply for the role. Deadline for submissions is 23:55 on 18th August 2025.
