PMO Analyst – Data, Insights and Assurance

SGN; Farringdon; Hybrid; GBP 42,000 - 62,000; Full time

Benefits offered by this job

Pension scheme

Enhanced maternity leave

Life assurance

Holiday Plus

Virtual GP

Employee discounts

Job summary

SGN is seeking a Data & Insights PMO Analyst to support a large, multi-year transformation within the Operations directorate. The role focuses on collecting, analyzing, and presenting project data, using Power BI and Excel to deliver insights for senior leadership.

You will help assure project compliance, support governance, and contribute to continuous improvement across PMO processes and reporting. Hybrid working with 2-3 days in the office and occasional UK travel will apply.

Qualifications

• Proven experience as a PMO Analyst or similar role.
• Advanced Power BI skills (dashboard development, data modelling).
• Advanced Excel skills (pivot tables, Power Query, complex formulas).
• Strong data analysis and interpretation capability.
• Experience producing senior-level reports and dashboards.

Responsibilities

• Collect, validate, and maintain high-quality project and portfolio data across multiple initiatives.
• Analyse project performance data (schedule, cost, RAID, milestones, dependencies).
• Design, build, and maintain interactive dashboards using Power BI.
• Develop advanced Excel models for analysis, forecasting, and reporting.
• Provide data-driven insights and recommendations to senior stakeholders.
• Support governance, planning, and reporting activities within the PMO.

Skills

Power BI

Advanced Excel

Data analysis

Reporting

Tools

MS Project

Jira

Confluence

Job description

Data & Insights PMO Analyst

Hybrid/Office based 2-3 days per week with occasional UK travel
Joint-contribution pension from 6% (12% total) – Enhanced maternity & family leave – Life assurance – Holiday Plus – Virtual GP & Employee Assistance Programme plus retail and leisure discounts & many more.

Data & Insights PMO Analyst

Farringdon | Full time | Hybrid/Office based 2-3 days per week with occasional UK travel
Joint-contribution pension from 6% (12% total) – Enhanced maternity & family leave – Life assurance – Holiday Plus – Virtual GP & Employee Assistance Programme plus retail and leisure discounts & many more.

REQ 5646

The world is changing fast, expectations from customers, communities, regulators and our stakeholders are rising.We are in the midst of a multi-year programme that will help us not only achieve our Target Opering Model but also integrate change with ongoing operational delivery and improvement projects. We’re already making great progress with a new Executive Team, a new COO function, moving from five to nine regions in our Southern network (creating closer communities for our people) plus introducing new processes and organisation structure to optimise efficiency.We are also transforming the ways of working and management tools used by our front line services.

We’re now offering fantastic opportunities for colleagues to help us on this exciting journey!

About The Role

The PMO Analyst – Data & Insights plays a critical role within the Portfolio Management Office supporting a large, multi-year transformation within the Operations directorate .

This role is primarily responsible for the collection, analysis, and presentation of project and portfolio data, transforming it into actionable insights for senior leadership. You will leverage advanced Power BI and Excel capabilities to identify trends, highlight risks, and provide data-driven recommendations to improve delivery performance.

In addition, the role will use data to provide assurance on project compliance and support the wider PMO team across governance, planning, and reporting activities.

Where required, the role will act as a support function to the Portfolio Management Office and may involve administrative services such as meeting arrangements, meeting slide preparation, risk management tracking and update, completion and circulation of meeting minutes.

Here’s how you will contribute

• Data Collection & Management
• Collect, validate, and maintain high-quality project and portfolio data across multiple initiatives
• Establish consistent data standards, definitions, and structures across the portfolio
• Work with Project Managers to ensure timely and accurate data submission
• Data Analysis & Insight Generation
• Analyse project performance data (schedule, cost, RAID, milestones, dependencies)
• Identify trends, risks, and emerging issues across the portfolio
• Provide clear, data-driven insights and recommendations to senior stakeholders
• Support proactive decision-making to improve delivery outcomes
• Dashboarding & Visualisation
• Design, build, and maintain interactive dashboards using Power BI
• Develop advanced Excel models for analysis, forecasting, and reporting
• Present complex data in a clear, concise, and visually compelling way
• Continuously improve reporting automation and data visualisation approaches
• Assurance & Compliance
• Use data to assess project compliance with PMO standards and governance requirements
• Identify gaps or inconsistencies in reporting, planning, and controls
• Support assurance reviews and provide evidence‑based insights
• Work with delivery teams to improve data quality and compliance
• PMO Support & Continuous Improvement
• Contribute across all PMO service areas as required
• Support onboarding of new projects into the PMO framework
• Identify and implement improvements to PMO processes, tools, and reporting
• Promote consistency and best practice across the portfolio
• PMO Support & Collaboration
• Support broader PMO activities including governance, planning, RAID, and change control
• Collaborate with PMO colleagues to enhance processes, tools, and standards
• Contribute to continuous improvement of PMO data and reporting capabilities

What You Will Need

• Proven experience as a PMO Analyst, Data Analyst, or similar role within a portfolio office
• Advanced Power BI skills (dashboard development, data modelling)
• Advanced Excel skills (e.g. pivot tables, Power Query, complex formulas)
• Strong data analysis and interpretation capability
• Experience producing senior‑level reports and dashboards
• Ability to translate data into meaningful insights and recommendations
• High attention to detail and data accuracy

Although not essential, the following would help candidates stand out …

• Experience working with PPM and reporting tools (e.g. MS Project, Jira, Confluence)
• Experience working across both traditional (PRINCE2) and Agile/Lean delivery environments, supporting hybrid delivery models
• Experience working in utilities, infrastructure, engineering, or other regulated environments

Not sure you meet every requirement?

Research shows some people – particularly women and those from underrepresented backgrounds – may hesitate to apply unless they meet every criteria. At SGN, we value diverse backgrounds, experiences and perspectives.

If this role interests you but you’re not sure you tick every box, we’d still love to hear from you. You might be just who we’re looking for – now or in the future.

Why SGN?

SGN leads pioneering research and development for a net‑zero energy system. Our innovative technologies are transforming the gas industry while keeping people safe and warm. We are an award‑winning employer, including CCA Gold Awards for Great Places to Work and Inclusivity and Accessibility, and a proud Gold member of the Armed Forces Covenant.

About us | Benefits | Diversity and inclusion

If you require any accommodations or support during the application process, reach out to us. We're here to help ensure an inclusive and accessible experience for everyone.