Analyst, Capital Project Planning

About the role

The Capital Planning / Resource Management team at National Grid is seeking an Analyst to join their dynamic team in Waltham, MA. This hybrid role involves evaluating and applying AI, Copilot, and Azure-based tools to automate work and reduce manual effort, building and maintaining dashboards, data models, and reporting solutions, designing and implementing automation workflows, apps, and agent-based solutions, partnering with stakeholders to gather requirements, and continuously improving existing reports, automations, and tools based on feedback, adoption, and changing business needs.

Responsibilities

• Evaluate and apply AI, Copilot, and Azure-based tools to identify opportunities to automate work and reduce manual effort
• Build and maintain dashboards, data models, and reporting solutions (primarily in Power BI) to support the MA Gas Business
• Design and implement automation workflows, apps, and agent-based solutions using Power Platform tools (Power Automate, Power Apps, Copilot Studio)
• Partner with stakeholders to gather requirements, clarify needs, and deliver solutions that improve usability and decision-making
• Own end-to-end delivery of solutions, including development, testing, documentation, and ongoing support
• Contribute to project planning and delivery, working within Agile or structured team processes as needed

Requirements

• Bachelor's degree in a technical or analytical field OR 3+ years of analytical experience required
• 1+ years of experience using Power BI, Excel, and SQL for data analysis, reporting, or dashboard development required
• 1+ years of experience developing reports, dashboards, or analytical solutions for business stakeholders required
• Working knowledge of Python or other data analysis tools preferred
• Exposure to AI and machine learning concepts or tools within a business setting preferred
• Experience working with business systems such as SAP or Maximo preferred

Qualifications

• Salary range: $94,000 - $110,000 per year

Skills

• Experience with AI, Copilot, and Azure-based tools
• Proficiency in Power BI, Excel, and SQL
• Experience with Power Platform tools (Power Automate, Power Apps, Copilot Studio)
• Strong analytical and problem-solving skills
• Excellent communication and collaboration skills
• Ability to work independently and as part of a team

Benefits

• Comprehensive benefits package including health insurance, retirement plans, and paid time off

Pay

• $94,000 - $110,000 per year

Schedule

• This is a hybrid role with some remote work options