Data Insights Analyst

Cardiff, Glasgow, London

Effective use of data is at the centre of our work to bring about a Net Zero energy supply. 

As a Data Insights Analyst you’ll be working in our new, dynamic and growing Analytics team. It’s a team that’s cross-functional, diverse and knowledgeable, where you will accelerate data driven decision making, digital transformation and enable self-service analytics across Ofgem. You’ll be responsible for designing and developing dashboards, reports, visualisations and alerts in support of our strategic decision making – using tech such as: Power Bi, Azure Synapse, Python and Qlik Sense.

In this role you’ll design, build, test and deploy new analytic products and help maintain existing ones. Having discovered/accessed the data sources and pipelines you’ll deliver the analysis – looking for trends, drill downs and creating forecasts. Your exemplary techniques will contribute to training events – sharing techniques and expertise.

With knowledge of mathematics and statistics you’ll have a keen interest in how data, analytics and visualisation can drive decision making – ideally with some certificated experience of using visualisation software. You’re an analyst who can also communicate and present well – managing and prioritising multiple projects at once. Ideally you’ll also have knowledge and experience of data modelling, SQL for data transformation and data science (Python or R).

Within this role you will be part of our DDaT Profession where you will be supported across the profession with learning and development, personal development and this is a great role to start your career within data, with lots of room for progression. 

Ofgem works on behalf of energy consumers to ensure that every household and business in the UK can rely on a safe, affordable and environmentally sustainable energy supply. We are playing a vital part in accelerating the transition to Net Zero and a carbon neutral energy system – a goal that everyone wants to achieve. Whatever your role, you’ll be playing your part in creating new energy solutions that are great for customers and the environment.

We offer a diverse range of flexible working career opportunities: roles that are stimulating and rewarding, where you can get involved in ground-breaking work. And it’s important to us that we recruit from a wide range of professional and personal backgrounds – bringing different experiences to our work.

Ofgem is proud to be an equal opportunity employer. We embrace diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of open and fair competition, merit and business need.

The Data Insights Analyst role is in the Analytics team within Data & Digital function and plays a key role accelerating data driven decision making, digital transformation and enable self-service analytics across Ofgem. They will design and develop 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, Python and Qlik Sense.

This role will also include contribution to Data Insights best practice and training to be shared and used by all Ofgem employees. They will be responsible for promoting data driven decisions across all directorates and training others to make better use of their data.

Key Responsibilities:

•Design, build, test and deploy analytic products e.g. dashboards, reports, alerts or visualisations
•Collaborate in the support, maintenance and fixes on live production analytics products as needed
•Find, access and prepare data for us in analytic products
•Perform analysis to support strategic business decisions e.g. assess data, find trends, drill down, assess relationships or causality, create forecasts
•Design, build, test and deploy data pipelines for use in analytic products
•Contribute to best practice, training and events around Data Insights at Ofgem

• Experience of using data visualisation software such as Power BI to develop reports and dashboard (LEAD)
• An understanding of how an analytical approach to data can drive decision making
• Good communication skills, ability to explain technical concepts to non-technical users
• Experience using SQL or Python to manipulate or transform data

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

• Changing and Improving
• Working Together
• Making Effective Decisions

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

• Please see Candidate Pack attached.
• Please see Candidate Pack attached.

Alongside your salary of £30,950, OFGEM contributes
£8,356 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 is in 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.

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.

Job contact :

• Name : Jen Hughes/Ofgem Resourcing Team
• Email : recruitment@ofgem.gov.uk

Recruitment team

• Email : recruitment@ofgem.gov.uk