Top 10
Prep plan
Updated weekly · Last refresh Aug 30

NewYork-Presbyterian Hospital Data Analyst Interview Questions

The questions to prepare for a NewYork-Presbyterian Hospital Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

10questions
~1htotal time
Track your progressSign up free to work through all 10 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Handling Nulls in JoinsMedium

Tests practical SQL and data handling approaches for incomplete clinical data.

null handlingsqldata integrityNewYork-Presbyterian Hospital
Optimize Slow SQL QueriesMedium

Tests your SQL performance troubleshooting and optimization approach for production analytics.

Performance Tuningquery optimizationsqlNewYork-Presbyterian Hospital
SQL Join Types ExplainedEasy

Tests understanding of SQL join semantics and when to use each join type.

data relationshipssql basicsJoinsNewYork-Presbyterian Hospital
Maintain Integrity Across SourcesMedium

Tests data quality controls and integrity checks during multi-source data integration.

Data Qualitydata integrityNewYork-Presbyterian Hospital
SQL and Python ProficiencyMedium

Assesses your hands-on ability to use SQL and Python for data analysis.

sqlpythonNewYork-Presbyterian Hospital
Using Clarity to Extract DataMedium

Evaluates your experience extracting and preparing data from Clarity for healthcare analytics.

Toolsdata extractionNewYork-Presbyterian Hospital
SQL Duplicate Record DetectionEasy
Practice
Practice drill

Find duplicate American Institutes for Research assessment submissions using a CTE, GROUP BY, HAVING, and joins.

deduplicationsqldata integrityAmerican Institutes for ResearchMacy's
Write a Query for Repeated RowsMedium
Practice
Practice drill

Find repeated Zomato order items using GROUP BY, HAVING, a CTE, and STRING_AGG.

sqldata integrityZomato
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
2
Behavioral & Leadership3 questions · ~24 min
Managing Tight Data DeadlinesMedium

Tests prioritization, time management, and stakeholder alignment under pressure.

stress managementtime managementPrioritizationNewYork-Presbyterian Hospital
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 10 questions plus 3 hands-on drills to finish this plan.