Healthcare Data Analyst II

Collective Health•Lehi, UT

2d•$75,200 - $93,750•Hybrid

About The Position

At Collective Health, we’re transforming how employers and their people engage with their health benefits by seamlessly integrating cutting-edge technology, compassionate service, and world-class user experience design. As a Healthcare Data Analyst, you will serve as a bridge between complex healthcare data and actionable business strategy. You will be responsible for delivering high-impact insights through ad-hoc and custom reporting, with a specific focus on health care claims data. You won’t just run reports; you will partner with internal and external stakeholders to define requirements, scale self-service capabilities via Looker, and maintain the technical integrity of our analytics through collaborative SQL code reviews. This role is ideal for a self-sufficient, intellectually curious analyst who thrives in a fast-paced environment and is passionate about improving healthcare through data excellence. What you'll do: Strategic Reporting & Delivery: Manage the end-to-end delivery of ad-hoc and recurring reports for internal teams and external stakeholders, ensuring data is actionable and delivered on schedule. Custom Client Solutions: Partner with strategic clients to gather requirements and build bespoke reporting assets that address specific healthcare business challenges. Self-Service Scaling: Expand the organization’s self-service capabilities by building and maintaining scalable data models and dashboards within Looker. SQL Quality Assurance: Partner with the analytics team to conduct peer code reviews in SQL, ensuring logic accuracy, performance optimization, and adherence to data governance standards. Project & Knowledge Management: Maintain high standards of documentation in Confluence and oversee the reporting lifecycle via Jira, ensuring all administrative tasks and project statuses are transparent and up to date.

Requirements

2–4 years of experience in healthcare analytics , with a specific emphasis on analyzing healthcare claims data , population health, and member experience.
Proven expertise in writing and optimizing SQL queries and experience building visualizations/models in Looker .
Experience working in fast-paced, quantitative environments where high attention to detail and data integrity are non-negotiable.
Bachelor’s degree in Mathematics, Economics, Statistics, Computer Science, or Business Administration
Proficiency in Agile tools like Jira for task management and Confluence for process documentation.

Responsibilities

Manage the end-to-end delivery of ad-hoc and recurring reports for internal teams and external stakeholders, ensuring data is actionable and delivered on schedule.
Partner with strategic clients to gather requirements and build bespoke reporting assets that address specific healthcare business challenges.
Expand the organization’s self-service capabilities by building and maintaining scalable data models and dashboards within Looker.
Partner with the analytics team to conduct peer code reviews in SQL, ensuring logic accuracy, performance optimization, and adherence to data governance standards.
Maintain high standards of documentation in Confluence and oversee the reporting lifecycle via Jira, ensuring all administrative tasks and project statuses are transparent and up to date.