Senior Data Scientist, Data Science

National Grid; City of Syracuse (NY); Hybrid; USD 119,000 - 167,000; Full time

Job summary

National Grid in the United States is seeking a Senior Data Scientist for the Load Forecasting & Analytics team. You will design data pipelines, manage cloud data assets, and enable analytics to support electric and gas load forecasts across multiple regions.

Collaborate with forecasters and stakeholders, automate data delivery, ensure compliance with regulatory plans like Massachusetts Electric Sector Modernization and New York Climate Plan, and drive scalable data solutions for diverse

Qualifications

• Master’s degree in quantitative field + 2 years of relevant experience.
• Experience with relational databases and cloud data warehouses (Snowflake preferred).
• Strong SQL and Python for data transformations and workflows.
• Experience with Airflow and dbt preferred.
• Hybrid-Cloud environment exposure; Linux/bash helpful.
• Excellent communication and ability to explain analytics to non-technical stakeholders.

Responsibilities

• Design and implement ETL/ELT processes to collect, transform, and store data from various sources using Azure, SQL, Python.
• Assemble data sets meeting internal requirements within the LFA platform.
• Develop and maintain the LFA technology platform including cloud assets and reporting.
• Automate manual procedures and optimize data delivery for forecasters and end users.
• Support data product research and delivery aligned with regulatory plans.

Skills

SQL

Python

Data pipelines

Cloud platforms

Communication skills

CI/CD

Airflow

dbt

Education

Master's degree in quantitative field

Bachelor's degree in quantitative field

Bachelor's degree in non-quantitative field

Tools

Snowflake

Airflow

dbt

Azure

Terraform

Job description

About Us

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.

About Us

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.

National Grid is hiring a Senior Data Scientist, Data Management & Analytics – Load Forecasting & Analytics. This position can be based out of Waltham, MA; Hicksville, NY; Brooklyn, NY; or Syracuse, NY.

Job Purpose

The Load Forecasting & Analytics (LFA) team produces electric and gas load forecasts for National Grid. As a Senior Data Scientist in the Data Management & Analytics (DMA) team within LFA, you will support the development, presentation, and regulatory defense of the long and short‑term electric and gas load forecasts.

Responsibilities include data pipeline development and maintenance; cloud data platform management; data science enablement and automation; and collaboration with technical and business stakeholders.

Key Accountabilities

• Design and implement ETL/ELT processes to collect, transform, and store data from various data sources (databases, APIs, FTPs) using a range of technologies depending upon the use case (Azure, SQL, Python)
• Assemble small and large individual data sets that meet internal business requirements and are within the overall LFA technology platform
• Develop, manage, and maintain the LFA technology platform, which includes cloud computing assets, database architecture, stored procedures and orchestration jobs, and reporting
• Drive the process to automate manual procedures and optimize data delivery for forecasters and end users
• Assist with research, implementation, and delivery of data products that directly support forecast development which meets regulatory requirements such as the Massachusetts Electric Sector Modernization Plan, the New York Climate Plan, and Distributed System Implementation Plan
• Work with forecasters and stakeholders to assist with data-related technical issues and to support their ongoing data and technology needs

Qualifications

Quantitative fields include computer science, data science, statistics, mathematics, engineering, information systems, or closely related disciplines. Relevant experience includes data science, data engineering, data analytics. Education and professional experience meeting one of the following:

• Master’s degree in quantitative field + 2 years of relevant experience,
• Bachelor’s degree in quantitative field + 3 years of relevant experience,
• or Bachelor’s degree in non-quantitative field + 5 years of relevant experience
• Experience working with relational databases and cloud data warehouses including data modelling and performance optimization. Experience with Snowflake preferred, but relevant experience with other tools helpful (SQL, Oracle, PostgreSQL,etc.)
• Strong proficiency in SQL and Python including developing data transformations, analytical workflows, and automated processes
• Knowledge in developing, maintaining, and orchestrating data pipelines, including data ingestion and transformation. Experience with Airflow and dbt preferred
• Exposure to modern data platforms and development practices including version control, automated deployments, and CI/CD workflows. Git, Azure, Terraform, GitHub Actions experience preferred
• Experience working in a Hybrid-Cloud environment, including deploying, managing, and connecting cloud-based services. Experience in Linux and bash are helpful.
• Proficiency in integrating, cleaning, and transforming data from disparate sources into reliable customer facing datasets
• Excellent communication skills including the ability to explain technical concepts and analytics findings to non-technical stakeholders
• Ability to design and develop scalable, reusable, and maintainable data solutions supporting multiple projects and multiple stakeholders
• Relevant energy industry experience or experience in a regulated setting preferred

More Information

Upstate NY Salary: $119,000 - $139,000 a year

MA Salary: $133,000 - $156,000 a year

Downstate NY Salary: $142,000 - $167,000 a year

National Grid will not be providing visa sponsorship for this position now or in the future. You must have the ability to work without a need for current or future visa sponsorship.

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.