Senior Analytics Engineer - dbt + Snowflake AI-Driven BI

HEALTH UNION LLC; Philadelphia (Philadelphia County); Hybrid; USD 95,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k) plan

Professional development budget

Paid time off

Job summary

Health Union LLC in Philadelphia, PA is seeking a Senior Analytics Engineer to design and maintain dbt models on a Snowflake-based analytics stack, delivering trusted insights for business decisions. You will translate analyst and stakeholder requirements into tested, well-documented transformation logic, build semantic models, and collaborate with Data Platforms to ensure data quality and governance.

The role emphasizes AI-enabled BI, data observability, and an engineering mindset within a

Qualifications

• 5+ years of experience in analytics engineering or a similar role.
• Advanced SQL in a cloud data warehouse environment; Snowflake preferred
• Advanced dbt skills, especially testing, documentation, and model design best practices
• Strong understanding of relational and dimensional data modeling, plus data warehouse and BI system design principles
• Proven ability to convert business questions and stakeholder needs into data models and reporting solutions
• Experience with, or strong instincts for, data quality monitoring and observability
• Hands-on use of AI tools to accelerate development and solve business problems
• Clear communication with technical and non-technical teams
• Self-directed and well-organized, able to manage personal priorities

Responsibilities

• Design, build, and maintain dbt models that support business intelligence and decision support across Health Union
• Translate business requirements from analysts and stakeholders into well-structured, documented, and tested transformation logic
• Partner with the Data Platforms team to define extracted and loaded datasets from source systems and validate clarity and usability
• Contribute to architectural and design decisions with the team and manager
• Build and maintain semantic models, including migrating existing BI data models into the semantic layer
• Ensure AI tools generate accurate queries from natural-language business questions
• Work with analysts and stakeholders to confirm that AI-driven BI tools meet analytic needs
• Enhance data quality monitoring so issues are identified before they reach business stakeholders
• Expand existing dbt tests to create a more robust testing framework
• Establish processes and standards to improve data reliability across the business
• Act as a senior technical resource for analysts and stakeholders, diagnosing and resolving data issues
• Raise the team’s technical bar through code review, documentation, and knowledge sharing
• Manage and prioritize work transparently using the team’s Kanban process

Skills

Advanced SQL

Analytical thinking

Self-directed

Clear communication

Tools

dbt

Snowflake

Claude

Python

Job description

Health Union LLC in Philadelphia, PA is seeking a Senior Analytics Engineer to design and maintain dbt models on a Snowflake-based analytics stack, delivering trusted insights for business decisions. You will translate analyst and stakeholder requirements into tested, well-documented transformation logic, build semantic models, and collaborate with Data Platforms to ensure data quality and governance.

The role emphasizes AI-enabled BI, data observability, and an engineering mindset within a