Summit Utilities, Inc. is seeking an Analytics Engineer II (SGL17) based in Denver, Colorado, for a hybrid work arrangement. The role designs, develops, tests, and maintains enterprise-grade analytics data products that power reporting, regulatory submissions, and operational decision-making across the company. You will own dbt model development within Microsoft Fabric and Azure SQL environments, focusing on subject areas such as billing, AMI, SAP, and customer data, from source profiling to deployment and monitoring. This role delivers trustworthy, well-modeled data sets and collaborates with Data Engineers to remediate pipeline issues.

Responsibilities include designing, building, and maintaining dbt models that transform source data into governed, analytics-ready datasets across multiple subject areas; writing and maintaining dbt schema tests and source freshness checks; optimizing SQL transformations for performance and cost-efficiency within Microsoft Fabric and Azure SQL environments; investigating data discrepancies with Data Engineers to remediate pipeline issues; gathering and documenting data requirements and translating them into dbt model designs; implementing and maintaining dbt project structure (refs, sources, YAML configs, packages, incremental materializations); authoring clear, business-friendly documentation in dbt's documentation site; collaborating with Data Engineers on ingestion, modeling, and monitoring standards; contributing to source control and CI/CD workflows; supporting testing and validation for pipeline enhancements and schema changes; men

Summit Utilities, Inc. is seeking an Analytics Engineer II (SGL17) based in Denver, Colorado, for a hybrid work arrangement. The role designs, develops, tests, and maintains enterprise-grade analytics data products that power reporting, regulatory submissions, and operational decision-making across the company. You will own dbt model development within Microsoft Fabric and Azure SQL environments, focusing on subject areas such as billing, AMI, SAP, and customer data, from source profiling to deployment and monitoring. This role delivers trustworthy, well-modeled data sets and collaborates with Data Engineers to remediate pipeline issues.

Responsibilities include designing, building, and maintaining dbt models that transform source data into governed, analytics-ready datasets across multiple subject areas; writing and maintaining dbt schema tests and source freshness checks; optimizing SQL transformations for performance and cost-efficiency within Microsoft Fabric and Azure SQL environments; investigating data discrepancies with Data Engineers to remediate pipeline issues; gathering and documenting data requirements and translating them into dbt model designs; implementing and maintaining dbt project structure (refs, sources, YAML configs, packages, incremental materializations); authoring clear, business-friendly documentation in dbt's documentation site; collaborating with Data Engineers on ingestion, modeling, and monitoring standards; contributing to source control and CI/CD workflows; supporting testing and validation for pipeline enhancements and schema changes; men