About us

National Grid is hiring a Senior Data Scientist, Data Management & Analytics - Load Forecasting.This position can be based out of Waltham, MA; Hicksville, NY; Brooklyn, NY; or 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

The Load Forecasting & Analytics (LFA) team produces electric and gas forecasts for National Grid. As a Senior Data Analyst in the Data Management & Analytics team within LFA, you will support the development, presentation, and defense of the load forecasts by defining, managing, and executing all data-related tasks including, but not limited to: data acquisition, transformation, and storage; software/script development; technology platform management and maintenance; requirements collection and stakeholder communications. Additionally, your role will support regulatory work, for example: Electric Grid Modernization Plan, rate cases, etc., for items related to data and technology.

Key Accountabilities

Assemble small and large individual data sets that meet internal business requirements and are within the overall LFA technology platform
Design and implement ETL processes to collect, transform, and store data from various data sources (databases, APIs, FTPs, SharePoint) using a range of technologies depending upon the use case (Azure, SQL, Python)
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 end users and forecasters
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 stakeholders and forecasters to assist with data-related technical issues and to support their ongoing data and technology needs

Qualifications

Bachelor's degree in computer science, data science, statistics, informatics, information systems, or another quantitative field. Master's degree is strongly preferred, with a background in computer science / data science and/or database architecture.
3+ years of experience in a data-heavy role
In-depth experience working with databases (Snowflake, Oracle, SQL Server, PostgreSQL)
Ability to write code in one or more scripting languages: R, Python
Cloud computing experience in a Dev Ops environment
Knowledge of cross-landscape networking (i.e. connectivity between cloud assets and on-prem sources)
Successful history of manipulating, processing, and extracting value from disconnected datasets
Excellent communication skills
GIS programming knowledge or experience strongly preferred
Fully versed in various OS environments: Windows Server, Linux, Unix/AIX, system task scheduling, Bash programming
Ability to design and develop solutions that can be leveraged across multiple projects and have scale for the future
Relevant energy industry experience or experience in a regulated setting preferred
Highly motivated with the ability to work effectively both independently and as part of a team

More Information

Salary

Syracuse $116,000 - 136,000, Waltham $130,000 - $153,000, or Hicksville $139,000 - $164,000 a year.

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.