Healthcare Data Analyst II

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.

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/. Lehi, UT Pay Range $75,200 - $93,750 USD Why Join Us?

• Mission-driven culture that values innovation, collaboration, and a commitment to excellence in healthcare
• Impactful projects that shape the future of our organization
• Opportunities for professional development through internal mobility opportunities, mentorship programs, and courses tailored to your interests
• Flexible work arrangements and a supportive work-life balance

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Collective Health is committed to providing support to candidates who require reasonable accommodation during the interview process. If you need assistance, please contact [email protected]. Privacy Notice For more information about why we need your data and how we use it, please see our privacy policy: https://collectivehealth.com/privacy-policy/. Apply tot his job Apply To this Job