Senior Analytics Engineer

• 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

• 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

• 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 $105K to $130K 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.