Top 16
Prep plan
Updated weekly · Last refresh Sep 9

J.P. Morgan Data Analyst Interview Questions

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

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

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

JoinsJ.P. Morgan
Optimizing Slow Python on TransactionsHard

Tests performance optimization skills for Python workflows on large transaction data.

pythonoptimizationJ.P. Morgan
FizzBuzz SQL AssessmentEasy

Tests basic coding logic and ability to implement a simple transformation.

CodingBasic AlgorithmsJ.P. Morgan
Python for Data CleaningMedium

Tests practical tooling choices for preparing reliable datasets for analysis.

data cleaningData ManipulationJ.P. Morgan
Handling Missing or Inconsistent DataMedium

Tests data preparation practices to ensure analysis quality and reliability.

Data Qualitydata preparationJ.P. Morgan
Optimizing Slow SQL on Large DataMedium

Tests SQL performance tuning skills and practical troubleshooting on large datasets.

large datasetsJ.P. Morgan
SQL Joins and Conditional AggregationsHard
Practice
Practice drill

Use multiple joins and conditional aggregation to summarize completed, positive, and total outreach activity by Catalist campaign.

Joinssql queryAggregationsCatalistJ.P. Morgan
SQL and Python Data WorkMedium
Practice
Practice drill

Use a CTE, join, and conditional aggregation to summarize valid monthly user activity.

JoinsData ManipulationsqlAdobe
SQL for User BehaviorMedium
Practice
Practice drill

Measure qualifying Paramount+ users by completed watch minutes, title diversity, and engagement level.

SQL & Data ManipulationJoinsData ManipulationParamount

Sign up to see every question

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

Get my prep plan
2
Behavioral & Leadership10 questions · ~80 min
How School Shaped Your CareerMedium

Assesses motivation and the factors that shaped your path into data analysis.

J.P. Morgan
Clarifying Vague HR QuestionsEasy

Assesses requirement clarification and communication when inputs are ambiguous.

J.P. Morgan
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 16 questions plus 3 hands-on drills to finish this plan.