Senior Data Scientist, Data Science

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

Job summary

National Grid plc is hiring a Senior Data Scientist for the Load Forecasting & Analytics team, with responsibilities spanning data pipelines, cloud platform management, and automation to support electric and gas forecasts. This role collaborates with forecasters and stakeholders on data products and regulatory forecast development.

The position requires strong SQL and Python skills, experience with Airflow/dbt, and a track record of building scalable data solutions in a hybrid-cloud environment.

Qualifications

• Master’s degree in quantitative field with 2 years of relevant experience.
• Bachelor’s degree in quantitative field with 3 years of relevant experience or Bachelor’s in non-quantitative field with 5 years of experience.
• Experience with relational databases and cloud data warehouses including data modelling and performance optimization.
• Strong proficiency in SQL and Python for data transformations and automated processes.
• Knowledge of data pipelines, including Airflow and dbt.
• Experience in Hybrid-Cloud environments; Git/Azure/Terraform and CI/CD desirable.
• Ability to integrate and clean data from disparate sources into reliable datasets.
• Excellent communication to explain analytics to non-technical stakeholders.
• Energy industry or regulated setting experience preferred.

Responsibilities

• Design and implement ETL/ELT processes to collect, transform, and store data from various sources using Azure, SQL, and Python.
• Assemble data sets that meet business 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 users.
• Support data products that meet regulatory plans and forecast development needs.
• Collaborate with forecasters and stakeholders on data-related issues and requirements.

Skills

SQL

Python

Data pipelines

ETL/ELT design

Airflow

dbt

Azure

Git

Communication skills

Hybrid-Cloud

Education

Master's degree in quantitative field

Bachelor's degree in quantitative field

Bachelor's degree in non-quantitative field

Tools

Snowflake

Azure

Terraform

GitHub Actions

PostgreSQL

Job description

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

#LI-Hybrid

#LI-STR1

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.

Safety, Health, Environment and Resilience

National Grid operates in both the UK and US, with a broad portfolio of energy businesses dedicated to providing safe, reliable, and sustainable power.

From electricity and gas transmission to advancing clean energy and modernising grids, our work covers every aspect of the energy system.

Our energy flows through absolutely everything we do

Life here at National Grid is more than just our purpose or our values, it’s everything we put into everything we do. It’s our commitment to diversity and inclusion; how we help our employees learn and grow; and how we partner with and support the communities where we live and work. It’s all this, and so much more.

We leverage our collective strengths to do meaningful BIG work so that we can be at the heart of a fair and affordable energy future.

We offer a competitive base salary, with annual reviews to ensure it reflects the market rate for your role, skills, knowledge, and experience.

Incentive Pay

Depending on your role, you'll be eligible for an annual performance bonus that rewards your contribution to our success. Your bonus is a percentage of eligible earnings and may vary each year.

Recognition

Our global recognition program lets you thank and reward colleagues for their contributions, along with career milestone awards to celebrate key achievements.

Retirement

We offer a generous pension plan with company contributions up to 12%. For every £1 you contribute, we'll add £2. You can also make extra voluntary contributions to boost your retirement savings.