Top 18
Prep plan
Updated weekly · Last refresh Aug 30

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 weekly.

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

Tests your baseline knowledge of SQL data types and how they affect storage and query behavior.

sqlJohns 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
Enhancing Database PerformanceMedium

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

sqloptimizationJohns 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
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
Running 30-Day Active Users SQLMedium
Practice
Practice drill

Calculate rolling 30-day distinct OnStar users using a deduplication window function and date-range aggregation.

Window FunctionssqlGeneral Motors (GM)
Average Citation Count by TimeMedium
Practice
Practice drill

Calculate each paper's citation count and the average across Elsevier-indexed papers in a date range using a window function.

Window FunctionssqlElsevier
Merchant Volume TrendsMedium
Practice
Practice drill

Use a CTE and window functions to calculate daily, cumulative, and three-day moving transaction volumes by Mastercard MCC.

Window FunctionssqlRunning TotalsMastercard
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership10 questions · ~80 min
Aligning Competing Stakeholder PrioritiesMedium

Tests stakeholder management under pressure, especially prioritization, influence without authority, and clear communication.

Stakeholder ManagementCommunicationDealing With AmbiguityJohns Hopkins University
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Tell Me About YourselfEasy

Tests your ability to deliver a clear, relevant introduction tailored to the role at Aqr.

Competitive AnalysisGo-to-MarketJohns Hopkins University
Handling Architecture ConflictsHard

Tests your ability to balance stakeholder needs with technical constraints and drive workable solutions.

Trade-offssystem architectureJohns Hopkins University

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 18 questions plus 3 hands-on drills to finish this plan.