Effective use of data is at the centre of our work to bring about a Net Zero energy supply. 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.
As a Data Insight Analyst, you’ll be joining our dynamic and high performing Analytics team. This fast-paced, cross-functional group is at the forefront of delivering impactful insights across Ofgem. With a diverse and knowledgeable makeup, the team plays a key role in accelerating data-driven decision-making, leveraging emerging technologies to drive digital transformation, and enabling self-service analytics.
In this role, you’ll design, build, test and deploy new analytic products, while also maintaining existing ones. You’ll be responsible for developing dashboards, reports, visualisations and alerts that support strategic decision-making using technologies such as Power BI, Azure Synapse, SQL and Python.
You’ll work with a variety of data sources and pipelines to deliver meaningful analysis, uncovering trends, enabling drilldowns and generating forecasts. Your expertise will also contribute to training sessions, where you’ll share techniques and best practices with others.
With a solid foundation in statistics, you’ll bring a keen interest in how data, analytics and visualisation can influence decisions. Ideally, you’ll have certified experience with visualisation tools and be confident in communicating and presenting your findings to both technical and non-technical audiences.
You’ll be adept at managing and prioritising multiple projects and stakeholders, preferably with experience in data modelling, SQL for data transformation, and data science tools such as Python.
In this role, you will be part of our DDaT Profession, where you will be supported across the profession with personal and professional learning and development opportunities. This is a great role to start your career within data with lots of room for progression.
Job description
This Role:
The Data Insights Analyst role sits in the Analytics team within Data & AI function and plays a key role accelerating data driven decision making, digital transformation and enable self-service analytics across Ofgem. They will aid in the design and development of analytic products such as dashboards, reports, visualisations and alerts to answer strategic business questions using a range of modern data analytics technology e.g. Power Bi, Azure Synapse and Python.
The individual in this role will adhere to internal D&AI team best practices and standards, highlighting to the community where improvements could be made and participating in peer reviews. They will support their colleagues to promote and champion good data practice throughout Ofgem e.g. data collection standards, data visualisation, data management and operations.
Key Responsibilities
- Partner with business users to design analytics products and embed insights into decision making processes.
- Design, build and test data products such as Power BI dashboards, semantic models and database views.
- Collaborate with the Data Engineering and Operations team to triage, troubleshoot and resolve support issues with products.
- Identify and present opportunities for improvements and enhancements to process and product.
- Contribute to expanding Ofgem's analytics and AI capabilities through research and innovation.
Key Outputs and Deliverables
- Development of data products and supporting documentation.
- Lead or contribute to resolving issues in data products to ensure reliability and performance.
- Support the development of data collection templates, data pipelines and automation routines.
- Support the validation of user requirements and their technical design.
- Create engaging materials to promote data product adoption across Ofgem, participate in show & tells, workshops and roadshows.
Person specification
Essential Criteria
- Extensive experience of using data visualisation software such as Power BI to develop reports and dashboards. (Lead criteria)
- Experience working with complex data models (ideally in Azure Synapse), writing SQL to manipulate and transform data, in order to create semantic models optimised for Power BI consumption.
- Good communication skills, ability to explain technical concepts and confident in presenting insights to both technical and non-technical users.
Desirable Criteria
- Experience working in an agile team with ability to manage multiple work items and prioritise effectively.
- Certification in Power BI.
Behaviours
We'll assess you against these behaviours during the selection process:
- Changing and Improving
- Making Effective Decisions
- Working Together
Technical skills
- At interview, you will be presented with a technical scenario to work through and discuss with the panel. Follow-up questions will be included. No prior preparation is required.
Benefits
Alongside your salary of £34,123, OFGEM contributes £9,885 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, Ability, Experience and Technical skills.
When you press the ‘Apply now’ button, you will be directed to two Civil Service tests – guidance for these can be found here Civil Service online tests - GOV.UK (www.gov.uk). Upon passing the tests, you will be asked to complete the full application, which includes uploading a copy of your anonymised CV and your 1250-word personal statement.
The 1250 word ‘personal statement' should evidence how you meet the essential and desirable skills 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.
