Utility Systems Data Engineer III

Electric Power Engineers

Austin (TX)

Hybrid

USD 90,000 - 130,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health benefits
PTO & holidays
Employee ownership

Job summary

Electric Power Engineers (EPE) is seeking a Utilities Systems Data Engineer III to advance data engineering, analytics, and data architecture for utility and energy‑sector clients. You will translate complex data into reliable pipelines, models, and workflows across discovery, design, and deployment phases.

The role is hands‑on and contributor‑level, with responsibilities ranging from ETL/ELT development to model updates, working with client architects on integration strategies.

Qualifications

  • Bachelor's degree in a quantitative discipline.
  • 4–5 years of relevant experience in data engineering and applied data science, with data architecture or integration design.
  • Experience building and maintaining repeatable data pipelines or integrations beyond one‑time data prep.
  • Experience designing data models, schemas, and source‑to‑target mappings; justify design decisions.
  • Strong Python and SQL proficiency; maintenance, complex queries, and data transformation.
  • Experience with pipeline testing, scheduling/orchestration, logging, data quality validation, and failure investigation.
  • Working with at least one cloud or distributed‑data platform (Databricks/AWS/Azure/Google Cloud).
  • Understanding of probability, statistics, validation, and uncertainty; experience with forecasting or ML models.
  • Experience with Git, code reviews, documentation, and reproducible analyses.
  • Ability to communicate designs and findings to technical and non‑technical audiences.

Responsibilities

  • Participate in requirements workshops, architecture reviews, and client sessions.
  • Prepare technical reports, process maps, and design documentation.
  • Deliver work within scope, schedule, and budget with quality.
  • Identify data‑access constraints and risks; communicate dependencies.
  • Contribute to peer reviews and reusable methods; guide junior staff.
  • Use AI‑assisted development responsibly and safeguard client information.

Skills

Python
SQL
Data pipelines
ETL/ELT
Data modeling
Cloud platforms
Machine learning
Data architecture
Communication

Education

Bachelor's degree in CS or related
Master's degree preferred

Tools

Databricks
Spark/PySpark
AWS
Azure
Google Cloud

Job description

Overview

We are designing the grid of the future!

EPE is seeking a Utilities Systems Data Engineer IIIwith demonstrated experience in the electric utility sector to join our consulting practice to support analytical and applied data science, data engineering and data architecture consulting projects with our utility and energy-sector clients.

In this role, you will help EPE’s utility clients translate their utility data and business requirements into well‑designed data pipelines, reliable models and integrated analytics and data science workflows. Your work will span data discovery, architecture and integration design, hands‑on development, machine learning, and model maintenance.

This is a hands‑on individual contributor role for a professional with 4–5 years of relevant experience, including experience in the utility sector. You will deliver defined technical components and workstreams, collaborating with senior technical staff and client architects on broader architectural decisions. Depending on the engagement, responsibilities may involve direct implementation or design specifications and advisory support for client‑owned implementation.

Responsibilities

Howyou can make an impact:

Data Engineering for Utility Clients

  • Explore, evaluate, and understand utility data sets including advanced metering infrastructure interval (AMI) energy data, SCADA data, GIS data, utility asset data, customer programs data, and billing data.
  • Design, develop, test, and maintain repeatable ETL/ELT pipelines that ingest, transform, reconcile, and deliver data from databases, files, APIs, and other approved sources.
  • Develop reusable Python and SQL components for data cleansing, standardization, aggregation, validation, and feature preparation.
  • Profile source data and establish automated checks for completeness, validity, consistency, uniqueness, and freshness.
  • Develop record‑matching and entity‑resolution logic to reconcile customer, asset, device, program, and operational records.
  • Investigate pipeline failures, data discrepancies, and performance issues; document corrective actions.

Data Architecture and Integration Design for Utility Clients

  • Translate business, analytical, and operational requirements into documented data architecture and integration designs for defined solutions or components.
  • Develop conceptual, logical, and physical data models, entity relationship diagrams, schemas, data dictionaries, and source‑to‑target mappings.
  • Design data flows connecting source systems, staging and storage layers, analytical datasets, models, and downstream applications.
  • Evaluate and document design tradeoffs involving relational databases, warehouses or lakehouses, batch or API integration, performance, scalability, maintainability, and cost.
  • Incorporate client requirements for data ownership, access controls, sensitive information, retention, lineage, and auditability into solution designs.

Applied Data Science for Utility Clients

  • In the context of typical utility data sets (AMI, SCADA, weather, GIS, asset, and customer programs data sets), develop and validate forecasting models, classification schemas, anomaly‑detection analysis, clustering approaches, and prioritization models as appropriate to the application.
  • Address overfitting, class imbalance, sampling bias, and time‑dependent validation requirements.
  • Monitor model performance and support documented recalibration, retraining, and model updates.
  • Connect analytical models to reliable data pipelines and reproducible datasets, working with client deployment teams where appropriate.
  • Communicate assumptions, uncertainty, limitations, and the distinction between observed, inferred, and predicted results.

Client and Technical Delivery

  • Participate in requirements workshops, technical interviews, architecture reviews, and client working sessions.
  • Prepare clear technical reports, process maps, design documentation, and analytical presentations.
  • Deliver assigned work within agreed scope, schedule, budget, and quality expectations.
  • Identify and elevate data‑access constraints, technical dependencies, methodological limitations, and delivery risks.
  • Contribute to peer reviews, reusable technical methods, and guidance for less‑experienced colleagues.
  • Use AI‑assisted development responsibly, validating outputs and protecting client information.
Qualifications

Bring your passion, here's what’s needed:

  • Bachelor’s degree in computer science, data science, statistics, mathematics, engineering, or a closely related quantitative discipline.
  • 4–5 years of relevant professional experience, including within the utility sector, with hands‑on work in data engineering and applied data science, with demonstrated contributions to data architecture or integration design.
  • Experience building and maintaining repeatable data pipelines or integrations beyond one‑time data preparation and exploratory notebooks.
  • Experience designing data models, schemas, relationships, and source‑to‑target mappings, and explaining the rationale behind design decisions.
  • Strong Python and SQL proficiency, including maintainable programming, complex queries, data transformation, and troubleshooting.
  • Experience with pipeline testing, scheduling or orchestration, logging, data‑quality validation, and failure investigation.
  • Working experience with at least one cloud or distributed‑data platform, such as Databricks, Azure, AWS, Google Cloud, or an equivalent environment.
  • Strong understanding of probability, sampling, statistical inference, regression, confidence and prediction intervals, and uncertainty.
  • Practical experience developing and evaluating statistical or machine learning models, including appropriate validation and interpretation of results.
  • Experience with Git, code review, testing, technical documentation, and reproducible analyses.
  • Ability to communicate technical designs, analytical findings, assumptions, and limitations to technical and nontechnical audiences.

Preferred Qualifications

  • Experience with Databricks, Spark/PySpark, or comparable distributed‑data technologies.
  • Experience with dimensional modeling, warehouse/lakehouse design, metadata management, or data catalogs.
  • Experience with workflow orchestration, CI/CD, model versioning, experiment tracking, or model monitoring.
  • Experience with time‑series or probabilistic forecasting, Bayesian methods, simulation, or optimization.
  • Familiarity with XGBoost, LightGBM, PyMC, PyTorch, or TensorFlow, without an expectation of expertise in every framework.
  • Experience with utility datasets, DER registries, load forecasting, sensor analytics, or engineering automation.
  • Master’s degree in a relevant quantitative or technical discipline.

Be a part of an innovative team shaping the grid of the future through advanced energy intelligence. For more than half a century, Electric Power Engineers (EPE) has partnered with power and energy clients across the globe, providing consulting expertise and energy intelligence software solutions for complex engineering and grid modeling challenges. As leaders in the renewables space, we are focused on building a modern, secure, and resilient grid. Join us in making an impact on the communities we serve and the environment in which we live. Together we can transform the future of energy.

How we support you:

  • Comprehensive health and wellness benefits including medical, dental, and vision with 100% premium coverage foryou
  • Generous PTO and paid holidays
  • MyShare Employee Ownership Program
  • Work with industry leaders
  • 401K, up to a 4% match (100% vested from day 1)

Location: This position remote within the U.S.

Travel: Occasional travel may be needed (10% or less)

EPE is an equal opportunity/AA/Disability/Veteran employer. The EEO is the Law poster, and its supplement are available using the following links:EEOC is the Law Poster

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Staff Data Engineer, Applied Data Science III
Staff Data Engineer, Applied Data Science III

Electric Power Engineers • Austin (TX)

Remote
USD 110,000 - 165,000
Health & dental & vision benefits
PTO and holidays
MyShare Employee Ownership Program
+2
Utility Systems Data Engineer III
Utility Systems Data Engineer III

Electric Power Engineers • United States

Remote
USD 110,000 - 150,000
Health benefits
PTO and holidays
Employee ownership program
+2
Staff Data Engineer, Applied Data Science III
Staff Data Engineer, Applied Data Science III

Electric Power Engineers, LLC • Austin (TX)

Remote
USD 130,000 - 190,000
Health, dental, and vision coverage
Generous PTO and paid holidays
MyShare Employee Ownership Program
+2
Technical Business Development Strategist – Distribution
Technical Business Development Strategist – Distribution

Electric Power Engineers, LLC • Austin (TX)

Remote
USD 130,000 - 180,000
Health, dental, vision benefits
Generous PTO and paid holidays
Employee ownership (MyShare)
+1
Software Power Systems Engineer
Software Power Systems Engineer

Electric Power Engineers, LLC • Austin (TX)

Remote
USD 120,000 - 190,000
Health insurance
401K with company match
MyShare Employee Ownership Program
+1
Power Systems Engineer III
Power Systems Engineer III

Electric Power Engineers, LLC • United States

Remote
USD 85,000 - 120,000
Health insurance
Paid time off
401K match
+1
Technical Director – Multidisciplinary Power Engineering
Technical Director – Multidisciplinary Power Engineering

Electric Power Engineers • Austin (TX)

Remote
USD 180,000 - 240,000
Health and wellness benefits
PTO and holidays
Employee ownership program
+1
Technical Director – Multidisciplinary Power Engineering
Technical Director – Multidisciplinary Power Engineering

Electric Power Engineers, LLC • Austin (TX)

Remote
USD 180,000 - 280,000
Health benefits
Paid time off
Employee ownership
+2
Power Systems Engineer II
Power Systems Engineer II

Electric Power Engineers • Austin (TX)

Remote
USD 90,000 - 140,000
Health insurance
Dental & Vision
401K match
+2
Principal – Energy Market Analysis
Principal – Energy Market Analysis

Electric Power Engineers, LLC • Austin (TX)

Remote
USD 180,000 - 280,000
Health benefits
PTO and holidays
Employee ownership program
+3