Portfolio Analyst

National Gas Transmission PLC; Livingston; On-site; GBP 45,000 - 60,000; Full time

Benefits offered by this job

Double-match pension

Performance bonus

Car scheme

Life assurance

Flexible benefits

Wellbeing & development

Job summary

National Gas is seeking a Portfolio Analyst to support planning, optimisation and delivery of a regional portfolio of infrastructure projects. You will help ensure investment programmes are coordinated, resources aligned, and outage and recompression plans developed to support safe and efficient delivery.

You will build dashboards and analytical models, collate data, monitor KPIs, and contribute to regulatory submissions while working in a hybrid, regulated environment.

Qualifications

• Proven experience as a data analyst, business intelligence or performance reporting role, ideally within infrastructure, utilities or regulated sectors.
• Sound knowledge and experience with Power BI Data modelling, proficient in complex DAX function, creating measures, data transformation in power query, experience with SQL and implementing row (rls) level security.
• Strong analytical skills with the ability to interpret large and complex data sets to support decision making.

Responsibilities

• Develop, maintain and enhance dashboards, reports and analytical models to support commercial, portfolio, procurement and investment decision making
• Collect, clean and validate data from multiple internal and external sources, including finance systems, procurement platforms and project controls tools
• Provide insight into supplier performance, spend analysis, contract compliance and market trends to support procurement strategy
• Work with QSs and the Investment Accountant to support forecasting, cost tracking and financial performance analysis
• Monitor KPIs and performance metrics related to supply chain efficiency, procurement cycle times and cost benchmarks.
• Contribute to regulatory submissions and reporting e.g. RIIO returns through accurate data collation and formatting
• Identify and resolve data quality issues and implement improvements to data structures and governance
• Support ad hoc analysis requests for commercial projects, supplier negotiations and investment planning

Skills

Power BI

DAX

SQL

Data modelling

Data analysis

Stakeholder engagement

Regulatory environment

Tools

SQL Server

Power BI Desktop

DAX Studio

Job description

Select how often (in days) to receive an alert:

Location requirement: Candidate must be located within reasonable commutable distance to the Livingston or Aberdeen offices.

Working pattern: 5-days, hybrid, with a minimum of 3 days a week on site.

Travel: There will be a requirement to travel to other offices at times.

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 Role

As Portfolio Analyst, you'll play a critical role in supporting the planning, optimisation and delivery of a regional portfolio of infrastructure investment projects. You'll help ensure our investment programmes are effectively coordinated, resources are aligned, and outage and recompression plans are developed and maintained to support safe and efficient delivery.

Why This Role Matters

Effective portfolio planning is fundamental to delivering investment programmes safely, efficiently and in line with regulatory commitments. As Portfolio Analyst, you will provide the insight, governance and coordination needed to ensure projects are prioritised appropriately, constraints are identified early, and delivery remains optimised across the region.

Your work will support critical operational decisions, improve visibility of performance data, and help ensure that investment plans are achievable, aligned and deliver maximum value for the business and its customers.

What You'll Be Doing

• Develop, maintain and enhance dashboards, reports and analytical models to support commercial, portfolio, procurement and investment decision making
• Collect, clean and validate data from multiple internal and external sources, including finance systems, procurement platforms and project controls tools
• Provide insight into supplier performance, spend analysis, contract compliance and market trends to support procurement strategy
• Work with QSs and the Investment Accountant to support forecasting, cost tracking and financial performance analysis
• Monitor KPIs and performance metrics related to supply chain efficiency, procurement cycle times and cost benchmarks.
• Contribute to regulatory submissions and reporting e.g. RIIO returns through accurate data collation and formatting
• Identify and resolve data quality issues and implement improvements to data structures and governance
• Support ad hoc analysis requests for commercial projects, supplier negotiations and investment planning

What You'll Bring

This role would suit someone who enjoys working in a highly regulated operational environment, influencing positive safety behaviours and providing expert guidance to maintain the highest standards of compliance and performance.

• Proven experience as a data analyst, business intelligence or performance reporting role, ideally within infrastructure, utilities or regulated sectors.
• Sound knowledge and experience with Power BI Data modelling, proficient in complex DAX function, creating measures, data transformation in power query, experience with SQL and implementing row (rls) level security.
• Strong analytical skills with the ability to interpret large and complex data sets to support decision making.
• Excellent organisational skills and attention to detail, with the ability to manage multiple priorities effectively.
• Proficiency and good understanding of portfolio planning, project management, asset management or a similar planning-focused environment.
• Strong communication and stakeholder engagement skills, with the confidence to work across multidisciplinary teams.
• Knowledge of planning processes, resource plans, portfolio governance and investment prioritisation principles.
• A proactive, solutions-focused mindset with the ability to identify issues and drive improvements.
• Experience using asset, project or work management systems.
• Knowledge of regulated environments and an understanding of the RIIO framework.

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