Analytics Engineer II

Design, build, test, and maintain dbt models and analytics-ready datasets in Microsoft Fabric and Azure SQL. Implement schema tests and CI/CD, optimize SQL for performance and cost, investigate data discrepancies, document models, collaborate with Data Engineers, and mentor junior engineers while supporting reporting, regulatory, and operational analytics., * Design, build, and maintain dbt models that transform source data into governed, analytics-ready datasets across one or more subject areas.

• Write and maintain dbt schema tests (not_null, unique, accepted_values, relationships) and source freshness checks to enforce data quality SLAs.
• Optimize SQL transformations for performance, cost-efficiency (CU usage), and maintainability within Microsoft Fabric and Azure SQL environments.
• Investigate root causes of data discrepancies across upstream and downstream systems, partnering with Data Engineers to remediate pipeline issues.
• Gather and document data requirements from Data Analysts, business partners, and regulatory teams, translating them into dbt model designs.
• Implement and maintain dbt project structure including refs, sources, YAML configs, packages (dbt_utils, dbt_expectations), and incremental materializations.
• Author clear, business-friendly documentation in dbt's documentation site, including model purpose, column definitions, and lineage notes.
• Partner with Data Engineers on pipeline requirements and collaborate on 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 (billing, AMI, SCADA, SAP, GIS) and the data quality needs of each operational system., Build and maintain cloud cost monitoring, alerting, and optimization tooling. Develop automation, cost allocation/tagging, data pipelines, dashboards, and integrations with billing APIs. Support FinOps processes, implement cost guardrails, troubleshoot cost systems, participate in on-call rotation, and collaborate with senior engineers and product teams to drive cost-efficient infrastructure and reporting., Lead enterprise data modeling and architecture for the firm's lakehouse and Fabric platform. Define canonical data models, produce ERDs and dimensional schemas, govern Silver/Gold layers, run design reviews, document ADRs, and align data governance, lineage, security, and data contracts to ensure trusted analytics and self-service consumption. Top Skills: APIsAzureDatabricksDatabricks LakehouseDataverseDynamics 365Kimball Dimensional ModelingMedallion ArchitectureMicrosoft FabricPower BISemantic LayerWorkday, Wipfli

Summit Utilities is seeking an Analytics Engineer II to design, develop, test, and maintain enterprise-grade analytics data products that power reporting, regulatory submissions, and operational decision-making across the company. Engineers at this level are expected to work independently on dbt model development within Microsoft Fabric and Azure SQL environments, owning specific subject areas (e.g., billing, AMI, SAP, customer) end-to-end - from source profiling through deployment and monitoring. This role is essential to delivering trustworthy, well-modeled, and well-tested datasets that bridge raw source data and business analytics. Ideal candidates bring 3-6 years of experience, proficiency in SQL and dbt, an understanding of data governance and metadata management, and the ability to translate analytical requirements into durable, well-documented data products., * 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 experience working with relational databases, including query writing, optimization, and stored procedure understanding.
• Demonstrated experience working within cloud-based data environments (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 - comfortable with complex joins, CTEs, window functions, and subqueries
• Working knowledge of dbt: ability to 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, flat file ingestion (CSV, JSON, XML), and 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 (Git, Azure DevOps, GitHub) and collaborative development practices
• Working knowledge of natural gas distribution and utility data systems (billing, AMI, SCADA), and an understanding of data quality needs across operational systems
• Friendly, solution-oriented team player aligned with Summit's PEAKS values.

Salary based on experience $90K to $111K USD Annually

The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and/or skills required of all personnel so classified.

Summit offers competitive pay and medical/dental/vision and other benefits that provide flexibility, choice, and support to our employees when they need it most. We understand that home and family are essential pieces of your life, and our benefits are designed to support you both at work and at home., Remote or Hybrid United States 73K-98K Annually Senior level 73K-98K Annually Senior level Cloud * Fintech * Software * Business Intelligence * Consulting * Financial Services Manage day-to-day financial reporting, general ledger accuracy, month-end close, and client reporting for nonprofit clients. Coordinate project tasks, review balance sheets and account classifications, prepare reporting packages and work papers, and assist in managing accountants and developing best practices. Top Skills: Accounting SoftwareMicrosoft Office Suite

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

• Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
• Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
• Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
• Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
• Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
• Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Join our Growing Team and see why Summit Utilities, Inc was named as one of the Fastest Growing Denver Area Private Companies 2019 and 2020; Best Places to Work in Maine 2019, 2020, 2021, 2022 and 2023; and Best Places to Work in Arkansas 2020 and 2023, Oklahoma 2022 and 2023 and Missouri 2023. Summit was also recently named one of Forbes 2023 America's Best Small Employers. Summit is a growing natural gas utility providing safe, reliable, and clean burning natural gas service to homes and businesses in Arkansas, Colorado, Maine, Missouri, Oklahoma, and Texas. Being part of the Summit team means embracing excellence and innovation, committing to safety each and every day, and doing all that we can to serve each other, our customers, and the communities where we live. We aim to bring warmth and energy to everything we do.