Prepare for and practice interview questions from Collective Health.

Collective Health Interview Questions

Collective Health Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Collective Health Salaries by Position

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. Collective Health's mission is to transform people's healthcare experience from confusing and complicated to empowering and trustworthy. We are looking for a stellar Senior Product Manager to focus on reporting, analytics, and plan administration capabilities in our employer portal to make it effortless for employers and their advisors to access actionable insights and take action on the performance of their health plans. Our goal is to provide the most configurable, reliable, and easy to use benefits administration experience for our customers, and flexible, accurate, and insightful self-service reporting & analytics is a critical component to the administration experience. As a Senior Product Manager, you'll work closely with our engineering, design, data science, analytics, operations, and commercial teams to continually enhance our products and optimize healthcare value for employers, as well as employees and their dependents . You'll work closely with a diverse and multi-disciplinary team to gather, structure, and prioritize product requirements from internal and external stakeholders to execute your roadmap across our deep technology stack and deliver industry-leading service at scale. What you will Do: <ul><li>Own and drive the product vision, strategy, roadmap, and prioritization for our employer-facing platform</li><li>Build best-in-class, compliant, and intuitive tooling to help employers analyze, administer, and understand their plan performance</li><li>Apply your expertise in data, reporting, and analytics to inform a broader data strategy on how we expose and package analytics for consumption</li><li>Collaborate with data scientists, data engineers, business analysts, product engineers, and the many internal & external stakeholders to balance dependencies, priorities, and resources</li><li>Center the voice of the customer in your work by pulling from and continually seeking out feedback through interviews, user testing, and other research means</li><li>Work with our account management team to define, drive, measure, and monitor initiatives that contribute to one our biggest company objectives: create and retain delighted customers</li><li>Be the evangelist for your product area across all areas of the organization to find breakthrough opportunities for shared learning, partnership, and celebration </li><li>Partner with design, engineering, data science, and analytics teams to ensure that features are delivered with high quality, scalability, and efficiency</li><li>Communicate progress and maintain accountability to stakeholders, functional owners, and internal team members</li></ul> Your skills include: <ul><li>8 years of experience in healthcare technology product management </li><li>Deep expertise in managing, analyzing, and reporting on complex data for actionable insights</li><li>Bachelor's degree in a technical discipline or equivalent experience</li><li>Excellent problem solving and communication skills</li><li>Fervent passion to solve healthcare challenges to improve the lives of others</li><li>Adaptability to thrive in highly complex and changing environments</li><li>Familiarity with enterprise software development, experience with data-based products highly preferred</li><li>Familiarity with operating in regulated industries (HIPAA, FINRA, CCPA, etc.)</li><li>Excellent organizational skills with the ability to keep track of multiple projects simultaneously</li></ul>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 three days per week (Plano, TX) or two days per week (Lehi, UT and San Francisco, CA). #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 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 $145,000-$181,500 USD Lehi, UT Pay Range $116,000-$145,000 USD Plano, TX Pay Range $128,000-$160,000 USD About Collective Health 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. By reducing the administrative lift of delivering health benefits, providing an intuitive member experience, and helping control costs and improve outcomes, the company guides employees toward healthier lives and companies toward healthier bottom lines. 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 recruiting-accommodations@collectivehealth.com. 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/.

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. Collective Health's mission is to transform people's healthcare experience from confusing and complicated to empowering and trustworthy. We are looking for a Product Manager (PM) of Eligibility to assist us in our mission to empower Collective Health and support our members and their families to take better care of their own health and benefits. The Collective Heath Eligibility team supports care delivery by managing and creating solutions which accommodate the Electronic Data Interchange and usability of Member Eligibility data. This critical Eligibility data is foundational to both Collective Health's operations and the Member experience. What you'll do: <ul><li>As a PM with Collective Health you will be an integral part of the Engineering Team who works closely with Eligibility Product Management to convert actionable capabilities into Stories, Requirements and successful sprints to deliver valuable functionality furthering the Collective Health mission.</li><li>This role will participate in Agile meetings, such as Scrum and Story Review, and be responsible for Backlog Grooming and Management.</li><li>With Product Management guidance, you will be involved in aligning the sprint work to Road Map priorities while targeting delivery timeframe commitments.</li><li>Additional activities will include assisting the engineering team(s) in related activities such as triage of incoming engineering support tasks, managing user acceptance testing engagements and cross-team collaborations. </li></ul>To be successful in this role, you'll need: <ul><li>Familiarity with Agile Development Methodologies</li><li>A minimum of 4+ years experience as an Agile Product Owner and/or 2+ year experience as Agile Product Manager.</li><li>Agile Product Owner and/or Product Manager Certifications are a plus.</li><li>To be skilled in using Jira in both Kanban and Scrum methodologies and experience in writing well-formed User Stories. </li><li>Confluence experience is a plus.</li><li>Experience reading and creating Software Requirements, Test Scripts and EDI File Layouts or similar Specifications. </li><li>Familiarity with Healthcare concepts and operations related to Insurance Eligibility. </li><li>Healthcare Electronic Data Interchange experience with varying file standards / formats such as X12, CSV and position delimited preferred. </li><li>Relational Database and SQL Experience a plus.</li><li>To be adaptive and thrive in a highly complex and changing environment. </li><li>Familiarity with Healthcare regulations and operating in HIPAA regulated industries. </li><li>Excellent Jira Backlog organizational skills with the ability to keep track of multiple projects simultaneously. </li></ul>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 three days per week (Plano, TX) or two days per week (all other locations). #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 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 $130,000-$162,000 USD Lehi, UT Pay Range $104,500-$130,000 USD Plano, TX Pay Range $114,000-$142,500 USD About Collective Health 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. By reducing the administrative lift of delivering health benefits, providing an intuitive member experience, and helping control costs and improve outcomes, the company guides employees toward healthier lives and companies toward healthier bottom lines. 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 recruiting-accommodations@collectivehealth.com. 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/.

Collective Health Interview Questions

Collective Health Interview Guides

Collective Health Interview Questions

Collective Health Salaries by Position

Collective Health Opening Jobs