Data Engineer

AWS Data Engineer – Utility Data (AMI, Grid, Outage) Role Details • Location: Seattle, WA (Local only) • Work Model: Onsite/Hybrid (as required quarterly) • Duration: 9 +months (extension) • Interview: 2 video rounds • Client Domain: Public sector utility (power/energy) If you’ve worked with utility data (AMI, outage, grid, CIS) and built pipelines on AWS + Databricks, this is your lane. This is not a generic data role — it sits inside a power utility environment dealing with real operational data at scale. Who this role is for • Engineers who’ve handled smart meter / AMI data, outage systems, or grid/asset data • People who’ve built Databricks pipelines on AWS for high-volume, time-series datasets • Candidates comfortable working in utility or energy environments (regulated, ops-heavy) Role Snapshot You’ll be building and optimizing data pipelines for utility operations — meter data, outage events, asset data, and customer systems — inside a cloud-native AWS environment using Databricks. Environment • Public sector utility (power/energy) • High-volume, time-series operational data • Mix of IoT (meters), grid systems, and enterprise platforms • Regulated, reliability-focused environment What this role actually owns day-to-day • Building Databricks pipelines ingesting AMI, outage, and asset data • Working with streaming + batch data for near real-time analytics • Structuring data for grid operations, reporting, and downstream analytics • Optimizing pipelines that process large-scale energy datasets Key Responsibilities • Build and maintain ETL/ELT pipelines in Databricks for utility datasets (meter reads, outage events, asset telemetry) • Ingest data from IoT devices, utility systems, APIs, and enterprise platforms • Implement data cleansing, normalization, and enrichment for operational datasets • Develop streaming and batch pipelines supporting real-time and historical analysis • Optimize Spark jobs, SQL queries, and data models for performance at scale • Design data structures across data lake / lakehouse / warehouse layers • Work with analysts and data scientists to deliver usable, analytics-ready datasets • Document pipelines and support handoff to internal utility teams Must-Have Requirements (Non-Negotiable) • Hands-on experience with utility domain data: AMI / smart meter, outage, grid/asset, or CIS • Strong experience with Databricks on AWS • Solid coding in SQL + Python or Scala • Experience building both batch and streaming pipelines • Understanding of data lake / lakehouse architectures • Familiarity with IEC CIM or utility data models