Prepare for and practice interview questions from Marathon Health.

Marathon Health Interview Questions

Marathon 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

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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?

Marathon Health Salaries by Position

Marathon Health is a leading provider of advanced primary care in the U.S., serving 2.5 million eligible patients through approximately 630 employer and union-sponsored clients. Our comprehensive services include advanced primary care, mental health, occupational health, musculoskeletal, and pharmacy services, delivered through our 680+ health centers across 41 states. We also offer virtual primary care and mental health services accessible in all 50 states. Transforming healthcare delivery with a patient-first approach, we prioritize convenient access to both in-person and virtual care, resulting in improved health outcomes and significant cost savings. Committed to inclusivity and collaboration, we foster a positive work environment and recruit exceptional talent to ensure expertise and compassion in healthcare delivery. Marathon has been recognized as a five-time Modern Healthcare Best Places to Work in Healthcare winner and a six-time Best in KLAS award winner for employer-sponsored healthcare services. ABOUT THE JOB Data is a core pillar of Marathon Health and plays an integral role in delivering first-class healthcare services to our patient population. We utilize a wide variety of data and analytic tools to produce valuable insights that drive better patient outcomes. As a Senior Business Analyst, you will collaborate with stakeholders, product owners, and engineers to synthesize, articulate, and document business objectives. You will serve as the conduit between the business and engineers to ensure alignment, collaboration, and value delivery in our data processes and products. The role requires the use of Agile methodology best practices to understand and define business requirements, create and groom user stories, and translate requirements into technical design. To be successful in this role, you will need strong interpersonal, collaborative, and communication skills to understand and communicate business needs, assess solutions, and document detailed requirements. ESSENTIAL DUTIES & RESPONSIBILITIES <ul><li>Leads and facilitates efforts in collaborating with stakeholders and users to synthesize, articulate, and document business and system requirements. </li><li>Understands and considers the business and Data Engineering needs to ensure quality products and related operational workflows to meet desired business objectives. </li><li>Provides direction, support, mentorship, and feedback to other Business Analysts on the Data Engineering team. </li><li>Performs scrum master, project manager, program manager, and change management roles (as needed). </li><li>Develops epics and stories with the Data Engineering manager or product owner to support the development and implementation of new systems and the enhancement of existing systems </li><li>Works with Data Engineers, Architects, and IT personnel on the technical design and development process to ensure business requirements are understood and delivered. </li><li>Coordinates and assists in the creation and enhancement of systems design; including data models, data migration rules, business rules, and other deliverables associated with the development life cycle. </li><li>Leads the development and implementation of communication plans for all stakeholder groups and manages customer and stakeholder expectations. </li><li>Collaborates with key stakeholders to develop training and knowledge-based materials and trains peers, end-users, and other IT team members. </li></ul> QUALIFICATIONS Bachelor's degree and 7+ years of experience working as a Business Analyst or equivalent combination of education and experience. 4+ years of experience working with healthcare data. 2+ years of experience leading Agile Scrum ceremonies and activities. DESIRED ATTRIBUTES <ul><li>Experience providing business analyst support in a Data Engineering or Analytics environment </li><li>Excellent at writing SQL queries </li><li>Excellent written, verbal, and presentation skills </li><li>Experience working with healthcare payer data and EMR systems </li><li>Experience with project management tools such as Azure Devops </li><li>Knowledge of Salesforce </li></ul> Pay Range: $90,000 - $120,000/yr The actual offer may vary dependent upon geographic location and the candidate's years of experience and/or skill level. We are accepting applications for this position until a candidate has been selected. To apply to this position and learn more about open jobs at Marathon Health, visit our careers page. Marathon Benefits Summary We believe in empowering teammates to do their best work and build better healthcare. Below are some of our benefit offerings. Eligibility is based on 24/hr week. <ul><li>Health and Well-Being: Free Marathon membership for in person and virtual care, employer paid life and disability insurance, and choice in medical/dental plans, vision, employer funded HSA, FSA, and voluntary illness, accident and hospitalization plans. Benefits are effective on the first of the month following date of hire. </li><li>Financial Support: Competitive compensation, 401k match, access to financial coaching through our Employee Assistance Program</li><li>Lifestyle: Paid time off for vacation, sick leave, and more, holiday schedule</li></ul>

Marathon Health Interview Questions

Marathon Health Interview Guides

Marathon Health Interview Questions

Marathon Health Salaries by Position

Marathon Health Opening Jobs