Senior Portfolio Analyst

National Grid plc; Waltham (MA); Hybrid; USD 123,000 - 144,000; Full time

Benefits offered by this job

Annual bonus

Pension plan

Medical insurance

Job summary

National Grid in Waltham, MA seeks a Senior Portfolio Analyst to modernize IT&D capital investment planning through data analysis, financial models, and executive-ready insights.

The role blends hands-on data work with strategic portfolio management, requiring comfort with fragmented data, automation, and analytics across IT&D, finance, and operations.

Qualifications

• 5+ years of experience in data analytics, data engineering, business intelligence, portfolio analytics, technology, or a related field.
• Strong experience working with data across multiple sources and building repeatable, scalable analytical solutions.
• Experience with data modeling, ETL/ELT, databases, APIs, BI platforms, automation, or similar technologies.
• Strong analytical, problem-solving, and communication skills.
• Ability to translate technical concepts and data into clear business insights and decisions.
• Financial literacy and familiarity with budgets, forecasts, capital investment, or financial analysis.

Responsibilities

• Build and improve data solutions that integrate, transform, model, and analyze portfolio information from multiple sources.
• Own recurring portfolio deliverables, including financial models, analysis, forecasts, stakeholder commentary, executive presentations, and reporting.
• Develop dashboards, analytical tools, and data products that turn complex information into clear, actionable insights.
• Bring a continuous-improvement mindset to simplify and standardize processes and identify opportunities to automate or eliminate manual effort.
• Translate ambiguous business problems into practical data, technology, process, and analytical solutions—and own those solutions through implementation.
• Explore and apply AI, machine learning, automation, and emerging technologies to improve productivity and decision-making.
• Partner across IT&D, Finance, project teams, and other functions to understand needs and drive adoption.
• Strengthen portfolio data quality, governance, and repeatable analytical practices.

Skills

Data analytics

Data modeling

ETL/ELT

BI platforms

Communication skills

Financial literacy

AI-enabled tools

Tools

APIs

Databases

Job description

Every day we deliver safe and secure energy to homes, communities, and businesses. We are there when people need us the most. We connect people to the energy they need for the lives they live. The pace of change in society and our industry is accelerating and our expertise and track record puts us in an unparalleled position to shape the sustainable future of our industry.

To be successful we must continue to anticipate the needs of our customers, reducing the cost of energy delivery today and pioneering the flexible energy systems of tomorrow. This requires us to deliver on our promises and always look for new opportunities to grow, both ourselves and our business.

IT and Digital works seamlessly to support and facilitate the National Grid group of diverse energy businesses to deliver technology which revolutionises the way we operate. As we lead the charge towards a carbon-free future, our teams are pioneering disruptive changes to our industry by working with agile methodologies and adopting digital mind-sets to drive efficiency, effectiveness and bring new capabilities for our internal and external customers.

Our work here is critical. National Grid moves energy to millions of homes and businesses in the UK and US and the technology we utilise to complete that task is down to us. This role is at the centre of facilitating the energy revolution and enabling National Grid to continue to be a leading multi-national energy company. It’s imperative that you have a passion for energy and solving the problems of today, tomorrow and beyond to ensure a secure, reliable and accessible energy system for all.

The successful applicant for this position will be an integral contributor towards this goal and we will support your professional development as part of our multi-cultural, customer-centric global team. This role operates under a hybrid working model and is open to candidates based in the Waltham, MA office. Hybrid work expectations are subject to business needs and company policy.

Job Purpose

We’re looking for a Senior Portfolio Analyst to help manage and modernize how we plan, analyze, and make decisions about our IT&D capital investment portfolio.

This is a hands-on role with a strategic lens. You’ll own the work that keeps portfolio management running—from data analysis and financial models to stakeholder commentary, reporting, and executive presentations—while looking for better ways to do that work. We want someone who sees fragmented data, manual processes, and ambiguity as opportunities to build something better.

You’ll work at the intersection of portfolio management, finance, analytics, technology, automation, AI, and continuous improvement. The right candidate will be comfortable moving from recurring portfolio deliverables to solving ambiguous problems and building practical, scalable capabilities.

Key Accountabilities

• Build and improve data solutions that integrate, transform, model, and analyze portfolio information from multiple sources.
• Own recurring portfolio deliverables, including financial models, analysis, forecasts, stakeholder commentary, executive presentations, and reporting.
• Develop dashboards, analytical tools, and data products that turn complex information into clear, actionable insights.
• Bring a continuous-improvement mindset to the work—challenging existing processes, simplifying and standardizing where appropriate, and identifying opportunities to automate or eliminate manual effort.
• Translate ambiguous business problems into practical data, technology, process, and analytical solutions—and own those solutions through implementation.
• Explore and apply AI, machine learning, agentic AI, automation, and emerging technologies to improve productivity, analysis, decision-making, and how work gets done.
• Partner across IT&D, Finance, project teams, and other functions to understand needs, solve problems, influence decisions, and drive adoption.
• Help strengthen portfolio data quality, governance, and repeatable analytical practices.

Qualifications

• 5+ years of experience in data analytics, data engineering, business intelligence, portfolio analytics, technology, or a related field.
• Strong experience working with data across multiple sources and building repeatable, scalable analytical solutions.
• Experience with data modeling, ETL/ELT, databases, APIs, BI platforms, automation, or similar technologies.
• Strong analytical, problem-solving, and communication skills.
• Ability to translate technical concepts and complex data into clear business insights and decisions.
• Financial literacy and familiarity with budgets, forecasts, capital investment, or financial analysis.
• Experience with AI-enabled tools, project management, process improvement, agile ways of working, or enterprise technology environments is a plus.
• Experience in a regulated industry or utility environment is a plus but not required.

$123k - $144k a year

National Grid will not be providing visa sponsorship for this position now or in the future. You must have the ability to work without a need for current or future visa sponsorship.

National Grid utilizes an assessment that evaluates the job qualifications/characteristics using AI or statistically based scoring. For more information, please view NYC Local Law 144.

This position has a career path which provides for advancement opportunities within and across bands as you develop and evolve in the position; gaining experience, expertise and acquiring and applying technical skills. Candidates will be assessed and provided offers against the minimum qualifications of this role and their individual experience.

National Grid is committed to providing equal employment opportunities to all employees and applicants for employment regardless of protected class. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), national origin, age, disability, genetic information, or any other protected status in accordance with applicable federal, state, and local laws. National Grid maintains affirmative action programs for individuals with disabilities and protected veterans.

Our employment practices are designed to ensure that all individuals are treated fairly and with respect throughout the hiring process and during employment. National Grid complies with all applicable federal, state, and local anti-discrimination laws. We are dedicated to fostering a workplace that is free from unlawful discrimination and harassment, and we encourage a culture of respect for all.

National Grid operates in both the UK and US, with a broad portfolio of energy businesses dedicated to providing safe, reliable, and sustainable power.

From electricity and gas transmission to advancing clean energy and modernising grids, our work covers every aspect of the energy system.

Our energy flows through absolutely everything we do

Life here at National Grid is more than just our purpose or our values, it’s everything we put into everything we do. It’s our commitment to diversity and inclusion; how we help our employees learn and grow; and how we partner with and support the communities where we live and work. It’s all this, and so much more.

We leverage our collective strengths to do meaningful BIG work so that we can be at the heart of a fair and affordable energy future.

Your salary is reviewed each year against the market for your role, skills, knowledge and experience.

Incentive

• Annual performance plan or bonus (depending on your role) rewards your contribution to our success each year.

Retirement

• Generous pension plan with company contributions up to 12%.
• Private medical insurance for self and family.