Senior Data Analyst

Ofgem; Cardiff, Glasgow, Greater London; Hybrid; GBP 49,000 - 57,000; Full time

Benefits offered by this job

Hybrid working

Civil Service pension

Training and development

Job summary

Ofgem is seeking a Senior Data Analyst to lead high-impact analytical work across the DDSS directorate. You will design and deliver data products, ensure data quality, and promote self-service analytics through trusted models.

You will engage with stakeholders to translate needs into scalable analytics and strengthen Ofgem’s data maturity. You will guide junior colleagues, collaborate on governance and security standards, and explore emerging tools to deliver value in a data-driven regulatory

Qualifications

• Experience leading analytical initiatives across teams and delivering insight-driven outcomes.
• Ability to translate complex data into actionable recommendations for diverse stakeholders.
• Proficient in data governance and ethics within analytics projects.
• Strong collaboration and leadership to build data analytics capability.

Responsibilities

• Lead the design, build, testing and delivery of analytical products (dashboards, reports, visuals).
• Manage data quality: cleaning, transforming, modelling, QA.
• Present findings clearly to customers and enable self-service analytics through semantic models.
• Promote data governance, information security standards and best practices.
• Collaborate with users to refine requirements and deliver measurable value.
• Provide technical leadership and coaching to junior colleagues.
• Explore new tools (Copilot Studio, ArcGIS) to strengthen analytical capability.

Skills

Data analysis leadership

Stakeholder engagement

Statistical techniques

Requirements gathering

Agile delivery

Data governance

Tools

Power BI

Azure Synapse

Power Query

ArcGIS

Python

Job description

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

Job summary

Across government, the role of data analysis has become central to how organisations understand problems, shape policy and deliver high-quality digital and operational services. As data volumes grow and analytical tools become more sophisticated, there is an increasing need for strong analytical leadership to ensure that data is used effectively, ethically and in ways that drive real organisational impact. Modern data analysis is no longer confined to reporting; it is fundamental to enabling insight-driven decision making, improving services and supporting strategic transformation.

At Ofgem, data plays a critical role in delivering our mission to protect energy consumers and support the transition to a more secure, fair and sustainable energy system. As we continue to develop our digital, data and technology capabilities, the ability to harness data effectively is key to understanding the energy market, informing regulatory decisions and enabling innovation. Within the Digital, Data and Security Services (DDSS) directorate, we are investing in our data capability to embed consistent, high-quality analytical practices across the organisation.

As a Senior Data Analyst, you will lead the delivery of high-impact analytical work, supporting both operational and strategic decision making. You will work across teams and business areas to design, build and deliver data products that provide clear, actionable insights, while ensuring that data is managed, prepared and used in line with best practice and governance standards.

This is a hands-on and influential role, combining strong technical expertise with the ability to engage and influence a wide range of stakeholders. You will play a leading role in advancing Ofgem’s data maturity, promoting self-service analytics and helping to build a more data-driven culture across the organisation.

You will be responsible for:

• Leading the design, build, testing and delivery of analytical products, including dashboards, reports, scorecards, visualisations and alerts, using modern data analytics technology such as Power BI, Azure Synapse, Power Query, GIS and Python to answer strategic business questions
• Ensuring quality of service by managing, cleaning, abstracting, aggregating, transforming, modelling and quality assuring data, and using that knowledge to develop and conduct analytical studies
• Presenting the results of data analysis and conclusions logically and concisely, in the most appropriate format for a range of customers, enabling informed decision making, upskilling and effective self-service analytics through trusted semantic models, shared understanding and reusable analytical products
• Interpreting, applying and promoting data governance, data ethics, information security standards, policies and procedures in all analytical work
• Working closely with users and stakeholders to understand business needs, refine analytical requirements and drive outcome-led development, delivering solutions that provide measurable value
• Providing technical leadership in data analysis, managing, coaching and guiding junior colleagues while promoting best practice across the team
• Coordinating and contributing to research, development and continuous improvement activities, including exploration of emerging tools and capabilities such as Copilot Studio and ArcGIS, to strengthen Ofgem’s analytical capability

We are looking for an experienced data analyst with strong technical and analytical skills, and a proven ability to deliver high-quality insight in complex environments. You will have significant experience of applying statistical and analytical techniques to real‑world problems, and be confident working with large and complex datasets.

You will bring strong experience of data visualisation, particularly using tools such as Power BI, and the ability to present complex information in a clear, engaging and accessible way. Your communication skills will enable you to work effectively with a wide range of stakeholders, translating business needs into analytical solutions and explaining findings to non‑specialist audiences.

You will also have a strong understanding of data governance, data management and information security, ensuring that data is handled appropriately and in line with organisational and regulatory requirements. Experience of working in agile, iterative environments and delivering value early will support your success in this role.

In addition, you will demonstrate a commitment to developing others and contributing to the growth of data capability within your team and across the organisation. Your ability to combine technical expertise with collaboration and leadership will be key to delivering impact.

This is an opportunity to play a key role in shaping how Ofgem uses data to inform decisions and deliver outcomes. Your work will directly support the organisation’s ability to operate more effectively, respond to emerging challenges and deliver better outcomes for consumers at a time when data-driven insight has never been more important.

Person specification

• Experience of data visualisation software to develop complex reports and dashboards, e.g. Power BI. (Lead Criteria)
• Experience of communicating effectively with technical and non-technical stakeholders and knowledge of how to manage complex stakeholder engagement. (Lead Criteria)
• Significant experience of applying appropriate statistical and analytical techniques to answer research questions and organisational needs.
• Experience of identifying business requirements, leading on identifying the required action within appropriate data governance requirements.
• Demonstrable evidence of contributing to building data analytics capability.
• Demonstrable experience of delivering in an agile, iterative manner that delivers value early.

Behaviours

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

• Communicating and Influencing
• Developing Self and Others
• Delivering at Pace

Technical skills

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

• You will also be asked to complete a technical test. Details will be included in the invitation to interview.

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

Benefits

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

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.