Senior Analytics Engineer

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

Location: Philadelphia, PA Health Union powers the first and largest community-based activation and data platform, transforming healthcare by providing unparalleled support, information, and validation for millions navigating complex health conditions and their care teams. With over 125+ condition-specific online communities and 15 years of community leadership, Health Union’s authentic engagements fuel the company’s robust suite of endemic media, influencer marketing, market research, and data solutions, driving proven outcomes for patients, HCPs, and brands.

Job Title: Senior Analytics Engineer
Location: Philadelphia, PA Health Union powers the first and largest community-based activation and data platform, transforming healthcare by providing unparalleled support, information, and validation for millions navigating complex health conditions and their care teams. With over 125+ condition-specific online communities and 15 years of community leadership, Health Union’s authentic engagements fuel the company’s robust suite of endemic media, influencer marketing, market research, and data solutions, driving proven outcomes for patients, HCPs, and brands.

Position Overview

At Health Union, data is the foundation of how we understand our business and serve our communities. Our Analytics Engineering team turns raw data into trusted insights for decision-makers across the organization, working in a modern stack built on dbt and Snowflake, along with AI tools like Claude.

We’re looking for a Senior Analytics Engineer to own work end to end: translating business requirements into robust, well-documented data models, then turning those models into intuitive AI-driven tools that stakeholders rely on. You’ll also partner with our Data Platforms team on everything from ingestion to transformation readiness, including building and evolving the data quality monitoring that catches issues before they reach a dashboard.

This is a highly collaborative role. You’ll work closely with business analysts and stakeholders across the organization to understand their needs and deliver data they can trust. If you enjoy pairing technical rigor with cross-functional partnership, we’d love to hear from you.

What You Do

Data Modeling & Transformation

• Design, build, and maintain dbt models that power 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 what data is extracted and loaded from source systems, and confirm it’s structured for clarity and usability
• Contribute to architectural and design decisions with your team and manager

Semantic Layer Development

• Build and maintain semantic models, including migrating existing BI data models into the semantic layer
• Make sure AI tools generate accurate queries from natural-language business questions
• Partner with analysts and stakeholders to confirm that AI-driven BI tools meet their analytic needs

Data Quality

• Enhance our existing data quality monitoring so issues are caught before they reach business stakeholders
• Build on our current dbt tests to design a more robust testing framework
• Establish processes and standards that improve the reliability of data across the business

Collaboration & Issue Resolution

• Serve as a senior technical resource for analysts and stakeholders, helping diagnose and resolve data issues
• Raise the team’s technical bar through code review, documentation, and knowledge sharing
• Manage and prioritize work transparently within the team’s Kanban process

Qualifications

What You Bring:

• 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

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

Annual base salary for positions at this level and job group is $95,000-$120,000, and your base pay will depend on the qualifications, experience, skills, and competencies required for this job.

At Health Union, base pay is one part of our total compensation package and is determined within a range that provides the opportunity to progress as you grow and develop within a role.

In addition, our Total Rewards package includes medical, dental, and vision insurance, a 401(k) plan, a professional development budget, and paid time off available to full-time employees upon hire. You will also be granted time off for designated company-paid holidays, summer Fridays, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.

HEALTH UNION REALLY IS THE BEST PLACE TO WORK

As a dynamic organization that offers flexible work options, we foster a workplace that encourages an authentic, respectful culture of teaching and learning. We work hard and save space to form close-knit relationships that are meaningful to us individually. Health Union also offers top-tier benefits and other perks to full-time employees, starting day one. We cultivate a dynamic, collaborative work environment that values inclusion, community, excellence, and transparency. But don’t just take our word for it: The Philadelphia Inquirer, Philadelphia Business Journal, Inc., and Forbes have all named Health Union a "best place to work"-and we take pride in living up to that hype every day.

Commitment to Inclusion

At Health Union, we believe that individually we make a statement, but collectively we make an impact. Diversity and inclusion power that impact. We strive to create a sense of belonging by embracing our differences. We are an organization where everyone is valued, heard, and appreciated. Health Union encourages applicants from historically marginalized populations to consider our team as your next opportunity for change. We are committed to equal employment opportunity and advancement regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or gender expression, Veteran status, or any other characteristic protected by applicable law.

To comply with federal law, Health Union participates in E-Verify. Successful candidates must pass the E-Verify process after hire.

The position offers a hybrid work arrangement, requiring a minimum of two in-office days per week. Our office is located in Center City, Philadelphia.

Applicants must be legally eligible to work in the U.S for any employer.

• Candidates only. No direct calls or emails. No recruiters/agencies, please.