Data Scientist
The Senior Data Scientist in the Load Forecasting & Analytics team at Confidential Client is responsible for developing and maintaining data pipelines, managing cloud data platforms, and enabling data science automation to support electric and gas load forecasting. This hybrid role involves collaboration with technical and business stakeholders to deliver scalable data solutions that meet regulatory requirements and optimize forecasting processes.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Utilities.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
What You’ll Do
Confidential Client’s Load Forecasting & Analytics (LFA) team produces electric and gas load forecasts that inform operations and regulatory filings. As a Data Scientist on the Data Management & Analytics (DMA) team you will build and maintain data pipelines, cloud data assets, and automated workflows that support long- and short-term forecasting.
- Design and implement ETL/ELT processes to ingest, transform and store data from databases, APIs, and file transfers (Azure, SQL, Python).
- Assemble, clean, and validate small and large datasets for forecasters and analytics consumers.
- Develop, manage, and maintain cloud data platform components (compute, storage, database architecture, orchestration).
- Build automated processes and pipelines that reduce manual effort and improve data delivery reliability for forecast teams.
- Collaborate with forecasters, analysts and stakeholders to define data requirements and resolve data/technical issues.
- Assist with research, implementation, and delivery of data products that support regulatory requirements and reports.
Who You Are / Qualifications
- Degree in a quantitative field (data science, computer science, statistics, mathematics, engineering, information systems) OR equivalent experience:
- Master's in a quantitative field + 2 years relevant experience, OR
- Bachelor's in a quantitative field + 3 years relevant experience, OR
- Bachelor's in a non-quantitative field + 5 years relevant experience.
- Strong proficiency in SQL and Python for data transformations, analytical workflows and automation.
- Experience working with relational databases and cloud data warehouses; Snowflake experience preferred.
- Experience developing and orchestrating data pipelines (Airflow, dbt preferred).
- Familiarity with modern development practices and tooling: version control (Git), CI/CD, Terraform, GitHub Actions preferred.
- Experience in hybrid-cloud environments and Linux/bash is helpful.
- Ability to design scalable, maintainable data solutions that support multiple stakeholders.
- Strong communication skills; able to explain technical concepts to non-technical audiences.
- Energy industry or regulated-environment experience preferred.
Skills & Tools
- SQL, Python
- Snowflake (preferred), Oracle, PostgreSQL
- Azure cloud services
- Airflow, dbt
- Git, Terraform, GitHub Actions
- Linux / bash
- Data modeling, ETL/ELT design, data quality and orchestration
Work Model, Location & Pay
- Location: City of Syracuse, NY — hybrid role. Employees are expected to work from their assigned office or approved work location at least three days per week; additional in-person attendance may be required based on team needs.
- Upstate NY salary range: $119,000 - $139,000 a year (posted for City of Syracuse).
- Confidential Client will not provide visa sponsorship for this position. You must be authorized to work in the U.S. without current or future sponsorship.
Assessment & Candidate Experience
- Confidential Client uses an assessment that evaluates job-relevant qualifications; the assessment may use AI or statistically based scoring. Final hiring decisions are made by people.
- This role offers a career path with advancement opportunities as you gain experience and skills. Candidates will be evaluated against the minimum qualifications and their individual experience.
Legal & Compliance Notes
- This posting is intended to comply with applicable federal, state, and local employment laws. The salary range shown is provided per applicable pay-transparency requirements for the job location.
- Confidential Client is committed to equal employment opportunity and non-discrimination in hiring. Reasonable accommodations are available for applicants with disabilities; contact the recruiter or Careertakes for assistance.
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range