data analyst

data analyst London, England

Ofgem
Full Time London, England 46157 - 30950 GBP ANNUAL Today
Job description

Details

Reference number

294786

Salary

£30,950 - £46,157
London £33,400 - £46,157 National £30,950 - £43,650
A Civil Service Pension with an average employer contribution of 27%

Job grade

Higher Executive Officer
Level 2

Contract type

Permanent

Business area

OFGEM - Corporate Services

Type of role

Analytical
Architecture and Data
Environment and Sustainability

Working pattern

Flexible working, Full-time

Number of jobs available

2

Contents

    Location

    About the job

    Benefits

    Things you need to know

    Apply and further information

Location

Cardiff, Glasgow, London

About the job

Job summary

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.

Job description

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

Person specification

  • 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

Behaviours

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

  • Changing and Improving
  • Working Together
  • Making Effective Decisions

Technical skills

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

  • Please see Candidate Pack attached.

Benefits

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.

Things you need to know

Selection process details

This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours, Experience and Technical skills.

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 answer application questions evidencing how you meet the essential and desirable skills and capabilities listed in the role profile. Please ensure you demonstrate clearly, within these answers how you meet each of the essential and desirable skills and capabilities.


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 Commonwealth countries who have the right to work in the UK
  • nationals of the Republic of Ireland
  • nationals from the EU, EEA or Switzerland with settled or pre-settled status or who apply for either status by the deadline of the European Union Settlement Scheme (EUSS) (opens in a new window)
  • relevant EU, EEA, Swiss or Turkish nationals working in the Civil Service
  • relevant EU, EEA, Swiss or Turkish nationals who have built up the right to work in the Civil Service
  • certain family members of the relevant EU, EEA, Swiss or Turkish nationals
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.

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 :

Recruitment team

About Ofgem

CEO: Jonathan Brearley
Revenue: Unknown / Non-Applicable
Size: 501 to 1000 Employees
Type: Government
Website: www.ofgem.gov.uk

data analyst
Ofgem

www.ofgem.gov.uk
London, United Kingdom
Jonathan Brearley
Unknown / Non-Applicable
501 to 1000 Employees
Government
Energy & Utilities
Related Jobs

All Related Listed jobs

applications administrator
Evolution Funding Chesterfield, England 22672 - GBP ANNUAL Today

Are you looking to join a fast paced growing company that can give you amazing career opportunities and help you reach your full...

Kitchen Assistant Mon - Fri for Quiet Coffee
Quiet Coffee London, England 11 - 13.5 GBP HOURLY Today

Excellent levels of presentation and cleanliness. Assembly of food items to specified standards. Maintaing cleanliness at all times in BOH areas.

QHSE Supervisor
Recruit Recruit Halesowen, England 32000 - 40000 GBP ANNUAL Today

The successful candidate will have a strong quality focus, as well as being IOSH or NEBOSH qualified, and have experience in implementing and maintaining ISO

Temporary Sales Assistant - Sports Direct
Sports Direct Canterbury, England Today

To recommend, select and locate the correct merchandise for the customers needs. Ask open questions to find out customers needs.

Finance Assistant
De Vere Beaumont Estate Old Windsor, England 25000 GBP ANNUAL Today

Effectively handling all aspects of the accounts procedures, as our Finance Assistant youll ensure the accurate processing of purchase ledger and sales ledger