Investment Portfolio Reporting Analyst

£48,500 to £57,500 + up to 6% bonus

Location: Warwick

Working pattern: Hybrid, with a minimum of 3 days a week on site

About us

At National Gas, the work we do matters.

As Britain's national gas network, we help keep the lights on, businesses running, and homes warm by maintaining the critical infrastructure that transports gas across Great Britain. While providing the energy security Britain relies on today, we're also helping transform the network for a clean energy future.

Join us and help secure Britain's energy.

About the role

As an Investment Portfolio Reporting Analyst, you'll turn complex investment data into clear insights that help National Gas make informed decisions on operational capex delivery and performance Your analysis will support investment performance improvements, regulatory outcomes, and the delivery of assets that keep energy flowing safely and reliably.

Why this role matters

Our investment programmes play a vital role in maintaining and improving the UK's gas transmission network. To deliver them effectively, we need accurate reporting, meaningful analysis, and clear visibility of performance. This role sits at the heart of that process. You'll help shape how we understand portfolio performance, identify risks and opportunities, and provide the information leaders need to make confident decisions about the future of our network.

What you’ll be doing

• Transform data from multiple sources into clear, accurate reporting for a wide range of stakeholders
• Provide insight into investment performance across cost, schedule, scope, and regulatory measures
• Support decision-making by identifying trends, risks, opportunities, and areas for improvement
• Develop and maintain reporting processes that improve efficiency and consistency
• Create dashboards, reports, and presentations that make complex information easy to understand
• Challenge and influence stakeholders on portfolio performance and delivery outcomes
• Lead key reporting activities, managing timelines, and delivering high-quality outputs
• Support the preparation and assurance of regulatory reporting submissions to Ofgem, ensuring reported information is accurate, auditable, and aligned to regulatory requirements and commitments
• Maintain and govern reporting dashboards and approved data sets
• Identify and investigate performance anomalies, providing root-cause analysis and recommendations for corrective action
• Contributing to continuous improvement of data quality, ensuring a single source of truth across reporting outputs

What you’ll bring

This role would suit someone who enjoys working with data, spotting patterns, and turning information into meaningful business insight.

Essential

• Experience in a data analysis, project controls, finance, or similar analytical role
• Ability to work accurately with large volumes of data, with strong attention to detail and organisational skills
• Experience presenting data and insights in a way that meets the needs of different audiences
• Strong stakeholder management and communication skills
• Experience identifying risks, opportunities, and performance trends
• Good working knowledge of Microsoft Excel, PowerPoint, and other Office tools
• A degree (or equivalent) in a relevant subject, or equivalent practical experience
• Strong stakeholder management and communication skills, with the ability to communicate complex information clearly
• Curious and inquisitive mindset with a desire to understand business performance
• Ability to work to fixed reporting deadlines and manage competing priorities in a cyclical reporting environment

Desirable

• Experience building dashboards and reports using Power BI
• Advanced Excel skills (e.g., Power Query, complex formulas, data modelling)
• Knowledge of capital investment, programme, or portfolio reporting
• Experience working with systems such as SAP, P6, Tableau, or similar reporting tools
• Understanding of regulatory or performance reporting environments
• Experience within the energy or utilities sector
• Understanding of the RIIO price control framework or experience supporting Ofgem regulatory submissions

What we offer

• Market-leading double-match pension (up to 12% company contribution)
• Annual performance bonus up to 6%
• Access to the Tusker salary sacrifice car scheme
• 26 days holiday (plus statutory holidays)
• 10x salary life assurance and income protection
• Flexible benefits including healthcare, dental, and technology options
• Family-friendly policies, wellbeing support, and professional development opportunities

Inclusive recruitment

We're building a workforce that reflects the communities we serve, championing diversity, and creating an inclusive workplace where everyone is valued for their unique contribution. We support reasonable adjustments throughout the recruitment process and beyond.

National Gas is a Disability Confident employer and signatory of the Armed Forces Covenant.

#LI-Hybrid #NowHiring #JoinOurTeam #Careers #DataAnalysis #BusinessPerformance #ReportingAndInsights #StakeholderManagement #ExcelJobs #ProjectControls