Senior Analytics Engineer - AI-Driven Data & Quality Lead

Health Union; Philadelphia (Philadelphia County); Hybrid; USD 95,000 - 120,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) plan

Professional development budget

Paid time off

Holidays

Summer Fridays

Personal/Family Care

Job summary

Health Union is seeking a Senior Analytics Engineer to own data modeling and semantic layer development in a hybrid Philadelphia, PA setting. You will translate business needs into robust data models, build AI-driven BI tools, and partner with the Data Platforms team on ingestion and quality monitoring.

You will collaborate with analysts and stakeholders to ensure trusted data and actionable insights, contributing to architecture decisions and ensuring rigorous testing and documentation.

Qualifications

• 5+ years of experience in analytics engineering or a similar role.
• Advanced SQL skills in a cloud data warehouse environment; Snowflake experience preferred.
• Advanced dbt proficiency, especially in testing, documentation, and model design best practices.
• Deep knowledge of relational and dimensional data modeling, as well as data warehouse and BI system design principles.
• Proven ability to translate 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, both to accelerate development and to solve business problems directly.
• Clear communication with technical and non-technical teams alike.
• Self-direction and strong organizational skills, with the ability to manage your own priorities.

Responsibilities

• Design, build, and maintain dbt models powering BI and decision support across Health Union
• Translate business requirements from analysts and stakeholders into well-structured, documented, and tested transformation logic
• Build and maintain semantic models, including migrating BI data models into the semantic layer
• Enhance data quality monitoring and dbt tests to create a robust testing framework
• Serve as a senior technical resource for analysts and stakeholders, guiding data issue resolution and knowledge sharing

Skills

Analytics engineering

SQL mastery

dbt proficiency

Data modeling

AI tools usage

Communication

Self-management

Tools

Snowflake

dbt

Python scripting

Job description

Health Union is seeking a Senior Analytics Engineer to own data modeling and semantic layer development in a hybrid Philadelphia, PA setting. You will translate business needs into robust data models, build AI-driven BI tools, and partner with the Data Platforms team on ingestion and quality monitoring.

You will collaborate with analysts and stakeholders to ensure trusted data and actionable insights, contributing to architecture decisions and ensuring rigorous testing and documentation.