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 We'll assess you against these technical skills during the selection process: 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. Things you need to know 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. 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) (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 The Civil Service Code (opens in a new window) 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 (opens in a new window). 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 : 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 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 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. Attachments Role Profile_Data Insight Analyst Opens in new window (pdf, 95kB) Terms and Conditions April 2025 Opens in new window (pdf, 335kB) Candidate Pack - Data Insight Analyst Opens in new window (pdf, 1291kB)