Successful candidates may be based in any of our office locations – Cardiff, Glasgow or London. We especially welcome applicants from Cardiff and Glasgow.
We welcome applications from candidates seeking part-time working arrangements, with flexibility to consider requests up to 0.8 FTE.
Job Summary
Ofgem is working at the forefront of the fight to protect consumers and combat unfair practices in Britain’s energy markets, using data, technology and intelligence to strengthen oversight of a rapidly evolving sector. We’re looking for a Senior Market Intelligence Analytics Engineer to join us and help deliver the technical foundations that support smarter decision-making, stronger market insight and a fairer energy system.
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.
We’re offering a permanent opportunity with the chance to work on high-profile and business-critical data initiatives that directly support our consumer protection, Net Zero and economic growth objectives. This is an exciting role for someone who enjoys solving complex data challenges and transforming large volumes of information into valuable intelligence that informs regulatory decisions.
Working within a specialist area of Ofgem, you’ll contribute to the development of reliable, high-quality data products, analytical tools and technical capabilities that support market monitoring and surveillance activities. The role offers significant scope to influence how data is managed, transformed and used, while helping drive improvements in efficiency, consistency and insight across a wide range of analytical outputs.
We’re looking for someone with strong technical expertise in data engineering and analytics, with experience developing reliable, scalable data solutions and transforming complex data into meaningful insights. You’ll be confident translating business needs into practical technical outcomes, working with large and varied datasets, and improving tools, processes and reporting capabilities to support informed decision-making.
Alongside meaningful and impactful work, you’ll benefit from flexible working arrangements, including full-time, part-time and flexible working options. You’ll join a collaborative environment where knowledge sharing, innovation and continuous improvement are valued, giving you the opportunity to shape technical approaches, influence best practice and contribute to the development of wider team capability.
We have a critical purpose to strengthen market intelligence and data-driven oversight of wholesale energy markets. Join us in helping combat market risks, improve transparency and ensure the energy market functions fairly for consumers as Great Britain progresses towards a cleaner, more secure energy future.
Key Responsibilities
- Develop, test and maintain Python and SQL data products, data-quality processes and market monitoring tools.
- Proactively gather and fulfil requirements for improved data products and tools
- Oversee the preparation of data for dashboards and build Power BI outputs to support monitoring and analysis.
- Improve data pipelines, data tools, frameworks and processes to increase reliability, performance, features and capabilities.
- Drive good testing, validation and documentation practices.
- Share knowledge with colleagues, provide informal mentoring and contribute to team capability building.
- Proactively drive the adoption of Databricks for our data needs.
Key Outputs and Deliverables
- High quality SQL and Python code for data pipelines, data analysis and data-quality to support market monitoring and market surveillance.
- Well-defined requirements translated into deliverable technical work with clear assumptions and outputs.
- Dashboards and prepared datasets that support colleagues to interpret and act on data.
- Evidence of capability building through mentoring, knowledge sharing or improved team documentation.
Essential Criteria
- Strong experience implementing performant and maintainable Python and SQL solutions to clean, validate, transform and analyse data held in a range of formats (Lead Criteria).
- Experience translating business requirements into technical solutions and reproducible outputs (Lead Criteria).
- Experience working with large datasets to automate the production of accurate, robust outputs.
- Experience improving technical processes, frameworks or tools, including testing and validation approaches.
- Experience building and maintaining dashboards in Power BI.
- Ability to define and follow requirements and deliver to agreed frameworks, standards and deadlines.
Desirable Criteria
- Knowledge of wholesale energy markets or other regulated markets.
- Strong communication skills with the ability to refine requirements, explain technical issues clearly and work with a range of stakeholders.
