Analytics Engineer

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process. Full-Time DENVER, CO, US 3 days ago Requisition ID: 3201 Join our growing team and discover why Summit Utilities, Inc. continues to earn national and regional recognition as an employer of choice. Our recognitions include Best Places to Work in Maine (2019–2025); Best Places to Work in Arkansas (2020, 2023, 2025); Best Places to Work in Oklahoma (2022–2025); Best Places to Work in Missouri (2023 and 2026); Best Places to Work in Colorado (2025); Forbes America’s Best Small Employers (2023); and, most recently, Proud and Purposeful Employer (2026). 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. We have an exciting hybrid opportunity for a Senior Analytics Engineer based in Denver, CO (SGL19). POSITION SUMMARY Summit Utilities is seeking a Senior Analytics Engineer to lead the design, development, and operational excellence of enterprise-grade data products that power AI and analytics initiatives across the organization. Engineers at this level set the technical direction for dbt model architecture and the organization’s semantic layer on modern cloud data platforms, prepare and productionize the trusted, well-governed datasets that AI and machine learning products depend on, lead complex data investigations, and drive data quality and integrity improvements. The Senior Analytics Engineer is a formal mentor for junior Analytics Engineers, partners with Data Engineers, Data Architects, and AI/ML teams on platform standards, and approves data quality standards for production. Ideal candidates bring expert-level SQL, advanced dbt expertise (macros, Jinja templating, custom generic tests, semantic layer/metrics definitions, CI/CD integration), strong data modeling proficiency, and a track record of building AI-ready data products. Because the role is domain- and project-agnostic, it applies equally to full-time and contract engagements across any project or business area. PRIMARY DUTIES AND RESPONSIBILITIES Lead the design, development, and ongoing maintenance of complex dbt models and transformation pipelines that deliver trusted, AI-ready datasets for analytics and machine learning products. Define dbt testing strategies—including custom generic tests, advanced packages (dbt_utils, dbt_expectations), and source freshness SLAs that ensure the accuracy and reliability AI and analytics use cases require. Lead in-depth data investigations and drive data integrity improvements through lineage analysis, validation processes, and root cause remediation across upstream and downstream systems. Define key metrics, reporting standards, and a governed semantic layer, partnering with data scientists, analysts, and business stakeholders to translate needs into governed, reusable data products that serve both analytics and AI use cases. Serve as a formal mentor for junior Analytics Engineers—through dbt pair-programming, code review, and design sessions—and may direct the work of contractors, while partnering with Data Engineers, Data Architects, and AI/ML teams on platform standards, CI/CD, and roadmap EDUCATION AND WORK EXPERIENCE 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. Extensive experience (typically 10+ years) in analytics engineering, data engineering, BI development, or a related data discipline Proven track record designing, building, and operating dbt projects in production, including macros, Jinja templating, custom generic tests, semantic layer/metric definitions, and CI/CD integration. Expert SQL with performance tuning, plus experience building and delivering datasets that support AI, machine learning, or advanced analytics. Hands-on experience with modern cloud data platforms and data modeling/normalization for enterprise-scale analytics KNOWLEDGE, SKILLS, ABILITIES Expert-level SQL, including complex joins, CTEs, window functions, and performance tuning. Advanced dbt expertise: macros, Jinja templating, custom generic tests, dbt exposures, semantic layer/metric definitions, CI/CD integration, and documentation-site governance for well-documented, reusable data products Proficiency in data modeling and normalization (star/snowflake, fact/dimension, slowly changing dimensions) and in preparing AI- and analytics-ready datasets. Strong understanding of data governance, metadata management, lineage, and enterprise data quality frameworks Influence technical and business stakeholders across any project or domain. Salary based on experience $118K to $145K 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. Summit Utilities, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or protected veteran status and will not be discriminated against on the basis of disability or veteran status. #J-18808-Ljbffr