Top 21

Prep plan

Updated weekly · Last refresh Sep 28

Mercy Data Analyst Interview Questions

The questions to prepare for a Mercy Data Analyst interview. Questions from real interview reports rank first. Updated daily.

21questions

~3htotal time

Track your progressSign up free to work through all 21 questions and resume where you left off.

Start practicing free →

1

PipelinesStart here. 5 questions · ~40 min

Data Cleaning in ETL PipelinesEasy

Approach for cleaning and preparing raw data inside an ETL pipeline.

Data WranglingETLQuality

Handling Missing Data in PipelinesMedium

Approach for handling missing data in an ML data pipeline, including validation, imputation, and safe downstream consumption.

InfrastructureETLBatch Processing

Mercy

More Pipelines questions with a free account

2

Behavioral & Leadership9 questions · ~72 min

More Behavioral & Leadership questions with a free account

3

More topics7 questions · ~56 min

Join vs Union in AnalyticsEasy

Explain how JOIN combines columns across related tables while UNION stacks rows from compatible queries in analytics workflows.

JoinsData WranglingUnions

Find Pain Points from FeedbackMedium

Use customer feedback to identify the biggest pain points in the user journey.

User ResearchUser NeedsPain Points

Mercy

Finding Most Impactful VariablesMedium

Tests feature selection and statistical reasoning to identify key drivers.

RegressionCorrelationCausal Inference

Mercy

Designing an A/B Test for EngagementMedium

Tests experimental design, metrics, and validity considerations for healthcare interventions.

ExperimentationGuardrail MetricsA/B Testing

Mercy

Solving Increased Patient Wait TimesMedium

Tests problem framing, metric selection, and data-driven root-cause analysis.

KPIsLeading IndicatorsDiagnosis

Mercy

Writing a SQL QueryEasy

Tests practical SQL skills for extracting relevant healthcare data.

JoinsData WranglingAggregations

Mercy

More questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan

Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min

Monthly Sales Trends by CategoryMedium

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData Wrangling

Total Wine & More

Cleaning a Messy DatasetMedium

Filter invalid game events and normalize event names using PostgreSQL string and null handling.

missing valuesdata cleaningnull handling

Handle Missing Financial Input ValuesMedium

Use joins, CTEs, and CASE logic to flag and fill missing financial fields for Qlik planning records.

Data WranglingETLQuality

The finish line: interview-readyComplete all 21 questions plus 3 hands-on drills to finish this plan.