Analytics Engineer II

Summit Utilities, Inc. is hiring a hybrid Analytics Engineer II (SGL17) in Denver, CO to build and govern enterprise analytics data products across Microsoft Fabric and Azure SQL.

Responsibilities

• Design, build, and maintain dbt models that transform source data into governed, analytics-ready datasets across one or more subject areas.
• Develop and maintain dbt schema tests including not_null, unique, accepted_values, and relationships, plus source freshness checks to support data quality SLAs.
• Optimize SQL transformations for performance, cost-efficiency (CU usage), and maintainability in Microsoft Fabric and Azure SQL.
• Investigate root causes of data discrepancies across upstream and downstream systems and partner with Data Engineers to remediate pipeline issues.
• Collect and document data requirements from Data Analysts, business partners, and regulatory teams, translating needs into dbt model designs.
• Implement and maintain dbt project structure using refs, sources, YAML configs, and packages including dbt_utils and dbt_expectations, with incremental materializations.
• Produce clear, business-friendly documentation in the dbt documentation site (model purpose, column definitions, and lineage notes).
• Collaborate with Data Engineers on pipeline requirements and shared standards for ingestion, modeling, and monitoring.
• Contribute to source control and CI/CD workflows for dbt projects, including pull request review and deployment automation.
• Support testing and validation for pipeline enhancements, schema changes, and source onboarding.
• Mentor Analytics Engineer I peers through pair-programming, code review, and knowledge sharing.
• Participate in team standups, sprint planning, code reviews, and architecture discussions.
• Build working knowledge of utility data domains including billing, AMI, SCADA, SAP, and GIS, along with the data quality needs of each operational system.

Requirements

• Bachelor’s degree in data Analytics, Information Systems, Computer Science, Mathematics, or a related field preferred; equivalent combination of education and relevant experience will be considered.
• 3–6 years of experience in analytics engineering, data engineering, data analysis, or BI development.
• Hands-on experience building and maintaining dbt models in a production or near-production environment.
• Strong relational database experience including query writing, optimization, and understanding of stored procedures.
• Demonstrated experience with cloud-based data environments including Microsoft Fabric, Azure SQL, AWS, or similar.
• Familiarity with source control practices and CI/CD workflows for analytics or data projects.
• Master’s degree in a quantitative field is preferred.
• Proficient SQL for querying, transformation, and analysis (complex joins, CTEs, window functions, and subqueries).
• Working knowledge of dbt (develop models, write schema tests, use packages, and understand refs and sources).
• Solid understanding of ETL/ELT concepts and the data lifecycle from ingestion through consumption.
• Familiarity with data governance and metadata management practices.
• Ability to gather requirements, document assumptions, and translate analytical needs into dbt model designs.
• Skilled at root cause analysis and triage across upstream and downstream systems.
• Working knowledge of cloud data platforms with hands-on experience in Microsoft Fabric or Azure SQL preferred.
• Familiarity with API integrations and flat file ingestion formats including CSV, JSON, and XML, plus SAP data structures.
• Ability to work independently and own portions of project delivery from requirements through deployment.
• Strong written documentation habits and ability to communicate technical decisions to teammates and stakeholders.
• Proficiency with source control tools including Git, Azure DevOps, and GitHub, and collaborative development practices.
• Working knowledge of natural gas distribution and utility data systems including billing and AMI and SCADA, with understanding of data quality needs across operational systems.
• Friendly, solution-oriented team player aligned with Summit’s PEAKS values.

Technologies

• dbt
• Microsoft Fabric
• Azure SQL
• SQL
• dbt_utils
• dbt_expectations
• Git
• Azure DevOps
• GitHub
• CI/CD
• API integrations
• CSV, JSON, XML
• SAP
• YAML
• CTEs, window functions
• stored procedures

Benefits

• competitive pay
• medical/dental/vision
• other benefits that provide flexibility, choice, and support to employees when they need it most

Role Summary

• Design, develop, test, and maintain enterprise-grade analytics data products for reporting, regulatory submissions, and operational decision-making.
• Own analytics subject areas end-to-end from source profiling through deployment and monitoring to deliver trustworthy, governed datasets.
• Work independently on dbt model development within Microsoft Fabric and Azure SQL, including ownership of specific subject areas such as billing, AMI, and SAP.

Compensation

USD 90,000 - 111,000 per year (salary based on experience).

Location & Work Model

• Denver, CO
• Hybrid