Senior Data Scientist, Data Science

natgridProd • City of Syracuse, NY

1d • $119,000 - $167,000 • Hybrid

About The Position

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

Requirements

• Master’s degree in quantitative field + 2 years of relevant experience, OR 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

Nice To Haves

• Relevant energy industry experience or experience in a regulated setting preferred

Responsibilities

• 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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior