Senior Data Scientist, Data Science

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.

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.

• 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

• 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