Senior Data Scientist, Data Science

National Grid • Syracuse, NY

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

About The Position

National Grid’s Load Forecasting & Analytics (LFA) team produces electric and gas load forecasts. As a Senior Data Scientist in the Data Management & Analytics team within LFA, you will support the development, presentation, and regulatory defense of long- and short-term electric and gas load forecasts. The role focuses on data pipeline development and maintenance, cloud data platform management, data science enablement and automation, and collaboration with technical and business stakeholders. The position may be based in Waltham, Massachusetts; Hicksville, New York; Brooklyn, New York; or Syracuse, New York.

Requirements

• A master’s degree in a quantitative field and at least 2 years of relevant experience; or a bachelor’s degree in a quantitative field and at least 3 years of relevant experience; or a bachelor’s degree in a non-quantitative field and at least 5 years of relevant experience.
• A degree in a quantitative field such as computer science, data science, statistics, mathematics, engineering, information systems, or a closely related discipline, as applicable to the education and experience pathway.
• Relevant experience in data science, data engineering, or data analytics.
• Experience with relational databases and cloud data warehouses, including data modeling and performance optimization.
• Strong proficiency in SQL and Python, including developing data transformations, analytical workflows, and automated processes.
• Knowledge of developing, maintaining, and orchestrating data pipelines, including data ingestion and transformation.
• Exposure to modern data platforms and development practices, including version control, automated deployments, and CI/CD workflows.
• Experience working in a hybrid-cloud environment, including deploying, managing, and connecting cloud-based services.
• Proficiency integrating, cleaning, and transforming data from disparate sources into reliable customer-facing datasets.
• Strong communication skills, including the ability to explain technical concepts and analytical findings to non-technical stakeholders.
• Ability to design and develop scalable, reusable, and maintainable data solutions supporting multiple projects and stakeholders.
• Ability to work without current or future visa sponsorship.

Nice To Haves

• Experience with Snowflake; relevant experience with other tools such as SQL, Oracle, or PostgreSQL is also helpful.
• Experience with Airflow and dbt.
• Experience with Git, Azure, Terraform, and GitHub Actions.
• Linux and bash experience.
• Relevant energy-industry experience or experience in a regulated setting.

Responsibilities

• Design and implement ETL/ELT processes to collect, transform, and store data from sources such as databases, APIs, and FTPs using technologies including Azure, SQL, and Python.
• Assemble individual datasets of varying sizes to meet internal business requirements and fit within the LFA technology platform.
• Develop, manage, and maintain the LFA technology platform, including cloud computing assets, database architecture, stored procedures, orchestration jobs, and reporting.
• Automate manual procedures and optimize data delivery for forecasters and end users.
• Research, implement, and deliver data products that support forecast development and meet regulatory requirements, including the Massachusetts Electric Sector Modernization Plan, New York Climate Plan, and Distributed System Implementation Plan.
• Work with forecasters and stakeholders to resolve data-related technical issues and support their ongoing data and technology needs.

What This Job Offers

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