Collective Health Logo

Collective Health

Lead Data Analyst

Posted 3 Days Ago
In-Office
San Francisco, CA, USA
120K-151K Annually
Senior level
In-Office
San Francisco, CA, USA
120K-151K Annually
Senior level
As a Lead Data Analyst, you'll lead complex analyses, manage client analytics partnerships, ensure data integrity and optimize SQL, while delivering actionable insights and influencing decision-making for stakeholders.
The summary above was generated by AI

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.
  • 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, 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.#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 115,000 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
$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 [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/.

Top Skills

Confluence
JIRA
Looker
SQL
Tableau

Similar Jobs

4 Days Ago
In-Office or Remote
19 Locations
106K-155K Annually
Senior level
106K-155K Annually
Senior level
Information Technology • Internet of Things
The Data Analyst will build data pipelines, analyze complex datasets, and provide insights to support decision-making across multiple stakeholders in GFiber.
Top Skills: AdyenBigQueryCoupaGCPGoogle Cloud PlatformHTMLLookmlPythonSAPSQLZuora
4 Days Ago
In-Office or Remote
19 Locations
87K-128K Annually
Junior
87K-128K Annually
Junior
Information Technology • Internet of Things
As a Data Analyst at GFiber, you'll analyze complex datasets, present insights, collaborate with teams, and develop visualizations to drive impactful data-driven decisions.
Top Skills: BigQueryData Visualization TechnologiesGoogle Cloud PlatformLookerSQL
12 Days Ago
Easy Apply
Remote or Hybrid
United States
Easy Apply
97K-189K Annually
Senior level
97K-189K Annually
Senior level
Big Data • Cloud • Software • Database
As a Senior Data Analyst II, you will support growth initiatives by analyzing revenue metrics, automating workflows, and providing insights to drive customer success.
Top Skills: PythonRSQL

What you need to know about the San Francisco Tech Scene

San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.

Key Facts About San Francisco Tech

  • Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Google, Apple, Salesforce, Meta
  • Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
  • Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
  • Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account