SGN
PMO Analyst – Data, Insights and Assurance
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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 Operating 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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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
- 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
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills