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

natgridProd • City of Syracuse, NY

2d

About The Position

About usNational 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 PurposeWe’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. 

Requirements

• Minimum 5-7 years experience as a data engineer or data analysis & reporting specialist.
• 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

Nice To Haves

• Experience with data governance, product management, business analysis,and BI reporting design highly desirable.
• PowerAutomate

Responsibilities

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed