Senior Analyst - Retail Market Data

Job description

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 great for the environment.

Ofgem has a culture of inclusion that encourages, supports, and celebrates the diverse voices and experiences of our colleagues. It fuels our innovation and helps ensure we can best represent the consumers and the communities we serve. Everyone is welcome - as an inclusive workplace, our employees are comfortable bringing their authentic selves to work.

The Market Intelligence team sits within the Financial Resilience & Controls directorate. We monitor developments in the domestic and non-domestic retail energy market, and provide data and analysis used across the organisation to help inform decisions on key policies. The analysis our team undertakes helps to provide insight into the current state of the market, as well as horizon analysis on what the organisation should be considering over the coming years.

Purpose

• Leading a high priority workstream driving the evolution of how Ofgem monitors tariff and proposition data.
• Producing key pieces of analysis and documentation regarding tariffs and propositions in the retail energy market

Key Responsibilities

• Lead on a policy change consultation relevant to the evolving tariff and proposition landscape.
• Drive the improvement of how tariff data is acquired and made available throughout the organisation.
• Collaborate with the data engineering team to ensure appropriate pipelines and datasets are scoped and constructed.
• Develop new ways to improve tariff data accessibility across the organisation.
• Become a go-to resource within the organisation for tariffs and propositions; continually improve breadth of market knowledge.
• Produce key pieces of routine and ad-hoc analysis, especially regarding novel and innovative tariffs and propositions.
• Prepare data and slide deck that concisely summarise key market developments.
• Manage relationships with third-party data providers and other relevant parties.

Person specification

Essential Criteria

• Demonstrable expertise in the retail energy tariff and proposition space. (LEAD)
• Experience leading on and/or writing consultations on policy changes (or similar).
• Evidence of robust analytical skills and decision making.
• Strong working knowledge of cloud data warehousing platforms.
• Robust technical proficiency with modelling tools, particularly Excel (or equivalent).
• Proven excellence in processing, visualising, and communicating complex information.

Desirable Criteria

• Proficiency in SQL, Python, and/or R.
• High-level knowledge of data pipelines.

Behaviours

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

• Seeing the Big Picture
• Making Effective Decisions
• Working Together
• Delivering at Pace

Technical skills

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

• Please refer to the Candidate Pack and Role Profile attached for full details.

Benefits

Alongside your salary of £45,614, OFGEM contributes £12,315 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 provide a 1250 word 'personal statement' evidencing how you meet the essential and desirable skills and capabilities 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 expect all candidates to abide by these principles. Ofgem take 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.

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