Senior Analytics Engineer
Job Description
Health Union LLC is seeking a Senior Analytics Engineer to help turn business needs into trusted, AI-driven data models and tools. In this hybrid role based in Philadelphia, you will work within a modern dbt + Snowflake analytics stack, taking ownership of model delivery end to end while collaborating closely with analysts, stakeholders, and the Data Platforms team.
Role summary
You will design and maintain transformation logic in dbt, develop and migrate semantic models, and strengthen data quality monitoring so issues are identified before they impact stakeholders. A key focus is enabling accurate query generation for AI tools based on natural-language business questions, while ensuring analytics outputs meet real decision-making needs.
Responsibilities
- Design, build, and maintain dbt models that power business intelligence and decision support across Health Union
- Translate business requirements from analysts and stakeholders into documented, tested transformation logic
- Partner with the Data Platforms team to define what data is extracted and loaded, and confirm it is structured for clarity and usability
- Contribute to architecture and design decisions with the team and manager
- Build and maintain semantic models, including migrating existing BI data models into the semantic layer
- Support AI tooling so it generates accurate queries from natural-language business questions
- Work with analysts and stakeholders to verify that AI-driven BI tools meet analytic requirements
- Enhance data quality monitoring so problems are caught before reaching business stakeholders
- Build on existing dbt tests to create a more robust testing framework
- Establish processes and standards that improve reliability of data across the business
- Serve as a senior technical resource for 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 skills in a cloud data warehouse environment; Snowflake experience preferred
- Advanced dbt proficiency, with strength in testing, documentation, and model design best practices
- Deep knowledge of relational and dimensional data modeling, plus 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 to accelerate development and solve business problems
- Clear communication with technical and non-technical teams
- Self-direction and strong organizational skills, with the ability to manage your own priorities
Technologies
- dbt
- Snowflake
- SQL
- Claude
- Python
Benefits
- Medical, dental, and vision insurance
- A 401(k) plan
- A 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 and work model
- Philadelphia, PA (hybrid)
- 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
Notes
Candidates only. No direct calls or emails. No recruiters or agencies, please.