National Gas
Investment Portfolio Analyst
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Investment Portfolio Analyst
£41,952 to £49,355
Warwick, Hybrid (3 days office, 2 days remote)
About us
National Gas is securing Britain’s energy. We transport gas throughout Great Britain, repair and maintain gas pipelines, and manage the meters that allow millions of homes and businesses to access the energy they need. We are the national gas network, providing secure energy to power Britain, achieve net zero, and maintain our industrial competitiveness.
About the role
If you’re energised by turning data into decisions and want to work where your analysis genuinely influences how we invest, grow, and deliver for our customers, this is the perfect next step in your career.
As an Investment Portfolio Analyst, you’ll play a key part in helping our Asset & Engineering teams make smarter, evidence-based investment decisions. By collecting, validating, and analysing data, you’ll provide trusted insights that support operational performance, long-term planning, and strategic direction across our portfolio.
What you'll be doing
- Collecting, cleaning, and transforming data from multiple sources to ensure quality and consistency.
- Analysing investment portfolios and performance data to uncover trends and actionable insights.
- Monitoring data quality, identifying anomalies, and advising on improvements.
- Producing clear, engaging reports, dashboards, and visualisations that help colleagues make informed decisions.
- Maintaining documentation for datasets, tools, and processes.
- Supporting senior analysts with deep-dive analysis, variance and trend analysis, and reconciliation work.
- Identifying opportunities to improve tools, processes, and ways of working within a continuous improvement framework.
- Collaborating with internal strategy, planning, cost, and investment teams to keep portfolios aligned with business priorities.
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.
About you
You’re naturally curious, detail-focused, and eager to grow your analytical capability. You enjoy working with data, asking questions, and turning complex information into simple, meaningful insights for others.
Key requirements & experience
Essential:
- Experience of supporting process improvement and continuous improvement (CI) initiatives, helping to identify efficiencies, documenting and improve business processes, and contribute to the delivery of operational improvements.
- Advanced Excel skills (Macros, XLOOKUP, VLOOKUP, validation checks, etc.)
- Hands-on experience working with data and carrying out insightful analysis.
- Logical thinking and problem-solving skills.
- Clear, confident communication skills and the ability to work with colleagues at all levels.
- A strong interest in data and analytics with the ability to interpret information and produce clear insights.
Desirable
- Regulated asset environment experience.
- Experience with analytics tools such as Power BI.
- Knowledge of decision-support tools such as Copperleaf or AIM.
What we offer
- Annual bonus of 6% based on personal and company performance.
- 26 days’ holiday plus statutory holidays - option available to buy extra or sell days.
- Overtime at x1.5 normal and then x2 on Sunday.
- Double-match pension scheme - for every £1 you put in, we'll add £2 (max company contribution 12%).
- Opt-In flexible benefit scheme, including salary sacrifice private healthcare, dental insurance, technology plans, and more.
- Financial protection with 10x salary death in service and financial support if you're unable to work due to long-term illness or injury.
- Excellent family-friendly provisions - maternity/paternity/adoption/surrogacy/shared parental leave.
- Career progression, professional training, and development – including access to LinkedIn Learning.
- Employee assistance programme offering free confidential professional counselling 24/7.
- Financial support to help you cover the cost of professional membership subscriptions.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Inclusive recruitment
At National Gas, we are disability confident and we are signatories of the Armed Forces Covenant, committed to building a workforce that represents the communities we serve. We celebrate the different experiences our colleagues bring to our organisation, and strongly encourage applicants of all backgrounds to apply. Please let us know of any reasonable adjustments you need to perform your best.
#LI-CT1 #LI-Hybrid #Investment #Analysis #Copperleaf #AIM #PowerBI #Excel #BusinessProcess #Utilities #Infrastructure #Gas
“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
Location