Data Scientist (Utility Planning/AI)

Overview

Develop AI-driven forecasting, data pipelines, and Power BI dashboards for utility planning.

Key Responsibilities

• data strategy
• etl pipelines
• forecasting models
• power bi
• scenario analysis
• kpi dashboards

Tasks

-Advise utilities on data warehouse/lake/lakehouse strategy, modeling, and governance to maximize ROI. -Build user-facing tools that integrate power systems logic with analytics to help clients evaluate options, trade-offs, and risk. -Optimize peak demand planning and renewable resource integration to support client decarbonization goals. -Design robust pipelines and ELT/ETL patterns that integrate operational (OT) and enterprise (IT) data. -Build and operationalize economic, rate, and load forecasting models using machine learning and deep learning. -Work closely with electrical engineers, planners, finance, and regulatory teams; translate complex insights into clear executive narratives and recommendations. -Run scenario analysis for rate changes, consumer growth, and weather events; quantify financial impacts and risks. -Apply RAG, prompt engineering (e.g., CoT, ToT), and LLM-enabled retrieval to engineering and planning workflows. -Collaborate with our international sister companies within the broader VINCI network of companies -Build performant models (DAX, Power Query/M, star schemas), implement RLS/security, and establish versioning and refresh strategies. -Partner with client leaders to define KPIs and decision flows; ship dashboards that inform senior leadership and board discussions and drive measurable action. -Lead the design, development, and governance of Power BI dashboards and semantic models for executives, operations, planning, and regulatory reporting. -Deliver high-visibility initiatives such as EV adoption forecasting, customer segmentation, targeted marketing campaigns, and causal impact evaluation of energy efficiency/DER programs.

Requirements

• python
• sql
• power bi
• azure
• mlops
• electrical engineering

What You Bring

-Excellent communication skills with the ability to present to senior leadership and non-technical audiences. -Innovate with Generative AI -Exceptional visibility to senior leadership (internal execs, client executives, and sometimes boards/regulators) -Experience with MLOps/CI-CD (e.g., MLflow, model registries); DBT or orchestration (Dagster/Apache Airflow/Azure Data Factory) -Prototype copilots and knowledge systems that accelerate deliverables and drive efficiency for us and our customers -Strong programming: Python and SQL (R a plus). -Background in rate design, DSM/EE/DER programs, or data governance -Power BI expertise: DAX, Power Query/M, dimensional/star schema modeling, dataflows, RLS, performance tuning, and dashboard lifecycle governance. -Business Intelligence & Dashboarding (Power BI) -Experience with Microsoft Fabric (or similar lakehouse) -Familiarity with utility/power systems tools: PSCAD, PSS/E, ETAP, CYME, Milsoft WindMil -Degree in Electrical Engineering, Computer Science, Statistics, Data Science (or equivalent practical experience) -Drive Advanced Analytics -Proven experience building forecasting, simulation, or optimization models. -Cloud & data platforms: Azure/AWS/GCP (experience with Databricks, Snowflake, or similar). -Architect Data Solutions (Data Warehouse/Cloud) -Collaborative Problem-Solving -Databases: PostgreSQL, SQL Server, MySQL (or equivalent).

People Also Searched For

Benefits

-High-impact portfolio in AI-driven sustainability and grid modernization -Comprehensive health, dental, vision, and 401(k) -As one of the founding members of this department, you have an exceptional opportunity to join a new, growing team early on -Competitive salary + performance bonus -Gain executive and board-level exposure by translating data engineering best practices into business outcomes for senior stakeholders. -Flexible work environment

About Booth & Associates

-The firm began as a family-run engineering consultancy serving utility clients. -Over six decades, it evolved into a multi-office, multi-state specialist in energy and infrastructure solutions. -Projects span overhead and underground distribution design, fiber-optic systems, substation and relay facilities. -The firm tackles system planning, transmission line design, and generation projects—from backup power to grid‑scale installs. -Specialised teams also deliver environmental permitting, GIS, structural engineering, and strategic financial planning. -Booth provides expert testimony and forensic engineering to reconstruct failures in legal and safety contexts.

Sector Specialisms

Visa Sponsorship

-sponsorships are not available.