INTERVIEW GUIDE

Capital One Data Analyst Interview: Questions & Process

Capital One is famous for the business case interview, and it dominates their analyst loop — you'll work through a structured business problem with math you do live, not just SQL trivia. Expect a recruiter screen, a phone case, and a 'Power Day' of back-to-back rounds mixing two cases, a technical/SQL portion, and behavioral. Strong, structured quantitative reasoning out loud is the whole game.

The interview process

1. Recruiter screen — ~30 min call

Tests: background, quantitative comfort, why Capital One, and how the case interview works

2. Phone case interview — 45-60 min

Tests: a structured business problem solved live — framework, assumptions, and arithmetic you do out loud

3. Power Day: business cases — 2 x 45-60 min

Tests: deeper cases — profitability, market entry, or pricing — with quantitative analysis and a recommendation

4. Technical / analytics round — 45-60 min

Tests: SQL, Excel logic, interpreting data, and basic statistics applied to a business question

5. Behavioral round — 45 min

Tests: ownership, working with ambiguity, communicating analysis, and why Capital One

Questions you're likely to get

Technical

Write a SQL query to find customers whose spend grew more than 20% quarter over quarter.
Given a transactions table, calculate the monthly churn rate.
How would you test whether a change in approval criteria affected default rates?
Explain how you'd detect whether a metric drop is signal or noise.

Role-specific

A credit card product's profit is falling. Walk me through how you'd diagnose why.
Should Capital One launch a new cash-back card? Build the case for and against.
Estimate the annual revenue from a coffee shop near campus.
A marketing campaign costs $2M and adds 50,000 customers. How do you decide if it was worth it?
How would you set the interest rate on a new line of credit to balance growth and risk?

Behavioral

Tell me about a time you used data to drive a business decision.
Describe a time you had to explain a complex analysis to a non-technical audience.
Tell me about a time you were given an ambiguous problem with little direction.
Why Capital One, and why an analyst role here?

How to answer (worked examples)

A credit card product's profit is falling.

Open with a structure before any numbers: profit = revenue minus cost, so break revenue into customers x spend x take-rate and costs into acquisition, servicing, and losses. State which branch you'd investigate first and why, ask for the data you'd need, and do the arithmetic out loud. Capital One scores the structure and your mental math heavily — narrate every assumption and sanity-check your numbers.

Estimate the annual revenue from a coffee shop near campus.

Pick a clear path: customers per hour x open hours x average ticket x days. State each assumption, keep the numbers round, and compute step by step. End by sanity-checking the total against reality. The answer doesn't need to be right — they're grading whether your logic is structured and your arithmetic is clean under pressure.

Tell me about a time you used data to drive a business decision.

STAR with quantified results. Situation: the decision and stakes. Task: your role. Action: the analysis, the metric, and how you framed it for decision-makers. Result: the decision made and its measurable impact. Capital One wants analysts who connect data to dollars, so make the business outcome explicit.

What Capital One looks for

Structured problem-solving — you frame a case before diving into numbers
Strong, accurate mental math done out loud without a calculator
Business judgment: you connect analysis to revenue, cost, and risk
Clear communication of quantitative reasoning to a non-technical listener
Solid SQL and comfort interpreting data for a decision
Red flag: jumping to calculations with no framework, or arithmetic mistakes you don't catch

FAQ

Is the Capital One interview really all case interviews?

Cases are the defining feature and the biggest filter. You'll also have a technical/SQL portion and behavioral, but the business case — solved live with mental math — is what most candidates underprepare for and where offers are won or lost.

How much mental math do I need?

A lot, and out loud. You'll estimate, multiply, and compute percentages without a calculator while explaining your logic. Practice doing case arithmetic verbally until it's smooth — fumbling the math reads as a red flag.

What is the Power Day?

Capital One's onsite (often virtual): several back-to-back rounds in one day, typically two cases plus technical and behavioral. It's intense, so pace your energy and treat each round as a fresh start.

How technical is the SQL?

Intermediate — joins, aggregations, window functions, and interpreting results. It's meaningful but secondary to the case performance for analyst roles.

How long is the process?

Typically 3-5 weeks from recruiter screen to decision, with the Power Day as the final stage.

The case interview is won out loud

Capital One's case is live mental math under a watchful interviewer — the kind of thing you can't fake by reading frameworks. Practice solving cases out loud, narrating your structure and arithmetic, with OfferLoop's realtime voice coach before your Power Day.

Practice this interview out loud →

All Capital One interviews →Capital One Software Engineer interview →Capital One Data Scientist interview →Capital One Data Engineer interview →Capital One Machine Learning Engineer interview →

OfferLoop is an independent interview-practice tool and is not affiliated with, endorsed by, or sponsored by Capital One. All company names and trademarks are the property of their respective owners.

Interview formats vary by team, level and year, and this guide is compiled from general knowledge of publicly discussed hiring processes — treat it as preparation material, not an official description of Capital One's current process.