Lead Data Analyst

Lead Data Analyst

Collective Health is the leading health benefits platform that brings together medical, dental, vision, pharmacy, and program partners into an integrated solution that better enables employees and their families to understand, navigate, and pay for healthcare.

Job Description

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 Lead Data Analyst, you will be the primary technical lead for our most significant clients and a driving force behind our team's data and analytics excellence. You will move beyond standard reporting to lead complex analyses, with AI first mentality serving as a trusted advisor to key stakeholders by translating healthcare claims data into clear, actionable narratives. This role is designed for a self-starter who thrives in high-pressure environments, capable of leading high-priority projects with tight turnaround times, who can navigate sophisticated data landscapes, lead by example, and deliver high-impact presentations that influence decision-making.

What You'll Do:

• Lead Strategic Reporting & Delivery: Own the end-to-end lifecycle of analytics for leadership and key stakeholders. You will ensure that high-impact reporting is not only delivered on schedule but is strategically aligned with clinical and financial objectives.
• Direct Client Analytics Partnership: Serve as the primary analytics lead for top-tier client requests. You will move beyond requirement gathering to act as a consultant, designing solutions that solve complex healthcare business challenges and presenting these insights directly to key partners.
• Technical Excellence & SQL Mentorship: Establish and uphold the standards for data integrity by leading peer code reviews. You will provide expert guidance on SQL optimization, complex logic validation, and adherence to rigorous data governance and compliance standards.
• Advanced Project & Knowledge Management: Oversee the reporting roadmap and project lifecycle via Jira and Confluence. You will ensure transparent communication of project statuses, maintain technical documentation, and proactively identify risks to delivery timelines.
• Key Stakeholder Communication: Act as the "voice of the data" for key stakeholders. You will translate dense healthcare findings into compelling narratives and high-level presentations, bridging the gap between technical complexity and business-critical decision-making.
• Rapid Impact Assessment: Lead high-priority routine and ad-hoc analyses, including internal and external audits for clients delivering insights in accelerated timeframes when required.
• Architectural Gatekeeping: Identify bottlenecks in the data lifecycle and partner with Data Engineering and Data Architect to move to automated, scalable solutions.

To Be Successful In This Role, You'll Need:

• At least 8 years of experience in healthcare analytics, with a specific emphasis on analyzing healthcare claims data, population health, and member experience.
• Analytical Rigor: Strong critical thinking skills and a resourceful approach to professional development. We value candidates who take ownership of their learning, possess a high degree of initiative, and are committed to delivering results through diligent effort.
• Agility and Learning Velocity: Proven track record of mastering new data environments and complex healthcare schemas with minimal training.
• Automation Mindset: Experience replacing manual hand-offs with automated triggers or self-serve tools.
• Systemic Problem Solving: Proven ability to look across a portfolio of requests and identify the underlying data commonality to maximize impact of every tool or dashboard built.
• Domain Expertise: Deep understanding of the claims lifecycle and nuances involved with reporting logic.
• Technical Proficiency: Proven ability writing and optimizing SQL queries and experience building visualizations/models in Looker (or comparable tools like Tableau).
• Industry Context: Experience working directly with health care claims and or member experience data at a payer provider, TPA, or Point Solution.
• Project Management: Proficiency in Agile tools like Jira for task management and Confluence for process documentation.
• Soft Skills: Ability to communicate technical issues effectively to non-technical stakeholders, and non-technical issues effectively to technical stakeholders.
• Education: Bachelor's degree in Mathematics, Economics, Statistics, Computer Science, Business Administration or a related quantitative field (or equivalent professional experience).

Pay Transparency Statement

This is a hybrid position based out of one of our offices: San Francisco, CA, or Lehi, UT. Hybrid employees are expected to be in the office two days per week.

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 115,000 stock options and benefits like health insurance, 401k, and paid time off. Learn more about our benefits at

San Francisco, CA Pay Range

$120,000 - $150,500 USD

Lehi, UT Pay Range

$96,300 - $120,500 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 View email address on click.appcast.io.

Privacy Notice

For more information about why we need your data and how we use it, please see our privacy policy: