Collective Health

Lead Data Analyst

Collective Health$110K — $137K *
Lehi, UT 84043In-Person
Healthcare
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years of healthcare analytics experience, focusing on healthcare claims data.
  • Strong critical thinking and initiative for professional development.
  • Proven agility in mastering new data environments and complex schemas.
  • Experience in automating processes and implementing self-serve tools.
  • Deep understanding of claims lifecycle and reporting logic nuances.
  • Proficient in writing and optimizing SQL queries and building dashboards/visualizations in Looker or similar tools.
  • Bachelor's degree in a quantitative field or equivalent experience.

Responsibilities

  • Lead end-to-end analytics lifecycle for reporting, ensuring alignment with clinical and financial goals.
  • Serve as primary analytics consultant for top-tier client inquiries, designing solutions for complex healthcare challenges.
  • Establish data integrity standards through peer code reviews and provide SQL optimization mentorship.
  • Manage reporting projects using Jira and Confluence, maintaining clear communication on statuses and risks.
  • Translate complex healthcare data findings into clear narratives and presentations for stakeholders.
  • Conduct timely routine and ad-hoc analyses for clients, particularly during high-priority needs.
  • Identify data lifecycle bottlenecks and collaborate with Data Engineering to create automated solutions.

Benefits

  • Health insurance coverage.
  • 401(k) plan with company match.
  • Paid time off for vacations and personal use.
  • Employee stock options.
  • Hybrid work model with flexible office requirements.
Full Job Description
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:
  • Experience: 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.
  • Strong critical thinking: resourcefulness, initiative, and ownership of professional development are valued. Candidates must be committed to diligent effort and delivering results.
  • 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, tech company, 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, Plano, TX, or Lehi, UT. Hybrid employees are expected to be in the office two days 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 171,875 stock options and benefits like health insurance, 401k, and paid time off. Learn more about our benefits at https://jobs.collectivehealth.com/benefits/.

San Francisco, CA Pay Range

$137,500-$171,875 USD

Lehi, UT Pay Range

$110,000-$137,500 USD

Plano, TX Pay Range

$121,000-$151,250 USD

About Collective Health

Collective Health is a technology company that provides a cloud-based platform for self-insured employers to manage their employee health benefits. The platform includes tools for plan design, enrollment, claims processing, and member engagement. Collective Health was founded in 2013 and is headquartered in San Francisco, California. The company has raised over $400 million in funding and has partnerships with several major insurance carriers, including Aetna, Cigna, and Anthem.
Learn more about Collective Health
Size
500 employees
Industry
Founded
2013

Similar Jobs

More Jobs at Collective Health

More Healthcare Jobs

Find similar Lead Data Analyst jobs: