Data Analyst, Reporting & Analytics

About us

National Grid is hiring a Data Analyst (Management Data Analysis), for our Data Analysis and Reporting department in Upstate, NY / Downstate, NY or Waltham, NE.

Everyday 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

The Reporting Analyst plays a critical role in transforming raw enterprise data into trusted, actionable insights that drive operational, financial, and strategic decision-making. This role is responsible for the full reporting lifecycle - from gathering reporting specifications, validating source-of-record datasets, and assessing data quality, to designing intuitive visualizations and maintaining an accurate reporting catalog.

This role also functions as the Product Owner for the Snowflake curated data layer, owning prioritization, acceptance criteria, and delivery of features that supported reliable, consumable data assets.

You will partner closely with business stakeholders, data engineers, data governance, and product teams to ensure reporting assets are accurate, compliant, scalable, and aligned with enterprise data management principles. This role requires strong analytical rigor, technical fluency, and a commitment to continuous learning in modern reporting and data engineering tools.

Key Accountabilities

Product Owner - Curated Data Layer (Snowflake)

• Act as Product Owner for the Snowflake curated data layer, owning the product vision, roadmap, and backlog to ensure delivery of high-value, consumable data assets.
• Engage business and technical stakeholders to capture needs, translate them into clear user stories and acceptance criteria, and define success metrics and adoption goals.
• Prioritize features and enhancements based on business value, dependencies, and risk; maintain a groomed backlog and release plan.
• Define and document data contracts, acceptance criteria, SLAs and release acceptance requirements in alignment with enterprise standards; ensure items are catalogued for traceability and audit readiness.
• Coordinate work across data engineering, QA, analytics, and data governance to ensure correct implementation, testing, lineage, and production readiness.
• Monitor product performance and stakeholder feedback, iterate on requirements and backlog, and remove blockers or escalate impediments as needed.

Reporting Requirements & Specification Management

• Engage business stakeholders to capture reporting requirements, KPIs, definitions, and intended decision pathways.
• Translate business needs into clear, structured reporting specifications including data sources, logic, filters, metrics, and visualization expectations.
• Document specifications in alignment with enterprise standards and ensure they are cataloged for traceability and audit readiness.
• Partner with data governance to validate metric definitions, business rules, and approved sources of record.
• Optimize report performance, usability, and accessibility for diverse business audiences.
• Develop reusable semantic models, datasets, and dataflows to support scalable self-service analytics.

Data Acquisition, Validation & Quality Assessment

• Collaborate with data engineering teams to identify, validate, and acquire the correct source-of-record datasets from Snowflake, Azure, Databricks, Salesforce, Maximo, and other enterprise platforms.
• Perform data profiling, lineage validation, and quality checks using tools such as Informatica IDQ/EDC, Collibra, Kingsway Soft, SSIS, or Matillion.
• Investigate anomalies, reconcile discrepancies, and escalate data quality issues with clear root-cause analysis.
• Ensure all datasets used for reporting adhere to enterprise data management and governance standards.

Reporting Catalog Stewardship

• Maintain an accurate, up-to-date reporting catalog including report purpose, owners, refresh cadence, data sources, and business definitions.
• Ensure catalog entries are complete, relevant, and written in business-friendly language.
• Partner with data governance to ensure catalog metadata aligns with enterprise standards and lineage requirements.

Qualifications

• Bachelor's degree in Information Systems, Computer Science, Data Analytics, Engineering, Finance, or related field.
• 3-7 years of experience in reporting, analytics, or data management roles.
• Strong proficiency in SQL (Snowflake SQL, T-SQL, or equivalent).
• Experience with Power BI, Tableau, Looker, or similar BI tools.
• Familiarity with Snowflake, Azure Data Services, Databricks, or equivalent cloud data platforms.
• Experience with data quality and metadata tools (Informatica IDQ/EDC, Collibra).
• Ability to interpret business requirements and translate them into technical specifications.
• Strong understanding of data modeling, KPI design, and visualization best practices.
• Ability to investigate data anomalies and perform root-cause analysis.
• Excellent communication skills with both technical and business audiences.
• Experience working in Agile environments (Jira, Confluence).

More Information

Salary

Upstate, NY $75,000 - $88,000

New England $85,000 - $99,000

Downstate, NY $91,000 - 106,000 a year

National Grid utilizes an assessment that evaluates the job qualifications/characteristics using AI or statistically based scoring. For more information, please view NYC Local Law 144.

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

National Grid is committed to providing equal employment opportunities to all employees and applicants for employment regardless of protected class. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), national origin, age, disability, genetic information, or any other protected status in accordance with applicable federal, state, and local laws. National Grid maintains affirmative action programs for individuals with disabilities and protected veterans.

Our employment practices are designed to ensure that all individuals are treated fairly and with respect throughout the hiring process and during employment. National Grid complies with all applicable federal, state, and local anti-discrimination laws. We are dedicated to fostering a workplace that is free from unlawful discrimination and harassment, and we encourage a culture of respect for all.

#LI-MJ1