PMO Analyst – Data, Insights and Assurance
SGN Greater London, England, United Kingdom
Utilities · 1,001-5,000 employees
About the role
The PMO Analyst is responsible for collecting, validating, and analyzing project and portfolio data to provide actionable insights for senior leadership. They will also design interactive dashboards, ensure project compliance, and support governance and reporting activities across the Operations directorate.
What they look for
Requirements
Candidates should have proven experience as a PMO or Data Analyst with advanced proficiency in Power BI and Excel. Strong analytical skills, attention to detail, and the ability to communicate complex data to stakeholders are essential for this role.
Benefits
Full description
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.
REQ5646
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.
We deliver safety, warmth, and comfort to homes and businesses. Every role, whether in the office or on the front line, plays a key part in this mission. Here’s how you will contribute…
· Data Collection & Management
o Collect, validate, and maintain high-quality project and portfolio data across multiple initiatives
o Establish consistent data standards, definitions, and structures across the portfolio
o Work with Project Managers to ensure timely and accurate data submission
· Data Analysis & Insight Generation
o Analyse project performance data (schedule, cost, RAID, milestones, dependencies)
o Identify trends, risks, and emerging issues across the portfolio
o Provide clear, data-driven insights and recommendations to senior stakeholders
o Support proactive decision-making to improve delivery outcomes
· Dashboarding & Visualisation
o Design, build, and maintain interactive dashboards using Power BI
o Develop advanced Excel models for analysis, forecasting, and reporting
o Present complex data in a clear, concise, and visually compelling way
o Continuously improve reporting automation and data visualisation approaches
· Assurance & Compliance
o Use data to assess project compliance with PMO standards and governance requirements
o Identify gaps or inconsistencies in reporting, planning, and controls
o Support assurance reviews and provide evidence-based insights
o Work with delivery teams to improve data quality and compliance
· PMO Support & Continuous Improvement
o Contribute across all PMO service areas as required
o Support onboarding of new projects into the PMO framework
o Identify and implement improvements to PMO processes, tools, and reporting
o Promote consistency and best practice across the portfolio
· PMO Support & Collaboration
o Support broader PMO activities including governance, planning, RAID, and change control
o Collaborate with PMO colleagues to enhance processes, tools, and standards
o Contribute to continuous improvement of PMO data and reporting capabilities
What you will need
We are looking for candidates with the following experience and skills …
· 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
· Strong stakeholder engagement and communication skills
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. >
