Analytics Engineer II — dbt & Data Platforms (Hybrid)

Summit Utilities Inc; Fayetteville (AR); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive pay

Medical/dental/vision benefits

Job summary

Summit Utilities Inc in Fayetteville, AR is hiring an Analytics Engineer II to design, develop, test, and maintain dbt-managed datasets within Microsoft Fabric and Azure SQL. You will own subject areas from profiling to deployment and monitoring, delivering analytics-ready data for reporting, regulatory submissions, and operational decisions.

You will focus on independent dbt model development, end-to-end data delivery, and collaboration with Data Engineers to ensure data quality and governance

Qualifications

• Degree in a data-related field or equivalent experience.
• 3–6 years in analytics/data engineering or BI development.
• Hands-on dbt model development in production or near-production.
• Strong SQL skills for complex queries and optimization.
• Experience with cloud data environments and CI/CD workflows.

Responsibilities

• Design, build, and maintain dbt models across subject areas.
• Write and maintain dbt schema tests and source freshness checks.
• Optimize SQL transformations for performance and cost.
• Investigate and resolve data discrepancies with Data Engineers.
• Document data requirements and translate to dbt models.
• Maintain dbt project structure, including refs, sources, YAML, and packages.
• Author documentation in dbt docs and collaborate on CI/CD workflows.
• Mentor peers and participate in standups, planning, and reviews.
• Develop knowledge of utility data domains like billing and AMI.

Skills

dbt models

SQL

cloud data environments

CI/CD

Git/Azure DevOps

data governance

documentation

ETL/ELT

refs/sources

dbt schema tests

Education

Bachelor's degree in data Analytics, Information Systems, Computer Science, Mathematics, or related field

Master's degree in a quantitative field preferred

Tools

dbt

dbt_utils

dbt_expectations

Microsoft Fabric

Azure SQL

Azure DevOps

Git

GitHub

YAML

SAP

Job description

Summit Utilities Inc in Fayetteville, AR is hiring an Analytics Engineer II to design, develop, test, and maintain dbt-managed datasets within Microsoft Fabric and Azure SQL. You will own subject areas from profiling to deployment and monitoring, delivering analytics-ready data for reporting, regulatory submissions, and operational decisions.

You will focus on independent dbt model development, end-to-end data delivery, and collaboration with Data Engineers to ensure data quality and governance