Senior Analytics Engineer

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

Senior Analytics Engineer role focused on building trusted analytics in a modern dbt + Snowflake stack.

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

Requirements

• 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

Technologies

• dbt
• Snowflake
• SQL
• Claude
• Python

Benefits

• Medical, dental, and vision insurance
• 401(k) plan
• Professional development budget
• Paid time off available to full-time employees upon hire
• Time off for designated company-paid holidays
• Summer Fridays
• Personal/Family Care
• Other leaves of absence when needed

Nice to Have

• Experience building semantic models or working with a semantic layer
• Python scripting experience
• Background in health, pharmaceutical, or online publishing data
• Familiarity with Kanban or similar lightweight delivery frameworks

Location

• Philadelphia, PA
• Center City, Philadelphia (office location)
• Hybrid work arrangement, requiring a minimum of two in-office days per week

Compensation

• USD 95,000 - 120,000 per year

Compliance

• Health Union participates in E-Verify
• Successful candidates must pass the E-Verify process after hire
• Applicants must be legally eligible to work in the U.S for any employer