Gas Contract Analytics Analyst (Hybrid, 2–3 days in office)

National Grid; Waltham (MA); Hybrid; USD 82,000 - 96,000; Full time

Job summary

National Grid in Waltham, MA is seeking an Analyst for the Gas Complex Contract Management team. The role focuses on transforming data into actionable insights, monitoring contract performance, and driving cost control across high-value construction projects.

Expect 2–3 days in the office with a strong emphasis on analytics. The ideal candidate will have 1+ years’ experience in Power BI, Excel, and SQL, plus reporting and KPI development for stakeholders, and must hold a bachelor’s in a

Qualifications

• Bachelor's degree in a technical or analytical field or 3+ years of analytical experience.
• 1+ years of experience using Power BI, Excel, and SQL for data analysis, reporting, or dashboard development.
• 1+ years of experience developing reports, dashboards, KPI's, or analytical solutions for business stakeholders and executive-level reporting.
• Experience supporting construction, utility, engineering, contract management, procurement, or capital project organizations is strongly preferred.
• Strong analytical and problem-solving skills with the ability to interpret complex datasets, identify trends, risks, and improvement opportunities through quantitative analysis and communicate findings clearly.
• Exposure to AI and machine learning concepts or tools within a business setting preferred.
• A valid driver's license is required.

Responsibilities

• Develop, maintain, and enhance dashboards, scorecards, data models, and reporting tools that provide visibility into contractor and contract performance to support the MA Gas Business.
• Be a liaison between National Grid business areas and allocated contractors, supporting the contract execution process through analytics.
• Continuously improve existing reports, automations, and tools based on feedback, adoption, and changing business needs
• Assist with the future improvement to the definition and operation of effective financial controls and KPI metrics.
• Partner with stakeholders to gather requirements, clarify needs, and deliver solutions that improve data usability and decision-making
• Assist with the development and implementation of new end-to-end engineering procurement, and construction (EPC) process and enhancements to existing design-build Monthly Performance Review (MPR) process

Skills

Power BI

Excel

SQL

Education

Bachelor's degree in technical/analytical field

3+ years analytical experience in lieu of degree

Job description

National Grid in Waltham, MA is seeking an Analyst for the Gas Complex Contract Management team. The role focuses on transforming data into actionable insights, monitoring contract performance, and driving cost control across high-value construction projects.

Expect 2–3 days in the office with a strong emphasis on analytics. The ideal candidate will have 1+ years’ experience in Power BI, Excel, and SQL, plus reporting and KPI development for stakeholders, and must hold a bachelor’s in a