Senior Analytics Engineer
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
Notes
- Candidates only. No direct calls or emails.
- No recruiters/agencies, please.