Data Engineer I-II

• Location 500 Cooperative Way,Brighton, CO, 80603,United States
• Base Pay $97,700.00 - $ / Year
• Employee Type Exempt

Description

Position Purpose and Objectives:

This position acts as the builder and engineer behind United Power's data platform, transforming raw data into structured, reliable, and accessible information for use across the organization. Azure Databricks sits at the center of this work, serving as the primary platform for storing, transforming, and delivering data across the organization.

Reporting to the Data Engineering Manager, this position is part of a small, close-knit team with an outsized impact on how United Power uses its data.

This is a hybrid position, eligible to work primarily remote, subject to the United Power hybrid work agreement. On-site work may require the incumbent to report to any United Power location with little notice, depending on business needs and projects.

Essential Functions and 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.
• Acquire data from primary and secondary sources in the most efficient and reliable manner available.

Platform Administration

• Support the administration of United Power's Azure Databricks environment, including workspace configuration, cluster management, and Unity Catalog governance, commensurate with level.
• Support the administration and maintenance of Azure Data Factory pipelines and orchestration for enterprise data integration needs.
• Build and maintain Lakeflow Spark Declarative Pipelines and Declarative Automation Bundles to support reliable, repeatable deployment and orchestration of data workflows.
• Support the administration of Azure storage accounts (data lakes), including data lifecycle management policies for data retention, tiering, and cost optimization.
• Maintain working knowledge of Databricks' AI/ML tooling and broader industry trends, applying that knowledge to data architecture and pipeline design decisions.
• Assist in evaluating new tools, technologies, and platform features that could enhance the team's data engineering capabilities.
• Partner with the Cybersecurity and Infrastructure teams to implement appropriate access controls, security configurations, and data protection standards within the platform.
• Build strong working relationships with stakeholders across the business to understand their data needs and how business processes are reflected in the data.
• Collaborate effectively with IT Infrastructure Engineers on the implementation and maintenance of infrastructure supporting data solutions.
• Actively support ITIL-based change, problem resolution, and incident management practices.
• Accept accountability for all areas of responsibility and hold peers accountable.
• Participate in an on-call rotation as needed to support critical data platform issues.

Secondary Functions and Responsibilities:

• Creates, expands, and maintains professional and productive working relationships with peers and stakeholders. Works collaboratively with colleagues and fosters a spirit of cooperation and inclusion in the workplace.
• Performs other such duties as may be requested or assigned to fulfill the needs of United Power in the interest of good management practice.

Progression and Proficiency:

The Data…