Healthcare Data Analyst II

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.

To be successful in this role, you'll need:

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

Pay Transparency Statement 

This is a hybrid position based out of our Lehi office, with the expectation of being in office at least two weekdays per week. #LI-hybrid

The actual pay rate offered within the range will depend on factors including geographic location, qualifications, experience, and internal equity. In addition to the salary, you will be eligible for 35,000 stock options and benefits like health insurance, 401k, and paid time off. Learn more about our benefits at https://jobs.collectivehealth.com/benefits/.