Interviews Analyzed
2,800
What business analysts are actually asked in interviews.
Based on analysis of 2,800 real Business Analyst interviews across tech, finance, and consulting companies.
Average Prep Time
12weeks
foundations
deep
system
polish
Offers Landed
72%
Among candidates following the plan
Avg Salary Bump
+$28k
Pre-offer vs post-offer base + equity
We pull jobs from sources most job seekers never check
01 — Companies
What top companies emphasize.
Interview focus varies significantly by company type. Tech companies prioritize data analysis, while financial firms emphasize risk assessment and regulatory knowledge.
FAANG
HighMeta · Google · Amazon · Apple · Netflix
100%
- Algorithms 20%
- System design 35%
- Behavioral 25%
- Domain / fit 20%
Heavy emphasis on data analysis, A/B testing, and product metrics. Expect technical case studies.
Product AnalyticsData Modeling
FINTECH
HighJPMorgan · Goldman Sachs · Stripe · Square · Robinhood
100%
- Algorithms 15%
- System design 30%
- Behavioral 30%
- Domain / fit 25%
Focus on risk analysis, compliance, and financial modeling. Strong business acumen required.
Risk AssessmentRegulatory Knowledge
EARLY-STAGE · SERIES A-B
MediumNotion · Figma · Airtable · Canva · Discord
100%
- Algorithms 10%
- System design 25%
- Behavioral 35%
- Domain / fit 30%
Generalist BA skills with emphasis on stakeholder management and rapid iteration.
Stakeholder ManagementAgile Methods
02 — Topics
Most frequently tested topics
67% of interviews containing topic
01
SQL & Database Queries
85%joins, aggregations, subqueries, window functions, data cleaning
Complex queries, data manipulation, and performance optimization
02
Requirements Gathering
78%stakeholder interviews, user stories, acceptance criteria, documentation
Eliciting, analyzing, and documenting business requirements
03
Data Analysis & Visualization
72%Excel, Tableau, Power BI, statistical analysis, dashboards
Creating insights from data and presenting findings to stakeholders
04
Process Improvement
65%workflow optimization, process mapping, efficiency metrics, automation
Identifying bottlenecks and designing improved business processes
05
Business Case Development
58%ROI analysis, cost-benefit, financial modeling, risk assessment
Building compelling business cases for proposed solutions
06
Stakeholder Management
52%communication, conflict resolution, project coordination, change management
Managing relationships and expectations across different business units
03 — Interview loop
The Business Analyst interview process
Case study rounds are typically the biggest bottleneck, where candidates must demonstrate end-to-end analytical thinking under time pressure.
Pass-rate funnel
Phone Screen · 78%
Technical Assessment · 65%
Case Study · 42%
Systems & Process · 58%
Behavioral · 72%
Final Round · 85%
Offer rate compounded ≈ 2.3%
01
Phone Screen
30 min · pass 78%
Basic BA concepts, SQL fundamentals, and role motivation
02
Technical Assessment
60 min · pass 65%
SQL queries, data analysis, and Excel/visualization tools
03
Case Study
BOTTLENECK90 min · pass 42%
End-to-end business problem solving with stakeholder presentation
04
Systems & Process
60 min · pass 58%
Requirements gathering, process design, and system specifications
05
Behavioral
45 min · pass 72%
Leadership scenarios, stakeholder management, and cultural fit
06
Final Round
30 min · pass 85%
Senior leadership discussion and role expectations
04 — Question bank
Real questions you'll encounter.
Curated from actual Business Analyst interviews at top companies.
SQL & DATA
Medium → HardCustomer retention analysis
- monthly cohort analysis
- churn rate calculation
- revenue impact modeling
- user segmentation
REQUIREMENTS GATHERING
MediumStakeholder interview design
- user story creation
- acceptance criteria
- requirement prioritization
- scope definition
PROCESS IMPROVEMENT
Medium → HardWorkflow optimization
- process mapping
- bottleneck identification
- automation opportunities
- efficiency metrics
BUSINESS CASE
HardROI justification
- cost-benefit analysis
- risk assessment
- financial modeling
- implementation timeline
DATA VISUALIZATION
MediumExecutive dashboard design
- KPI selection
- chart optimization
- stakeholder presentation
- data storytelling
SYSTEM DESIGN
Medium → HardData pipeline architecture
- data flow mapping
- integration requirements
- quality controls
- reporting structure
850 questions in the bank
Open the full bank →05 — Prep roadmap
12-week preparation roadmap
A structured approach to mastering Business Analyst interviews, from SQL fundamentals to advanced case study techniques.
Hours / week
Total: 78 hrs
W1
W2
W3
W4
W5
W6
W7
W8
W9
W10
W11
W12
Weeks 1-3
5 hrs/wk
Foundation Building
Master SQL fundamentals, Excel advanced functions, and basic data analysis techniques. Build strong technical foundation.
SQL BasicsExcel MasteryData Fundamentals
Weeks 4-7
7 hrs/wk
Core BA Skills
Learn requirements gathering, process mapping, and stakeholder management. Practice structured problem-solving approaches.
Requirements EngineeringProcess DesignStakeholder Management
Weeks 8-10
8 hrs/wk
Advanced Analysis
Tackle complex case studies, financial modeling, and business case development. Focus on end-to-end analytical thinking.
Case StudiesFinancial ModelingBusiness Cases
Weeks 11-12
7 hrs/wk
Interview Polish
Mock interviews, presentation skills, and company-specific preparation. Refine communication and delivery.
Mock InterviewsPresentation SkillsCompany Research
06 — Tools & resources
Tools & resources that work.
Battle-tested by candidates who landed offers.
Mix of free + premium.
InterviewPal
Guided interview prep with mentorship and structured paths.
Best for: Structured prep
Visit InterviewPal
LeetCode
2,000+ coding problems. Premium unlocks company-tagged sets.
Best for: Algorithms & DS
Visit LeetCode
System Design Primer
Free comprehensive guide. The de-facto starting point.
Best for: SD fundamentals
Visit System Design Primer
Blind
Anonymous tech community. Real interview experiences and insights.
Best for: Real signal
Visit Blind
Levels.fyi
Salary and interview data, by company and level.
Best for: Company intel
Visit Levels.fyi
Pramp
Peer mock interviews. Live practice with real people.
Best for: Live practice
Visit PrampFrequently Asked Questions
Don’t get beat to tomorrow’s openings
New roles go live every minute and the earliest applicants win. Get the freshest, verified listings delivered straight to your inbox before most job seekers ever see them.
👉 Get free daily job posts