Top 14
Prep plan
Updated weekly · Last refresh Nov 21

Johns Hopkins University Business Analyst Interview Questions

The questions to prepare for a Johns Hopkins University Business Analyst interview. Questions from real interview reports rank first. Updated daily.

14questions
~2htotal time
Track your progressSign up free to work through all 14 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 3 drills · ~70 min
SQL Data TypesMedium

Assesses understanding of SQL data types and their practical implications for data modeling and queries.

sqlJohns Hopkins University
SQL Joins and Window FunctionsMedium

Tests your SQL fundamentals and your ability to write advanced queries for analytics and reporting needs.

Window Functionscomplex queriesJohns Hopkins University
SQL Validation and ReconciliationMedium

Tests your ability to ensure data quality and reconcile discrepancies at scale using SQL and data checks.

Reconciliationdata validationJohns Hopkins University
Validating Outputs From EnhancementsMedium

Tests your end-to-end validation approach for new features, including test planning and verification of results.

processdata validationJohns Hopkins University
Enhancing Database PerformanceMedium

Tests your performance tuning skills, including diagnosing bottlenecks and improving query and data efficiency.

sqloptimizationJohns Hopkins University
Find Customers Exceeding Average Completed SpendingMedium
Practice
Practice drill

Use nested PostgreSQL queries to identify customers whose completed-order totals exceed the average customer total.

pandascomplex queriessqlDatabricks
SQL Joins and Coin SelectionHard
Practice
Practice drill

Use SQL joins to find unique combinations of three physical coins totaling exactly 100 cents.

Joinscomplex queriessqlMoody's
Experiment Design With Multiple FactorsMedium
Practice
Practice drill

Use PostgreSQL datetime calculations and window functions to validate DoorDash USA delivery reliability.

Window FunctionsLag/LeadDate FunctionsDoorDash USA
2
Behavioral & Leadership8 questions · ~64 min
Fixing a Critical Process BottleneckMedium

Tests ownership and prioritization in process improvement, with emphasis on root-cause diagnosis, execution, and measurable operational impact.

process improvementLeadershipProblem SolvingJohns Hopkins University
Simplifying a Complex Technical TopicMedium

Tests whether you can translate technical complexity into clear, audience-appropriate documentation that drives understanding and action.

Influence Without AuthorityCommunicationOwnershipJohns Hopkins University
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 14 questions plus 3 hands-on drills to finish this plan.