Senior Portfolio Analyst: Data-Driven, AI-Enabled

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

Job summary

National Grid seeks a Senior Portfolio Analyst to manage and modernize IT&D capital investment planning and analytics. This hands-on role combines data analysis, financial models, and executive-ready reporting with a strategic lens to improve portfolio decision-making across IT& D functions.

You will build scalable data capabilities, develop dashboards, and partner with Finance and project teams to drive adoption while exploring AI-enabled solutions for productivity and accuracy.

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.

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 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.
• Support portfolio planning, rate case deliverables, investment analysis, prioritization, forecasting, and executive decision-making.
• Help strengthen portfolio data quality, governance, and repeatable analytical practices.

Skills

Data analytics

Portfolio analytics

Data modeling

ETL/ELT

BI platforms

AI tools

Communication

Financial literacy

Tools

APIs

Databases

ETL/ELT

Automation

AI-enabled tools

Job description

National Grid seeks a Senior Portfolio Analyst to manage and modernize IT&D capital investment planning and analytics. This hands-on role combines data analysis, financial models, and executive-ready reporting with a strategic lens to improve portfolio decision-making across IT& D functions.

You will build scalable data capabilities, develop dashboards, and partner with Finance and project teams to drive adoption while exploring AI-enabled solutions for productivity and accuracy.