Lead Data Analyst (Management Data Analysis), Data Analysis and Reporting

About us

National Grid is hiring a Lead Data Analyst (Data Analysis and Reporting) for our AMI Process & Performance department in Syracuse, NY.

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 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.

Job Purpose

We're hiring an AMI Data Integration & Analytics Specialist to evolve and support the data backbone that powers National Grid's AMI Operations Center. This role blends deep technical expertise, data governance principles, and problem-solving instincts to transform raw meter and network data into automated, reliable insights that drive decision-making and operational excellence.

Key Accountabilities

• Provide technical expertise in data extraction, transformation, and visualization, enabling business users to make informed decisions.
• Enable business continuity by automating daily report updates and BI workflows.
• Develop, automate, and maintain centralized meter issue queues and reporting dashboards for AMI performance and billing health.
• Integrate data from multiple sources (e.g., Snowflake, network health systems) to enable real-time tracking and categorization of meter issues.
• Collaborate with business stakeholders to translate manual reporting processes into automated workflows, reducing reliance on ad hoc Excel-based methods.
• Support the creation and enhancement of Power BI or similar analytics tools for operational and strategic reporting needs.
• Work closely with DE and other IT teams to align data models, resolve integration challenges, and implement enhancements as requirements evolve.
• Use Copilot and Copilot premium to enhance, streamline and automate operational processes and workflows to monitor and resolve Advanced Metering Infrastructure events and alarms.

Qualifications

• Minimum 5-7 years experience as a data engineer or data analysis & reporting specialist.
• Experience with data governance, product management, business analysis,and BI reporting design highly desirable.
• Technical skills: SQL, Snowflake (preferred), relational databases, Python or other scripting languages, PowerBI, PowerAutomate (nice-to-have), workflow automation leveraging AI tools such as Copilot or ChatGPT

More Information

Salary: $108,00 - $127,000

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. Internal candidates will be assessed and provided offers against the minimum qualifications of this role and their individual experience.

National Grid is an equal opportunity employer that values a broad diversity of talent, knowledge, experience, and expertise. We foster a culture of inclusion that drives employee engagement to deliver superior performance to the communities we serve. National Grid is proud to be an affirmative action employer. We encourage minorities, women, individuals with disabilities, and protected veterans to join the National Grid team.

#LI-AT2