Senior Data Scientist, Data Science

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., * 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, 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. National Grid is an equal opportunity employer that values a broad diversity of talent, knowledge, experience and expertise. We foster a culture of inclusion that drives employee engagement to deliver superior performance to the communities we serve. National Grid is proud to be an affirmative action employer. We encourage minorities, women, individuals with disabilities and protected veterans to join the National Grid team.

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, 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.

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.