Analytics Engineer II

Posted Yesterday
Denver, CO, USA
In-Office
Mid level
Utilities
The Role
Designs, develops, tests, documents, and maintains dbt-based analytics data products in Microsoft Fabric and Azure SQL. Responsibilities include SQL transformation optimization, data quality testing, governance, metadata management, root-cause analysis, pipeline collaboration, CI/CD participation, requirements gathering, documentation, and mentoring. The role owns utility data subject areas such as billing, AMI, SAP, SCADA, and GIS from source profiling through deployment and monitoring.
Summary Generated by Built In

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 that’s committed to delivering reliable energy 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 opportunity for an Analytics Engineer II (SGL17) based in Little Rock, Arkansas. This hybrid role may be based in one of our offices in Little Rock, Fort Smith, or Fayetteville, Arkansas, or remote based in Texas.

POSITION SUMMARY

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.

PRIMARY DUTIES AND RESPONSIBILITIES

  • 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.

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.
  • 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.

KNOWLEDGE, SKILLS, ABILITIES 

  • 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.

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.

Skills Required

  • 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 with relational databases, including query writing, optimization, and stored procedures
  • Experience working within cloud-based data environments such as Microsoft Fabric, Azure SQL, AWS, or similar
  • Familiarity with source control practices and CI/CD workflows for analytics or data projects
  • Proficiency in SQL, including complex joins, CTEs, window functions, and subqueries
  • Working knowledge of dbt models, schema tests, packages, refs, and sources
  • Understanding of ETL/ELT concepts and the data lifecycle
  • Familiarity with data governance and metadata management
  • Familiarity with API integrations, CSV, JSON, XML, and SAP data structures
  • Bachelor's degree in analytics, information systems, computer science, mathematics, or a related field; equivalent experience considered
  • Master's degree in a quantitative field
  • Working knowledge of Microsoft Fabric or Azure SQL
  • Working knowledge of natural gas utility data systems, including billing, AMI, and SCADA
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Centennial, CO
500 Employees
Year Founded: 1997

What We Do

Summit Utilities, Inc. is a privately-held holding company that owns and operates several natural gas distribution and transmission subsidiaries that operate in Arkansas, Colorado, Maine, Missouri, Oklahoma, and the Texarkana, Texas area. The company provides safe, clean and affordable natural gas to businesses and residents in six states through Arkansas Oklahoma Gas, Colorado Natural Gas, Summit Natural Gas of Maine, Summit Natural Gas of Missouri, Summit Utilities of Arkansas, and Summit Utilities of Oklahoma. Each of Summit’s natural gas distribution and transmission subsidiaries constructs and installs natural gas distribution systems with the goal of supporting economic development by providing clean-burning, safe and reliable natural gas to residential and commercial customers through exceptional customer service and commitment to community. Overall, Summit entities serve approximately 625,000 customers and operate more than 23,400 miles of pipeline. Being part of the Summit team means embracing excellence, diversity 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. To see our latest job openings, please visit: https://summitutilitiesinc.com/careers See also: Colorado Natural Gas at https://www.linkedin.com/company/colorado-natural-gas/ Summit Natural Gas of Missouri at https://www.linkedin.com/company/summit-natural-gas-of-missouri/ Summit Natural Gas of Maine at https://www.linkedin.com/company/summit-natural-gas-of-maine/ Arkansas Oklahoma Gas (AOG) at https://www.linkedin.com/company/arkansas-oklahoma-gas-corp./ and Summit Utilities https://www.linkedin.com/company/summit-utilities

Similar Jobs

EchoStar Logo EchoStar

Analytics Engineer

Aerospace • Cloud • Digital Media • Information Technology • Mobile • News + Entertainment • Generative AI
In-Office
Englewood, CO, USA
14500 Employees
72K-103K Annually

Lowe’s Logo Lowe’s

Full Time - Sales Specialist - ProServices - Day

Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Hybrid
Littleton, CO, USA
300000 Employees

Lowe’s Logo Lowe’s

Part Time - Fulfillment Associate - Flexible

Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Hybrid
Colorado Springs, CO, USA
300000 Employees

Lowe’s Logo Lowe’s

Cashier Part Time

Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Hybrid
Fort Collins, CO, USA
300000 Employees

Similar Companies Hiring

Treeswift Thumbnail
Artificial Intelligence • Hardware • Machine Learning • Robotics • Software • Utilities
New York, New York
75 Employees
Energy CX Thumbnail
Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Chicago, IL
150 Employees
Ford Energy Thumbnail
Automotive • Software • Energy • Utilities • Manufacturing • Renewable Energy
US

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account