JPMorgan Business Analyst Interview Questions
JPMorgan's business analyst interviews run a recruiter screen, a technical round on SQL/Excel and requirements-gathering, a case study, and a behavioral round on stakeholder communication.
What to Expect
| Round | Format | Focus | Difficulty |
|---|---|---|---|
| Recruiter screen | 20-30 min | Resume, motivation, logistics | Low |
| Technical interview | 30-45 min | SQL basics, Excel, requirements documentation | Medium |
| Case study | 45-60 min | Analyze a business problem, propose a data-backed recommendation | High |
| Behavioral round | 30-45 min | Stakeholder management, handling conflicting priorities | Medium |
Prep time: 1-2 weeks — refresh SQL joins/aggregations and Excel modeling, and prepare one detailed case example where you translated a business need into a technical requirement.
Sample Questions and How to Approach Them
- "How would you write a SQL query to find customers with no transactions in the last 90 days?" Talk through a LEFT JOIN with a date filter and a NULL check, even if you can't write perfect syntax on a whiteboard — the logic matters most.
- "Walk me through how you'd gather requirements for a new reporting dashboard from a non-technical stakeholder." Describe asking about their decision, not their desired chart type first — get to the underlying question before designing the solution.
- "Tell me about a time stakeholders disagreed on priorities. How did you resolve it?" Use a real example and land on how you got alignment, ideally with data.
- "Case: transaction volume is down 15% quarter over quarter. How do you investigate?" Structure the answer: segment by product, channel, and customer type to isolate where the decline concentrates before jumping to causes.
- "How do you validate that your analysis is correct before presenting it?" Mention cross-checking totals against a second source or a sanity-check calculation — banks weight this heavily given regulatory scrutiny.
- "Describe a time you had to say no to a stakeholder's request." Show you can push back professionally while offering an alternative that still meets their underlying need.
Related Reads
- JPMorgan Software Engineer Interview Questions
- JPMorgan Product Manager Interview Questions
- JPMorgan Data Scientist Interview Questions
- JPMorgan Financial Analyst Interview Questions
- Capital One Business Analyst Interview Questions
Practice the SQL and the Story
InterviewBoost's mock interview mode drills both the technical SQL logic and the stakeholder-conflict behavioral stories JPMorgan asks for, and live interview assist keeps your structure clean when a case question gets thrown at you live.