Hybrid Data Platform Engineer (Azure Databricks)

City of Lincoln; Brighton (CO); Hybrid; USD 97,000 - 127,900; Full time

Job summary

United Power is seeking a Data Engineer to design, build, and maintain ETL/ELT pipelines, data lake/Delta lake, and data warehouse structures (Bronze/Silver/Gold). You will transform raw data from customer, billing, financial, meter, and electrical sources into trusted data for BI tools and applications at the enterprise level.

This hybrid role supports Azure Databricks, Azure Data Factory, and related tooling; you will implement monitoring, security, and governance, participate in on-call

Qualifications

• Design, build, and maintain ETL/ELT pipelines that automate data movement.
• Develop knowledge of data sources (customer, billing, financial, meter, electrical).
• Build and maintain data lake, delta lake, and data warehouse structures (Medallion).
• Transform data for BI tools and applications across the organization.
• Build monitoring/alerting to detect data quality issues.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines that automate the movement of data between systems, applications, and external organizations.
• Develop deep working knowledge of United Power's data sources, including customer and billing data, financial data, meter data, and electrical system data, and how that data needs to move and transform to serve downstream users and tools.
• Build and maintain data lake, delta lake, and data warehouse structures, including Medallion (Bronze/Silver/Gold) architecture, that store and organize data efficiently for use across the organization.
• Transform and structure data so it is accessible, well-organized, and usable by the business intelligence tools, analysts, and applications that depend on it.
• Build monitoring and alerting into data pipelines to proactively detect data quality issues such as breakages, schema drift, or anomalies, and surface findings to the Data Engineering Manager, Data Enablement program, or relevant business units for resolution.

Skills

Python

SQL

ETL/ELT design

Data modeling

Data pipelines

Tools

Azure Databricks

Azure Data Factory

Lakeflow Spark

Unity Catalog

Declarative Automation Bundles

Terraform

Oracle

SQL Server

Job description

United Power is seeking a Data Engineer to design, build, and maintain ETL/ELT pipelines, data lake/Delta lake, and data warehouse structures (Bronze/Silver/Gold). You will transform raw data from customer, billing, financial, meter, and electrical sources into trusted data for BI tools and applications at the enterprise level.

This hybrid role supports Azure Databricks, Azure Data Factory, and related tooling; you will implement monitoring, security, and governance, participate in on-call