Collective Health is hiring a

Data and Reporting Analyst - CX Data Operations

Chicago, United States

We all depend on healthcare throughout our lifetimes, for ourselves, and our families and friends, but it is notoriously difficult to navigate and understand. As an industry that comprises 20% of the US economy we think healthcare should work better for all of us. At Collective Health we believe it’s time for a new day in healthcare where as members we are informed and empowered to make the right care choices when the decisions are urgent and critical. 

The CX Data Operations team is part of the Customer Experience Organization at Collective Health. We own enabling departments with data to be able to run day-to-day operations, plan, collaborate and optimize our member's experience and be able to make data driven business decisions.

As a Data and Reporting Analyst, you will continue to build and re-shape our organizations' data consumption and create outputs that are meaningful and analytically minded.

While we are embracing a remote-flexible work week, employees are expected to be within commuting distance of an office. The  frequency of in-office days will be determined on a team-by-team basis closer to the reopening of our offices.

What you'll do:

  • Work closely with the Customer Experience departments to improve our reporting and self-service dashboards.
  • Identify business needs and build reporting and analysis to support and track the effectiveness of the business strategy.
  • Translate business questions from ticketing requests into insightful data and reporting.
  • Proactively analyze metrics and data out of own curiosity and to respond to questions from key stakeholders.
  • Maintain critical metric reporting for departments and perform analysis to measure success rates.
  • Create BI/data visualizations that are digestible and maintain automated reporting.
  • Investigate errors in reporting data, implement scalable solutions, and communicate to stakeholders of the data.
  • Assist in Looker governance to deprecate unused dashboards, migrate reporting to new data sources, and communicate updates to downstream data end-users.
  • Maintain a clear understanding of our existing data sources and reports within Looker.

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

  • Ability to grasp new concepts quickly and execute on tasks with great attention to detail.
  • Creative problem solving skills - proactive in finding solutions to high level and granular problems.
  • Solid project management skills, with an ability to lead all aspects of and handle multiple projects at once.
  • Agility to navigate through ambiguity - comfortable with establishing new processes when gaps are present.
  • Excellent planning, organizational, and time management skills.
  • SQL skills and experience developing complex joins and performance tuning queries.
  • Tools and Skills:
  • Data analysis and modeling tools [Looker and writing in LookML]
  • Presto SQL
  • Excel or Google Sheets

Founded in 2013, Collective Health has created an ecosystem of innovative partners across care and benefits delivery, as well as built a powerful and flexible infrastructure to better enable employees and their families to understand, navigate, and pay for healthcare. By reducing the administrative lift of delivering health benefits, providing an intuitive member experience, and improving health outcomes, the company guides employees toward healthier lives and companies toward healthier bottom lines. Collective Health is headquartered in San Mateo, CA with locations in Chicago, IL, and Lehi, UT. For more information, please visit

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].

Looking for a job?

Data and Reporting Analyst - CX Data Operations at Collective Health looks great, right? We have dozens of similar job posts on our site, interested? Leave your email and we'll send the best matches.