Statistical Review Data Lead

Energy Institute; City of Westminster; On-site; GBP 32,000 - 44,000; Full time

Benefits offered by this job

25 days annual leave

Bank holidays

Christmas office closure leave

Ongoing training and professional dev.

Cycle to Work Scheme

Social events

Friendly working environment

Job summary

Energy Institute in London is seeking a Statistical Review Data Lead for a 12-month fixed-term contract. The role involves leading the end-to-end delivery of the Statistical Review of World Energy dataset, coordinating external analysts, and maintaining data quality and publication-ready outputs.

The position requires 2–5 years in data analysis or related roles, strong MS Access/Excel/VBA/SQL skills, and experience with Power BI or R.

Qualifications

• 2–5 years' experience in data analysis or related role.
• Strong skills in Microsoft Access, Excel, VBA and SQL.
• Ability to manage multiple deadlines and stakeholders.
• Understanding of global energy markets and energy accounting principles.
• Experience with Power BI or R is advantageous.
• Strong project management and communication skills.
• Additional language skills (Chinese/Arabic) would be beneficial.
• High accuracy and transparency in published data.

Responsibilities

• Lead end-to-end delivery of the Statistical Review dataset.
• Coordinate data processing and validation with external analysts.
• Maintain the Statistical Review database and run queries.
• Provide data-related explanations and methodologies.
• Support database development and data model validation.
• Conduct data reconciliation and quality reviews.
• Develop quality control processes for publication readiness.
• Create charts and graphics for reports and web content.
• Collaborate with EI colleagues on country and regional insights.
• Coordinate knowledge sharing and stakeholder briefings.

Skills

Data analysis

Project coordination

Stakeholder engagement

Data validation

Communication

Leadership

Attention to detail

Energy market knowledge

Tools

Microsoft Access

Excel

VBA

SQL

Power Query

Power BI

R

Job description

Job Title: Statistical Review Data Lead

Department: Statistical Review

Location: Central London (hybrid)

Duration: 12 Month Fixed Term Contract – ability to start work immediately, potential to extend

Working Hours: Full-time role 35 hours per week

Salary: £38,000 per annum

Who we are

The EI is the chartered professional membership body for people who work across the world of energy. Our purpose is creating a better energy future for our members and society by accelerating a just global energy transition to net zero. We do this by attracting, developing and equipping the diverse future energy workforce; informing energy decision-making through convening expertise and advice; and enabling industry and consumers to make energy lower carbon, safer and more efficient.

At the EI we endeavour to find talent that will live and breathe our values. Our employees, and our extensive network of volunteers, pursue their work in line with a set of values reflecting the culture of the organisation: we are inclusive by treating each other with care and respect; we build trust through open and professional collaboration; and we are passionate about making a difference.

A registered charity, incorporated by Royal Charter in 2003 but with a heritage dating back more than a century, the EI is licensed to offer professional registration as Chartered Energy Engineer, Chartered Environmentalist and, uniquely, Chartered Energy Manager status. It is also home to a range of collaborative initiatives, including the G+ Global Offshore Wind Health and Safety Organisation, SafetyOn and POWERful Women.

What we're looking for

We are looking for a highly analytical and detail-oriented data professional with a passion for energy data and the energy transition. The ideal candidate will combine strong technical and data management skills with excellent project coordination and stakeholder engagement abilities. They will be comfortable working with large, complex datasets, managing multiple deadlines, and communicating technical information clearly to a range of audiences. Most importantly, they will be committed to accuracy, quality, collaboration, and continuous improvement in delivering one of the world's most respected energy datasets.

Key job responsibilities

This is an exciting opportunity to join one of the most globally recognised and high-profile energy statistics projects. You would have hands-on experience in helping to manage some of the key stakeholder relationships as well as improve the methodology, reporting and systems level of the global statistical review. This is a hybrid role and would require you to be in the London office two days a week. Your tasks would include:

• Lead the end-to-end delivery of the Statistical Review of World Energy dataset, covering data processing, database management, validation, quality assurance and final publication of data outputs.
• Oversee and coordinate the data processing and validation work of an external analyst team, including KPMG and Kearney, and academic research partners covering onboarding, progress monitoring and data delivery management to meet tight deadlines.
• Own core data management processes, including maintaining the Statistical Review database, running queries, building validation checks and producing final outputs used for analysis, publishing and digital products.
• Act as a key point of contact for data-related queries, providing clear explanations of methodology, definitions, data limitations and year-on-year changes.
• Provide support for database development, optimisation and transformation initiatives, collaborating closely with internal database engineering to test and validate calculation formulas, conversion factors, and data models across relational SQL environments.
• Conduct thorough data reconciliation and quality reviews across historical time-series and analytical datasets, ensuring calculation formulas, conversion factors, and regional aggregations maintain complete methodology consistency.
• Develop robust quality control processes to identify inconsistencies, reconcile source data, document assumptions and ensure outputs are accurate, transparentand publication ready.
• Provide analytical support for wider Energy Institute content using Statistical Review data, including the Country Transition Tracker, regional insights, stakeholder briefings and presentations, and web-based data products.
• Build practical analytical tools, templates and calculators that help EI colleagues interpret, interrogate and communicate Statistical Review data more effectively.
• Create engaging charts, tables and graphics that translate complex energy data into accessible outputs for reports, presentations, web content and stakeholder communications.
• 2-5 years' experience in a data analysis, research, statistical review or related role.
• Strong technical skills in Microsoft Access, Excel, VBA and SQL, including database management, automation, Power Query, pivot tables and handling large datasets.
• Strong analytical and data validation skills, with the ability to investigate anomalies, reconcile data sources, apply consistent methodologies and produce accurate outputs.
• Good understanding of global energy markets, energy transition trends and energy accounting principles and metrics.
• Experience with Power BI, R or other data visualisation and analytical tools to support reporting, dashboards and repeatable analyses would be advantageous.
• Strong project management and organisational skills, with the ability to coordinate contributors, manage competing priorities and deliver to deadline.
• Excellent communication, stakeholder management and team leadership skills, with the ability to explain complex information to technical and non-technical audiences.
• Collaborative, detail-oriented and committed to maintaining high standards of accuracy, consistency and transparency in published data.
• Additional language skills, particularly Chinese and/or Arabic, would be beneficial.
• 25 days annual leave plus bank holidays
• Additional leave during our Christmas office closure
• Ongoing training and professional development opportunities
• Cycle to Work Scheme
• Regular company and team social events
• A friendly, supportive and collaborative working environment