Booth & Associates is looking to modernize electrical and gas utilities' planning, operations, and customer programs using data, AI, and engineering. The role aims to help shape how data science, AI, and engineering accelerate the transition to a smarter, cleaner grid by solving high-impact challenges for utilities.
Requirements
- Power BI expertise: DAX, Power Query/M, dimensional/star schema modeling, dataflows, RLS, performance tuning, and dashboard lifecycle governance.
- Strong programming: Python and SQL (R a plus).
- Cloud & data platforms: Azure/AWS/GCP (experience with Databricks, Snowflake, or similar).
- Databases: PostgreSQL, SQL Server, MySQL (or equivalent).
- Proven experience building forecasting, simulation, or optimization models.
- Experience with MLOps/CI-CD (e.g., MLflow, model registries); DBT or orchestration (Dagster/Apache Airflow/Azure Data Factory)
- Experience with Microsoft Fabric (or similar lakehouse)
Responsibilities
- Build and operationalize economic, rate, and load forecasting models using machine learning and deep learning.
- Run scenario analysis for rate changes, consumer growth, and weather events; quantify financial impacts and risks.
- Optimize peak demand planning and renewable resource integration to support client decarbonization goals.
- Advise utilities on data warehouse/lake/lakehouse strategy, modeling, and governance to maximize ROI.
- Design robust pipelines and ELT/ETL patterns that integrate operational (OT) and enterprise (IT) data.
- Lead the design, development, and governance of Power BI dashboards and semantic models for executives, operations, planning, and regulatory reporting.
- Apply RAG, prompt engineering (e.g., CoT, ToT), and LLM-enabled retrieval to engineering and planning workflows.
Other
- Exceptional visibility to senior leadership, both within our company and at our clients’ organizations, and a path to leadership
- Advise executives, boards, and cross-functional leaders on high-stakes planning and investment decisions.
- Gain executive and board-level exposure by translating data engineering best practices into business outcomes for senior stakeholders.
- Inform senior leadership and board discussions and drive measurable action.
- Work closely with electrical engineers, planners, finance, and regulatory teams; translate complex insights into clear executive narratives and recommendations.
