Staff Data Engineer
Big Data
Cloud Data Engineering
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Science
Database
Databases
Engineer
ETL
Informatica
Information Technology (IT)
Software Development
SQL
Job Description
Electric Power Engineers (EPE) is seeking a Staff Data Engineer to support applied data science, data engineering, and data architecture consulting for utility and energy-sector clients. This role focuses on building data pipelines, designing integration and architecture solutions, and developing forecasting and analytics models using utility datasets.
Responsibilities
- Explore, evaluate, and understand utility data sets, including advanced metering infrastructure (AMI) interval energy data, SCADA data, GIS data, utility asset data, customer programs data, and billing data.
- Design, develop, test, and maintain repeatable ETL/ELT pipelines to ingest, transform, reconcile, and deliver data from databases, files, APIs, and other approved sources.
- Build reusable Python and SQL components for data cleansing, standardization, aggregation, validation, and feature preparation.
- Profile source data and implement 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, and document corrective actions.
- Translate business, analytical, and operational requirements into documented data architecture and integration designs for defined solutions or components.
- Create conceptual, logical, and physical data models, entity relationship diagrams, schemas, data dictionaries, and source-to-target mappings.
- Design data flows that connect source systems, staging and storage layers, analytical datasets, models, and downstream applications.
- Evaluate and document tradeoffs across relational databases, warehouses or lakehouses, batch versus API integration, performance, scalability, maintainability, and cost.
- Incorporate client requirements for data ownership, access controls, sensitive information, retention, lineage, and auditability into solution designs.
- For typical utility datasets (AMI, SCADA, weather, GIS, asset, and customer programs), develop and validate forecasting models, classification schemas, anomaly-detection analysis, clustering approaches, and prioritization models as applicable.
- 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, coordinating with client deployment teams when appropriate.
- Communicate assumptions, uncertainty, limitations, and the distinction between observed, inferred, and predicted results.
- Participate in requirements workshops, technical interviews, architecture reviews, and client working sessions.
- Prepare technical reports, process maps, design documentation, and analytical presentations.
- Deliver assigned work within agreed scope, schedule, budget, and quality expectations.
- Identify and escalate 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.
Requirements
- 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, including 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.
Technologies
- Python, SQL
- Databricks, Azure, AWS, Google Cloud
- Git
- Spark/PySpark
- XGBoost, LightGBM
- PyMC, PyTorch, TensorFlow
Benefits
- Comprehensive health and wellness benefits including medical, dental, and vision with 100% premium coverage for you.
- 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
Austin, TX (remote)
This position is remote within the U.S.
Travel
Occasional travel may be needed (10% or less).
Third-Party Recruiting Notification
- EPE does not accept unsolicited resumes from third-party recruiters.
- Any unsolicited third-party resumes forwarded to EPE via the career page or to any manager or employee will be treated as public information and may be handled as a direct application from the person identified in the resume.
- EPE will not pay a placement fee to an agency without a previously signed third-party agreement and has not coordinated recruiting activity with the Talent Acquisition team.