Skip to content

Stripe Business Analytics Interview Questions & Answers

Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.

About Stripe hiring for Business Analytics roles

Stripe is a financial infrastructure company providing online payments, billing, connect platforms, fraud prevention through Radar, and other APIs for businesses. It has an engineering presence in Bengaluru along with business teams serving Indian merchants. It hires in India for software engineers, data and analytics roles, and integration-focused technical positions.

For Business Analytics roles, this Stripe practice set focuses most on Requirements and Agile (7), Case Studies and Guesstimates (5), Stakeholder Communication (4), Business Metrics and KPIs (4). It has 4 easy, 30 medium, 6 hard questions, so you can start easy and work up to the harder ones.

Company type
Fintech
Headquarters
South San Francisco, California, USA
Main India offices
Bengaluru

Stripe Business Analytics interview process

  1. Recruiter screening
  2. Technical phone screen (practical coding)
  3. Onsite coding and bug squash rounds
  4. Integration or design round
  5. Behavioural round

Typical pattern based on public candidate experiences. Rounds vary by role, team and year.

Solved for StripeStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

What is a RACI matrix?

Save to ▾
Show answer
A table assigning Responsible, Accountable, Consulted and Informed roles per task so ownership is clear.
02

An order has a value of 600 rupees, product cost 360, delivery 60, payment fee 12 and a discount of 50. What is the contribution margin?

Save to ▾
Show answer
Net revenue after discount is 600 minus 50, which is 550 rupees. Variable costs are 360 plus 60 plus 12, totalling 432. Contribution margin is 550 minus 432, so 118 rupees per order, or about 21 percent of net revenue. This is what each order contributes towards fixed costs such as salaries and rent. If the discount were raised to 150, the order would contribute only 18 rupees.
03

A hospital chain's average patient waiting time has risen from 30 to 50 minutes. How would you approach the case?

Save to ▾
Show answer
Clarify where the wait is measured: registration, consultation, diagnostics or billing. Split the problem into demand and capacity. On demand, check patient volume, peak-hour mix, walk-ins versus appointments and new departments. On capacity, check doctor availability, no-shows of staff, consultation time per patient and process bottlenecks such as manual billing. Identify the biggest stage and suggest fixes like slot-based appointments, triage and digital billing.
04

A manager says the dashboard total does not match the finance team's Excel sheet. What do you do?

Save to ▾
Show answer
First agree on the definition: date range, gross or net, tax, returns, currency and which date (order or invoice) is used. Then reconcile at a small grain, such as one month and one region, comparing row counts and sums between the source query and the sheet. Common causes are filters on the page, missing relationships, duplicate rows after a join or a late refresh. Document the agreed definition in the report tooltip.
05

What is an index in a database and when can it hurt performance?

Save to ▾
Show answer
An index is a sorted lookup structure on one or more columns that lets the database find rows without scanning the whole table, much like a book index. It speeds up WHERE filters, joins and ORDER BY on those columns. It hurts when there are too many indexes, because every insert and update must maintain them, and it may not help on low-selectivity columns or when functions are applied to the indexed column.
06

How do you calculate cycle time, touch time and process efficiency? Give an example.

Save to ▾
Show answer
Cycle time (lead time) is the total elapsed time from the start to the end of a case. Touch time is the time someone actually works on it. Process cycle efficiency is touch time divided by cycle time. Example: a refund takes 5 working days (40 working hours) end to end, but the agents spend only 2 hours in total working on it. Efficiency is 2 / 40 = 5 percent, so 95 percent of the time is waiting, and queues are the main target.
07

Your AS-IS map of a loan approval process shows 14 handoffs between teams. How do you identify improvements?

Save to ▾
Show answer
First measure each handoff: waiting time, rework rate and volume, using system timestamps where possible. Then classify steps as value-adding, required for compliance or waste. Look for patterns: repeated approvals, information re-entered in two systems, work bouncing back for missing documents. Typical fixes are merging roles, adding a checklist at intake so applications arrive complete, parallelising checks and automating rule-based approvals. Quantify the expected reduction in cycle time for each option.
08

How do you run an effective stakeholder meeting?

Save to ▾
Show answer
Send an agenda with the goal and the decisions needed beforehand, along with any pre-read. Invite only people who contribute or decide. Start by restating the goal, keep to time, park off-topic issues and confirm decisions aloud. End by summarising actions with owners and dates. Send minutes within a day. A meeting without a clear decision or output usually could have been an email.
09

What is the 80/20 rule in business analysis?

Save to ▾
Show answer
Pareto principle: about 80% of outcomes come from 20% of causes, such as most revenue from a few customers or most defects from a few issues.
10

Write a SQL query to show cumulative revenue by month.

Save to ▾
Show answer
WITH monthly AS ( SELECT DATE_TRUNC('month', order_date) AS month, SUM(amount) AS revenue FROM orders GROUP BY 1 ) SELECT month, revenue, SUM(revenue) OVER (ORDER BY month) AS cumulative_revenue FROM monthly ORDER BY month; -- add PARTITION BY EXTRACT(YEAR FROM month) to reset each year
11

What is AS-IS and TO-BE process modelling, and where does BPMN fit in?

Save to ▾
Show answer
AS-IS modelling documents how a process works today, including pain points, delays and handoffs. TO-BE modelling shows the improved future process after changes or a new system. Comparing the two reveals the gaps and requirements. BPMN, Business Process Model and Notation, is the standard notation, using events, tasks, gateways for decisions and swimlanes for roles, so both business and IT read the diagrams the same way.
12

Tell me about an experiment that failed and what you learned.

Save to ▾
Show answer
Situation: we tested a simplified pricing page expecting higher paid conversion. Task: I owned the experiment design and analysis. Action: after two weeks the variant showed no significant change, and segment checks revealed that heavy users missed the plan comparison table. I documented the result and shared it openly rather than searching for a winning segment. Result: the next version kept the simple layout with an optional comparison, and we learned to interview users before testing.
13

The sales team keeps hitting its revenue target, but company margins are falling. What would you recommend?

Save to ▾
Show answer
The incentive rewards revenue regardless of profitability, so reps are likely discounting heavily or pushing low-margin products. Analyse deal-level discount, product mix and margin by rep and region to confirm. Then recommend changing the target to gross margin or contribution, or adding discount approval limits and a margin floor to commission. Pilot the new plan with one region and track revenue, margin and win rate together.
14

What checklist do you apply to a BPMN diagram before sharing it with stakeholders?

Save to ▾
Show answer
Every diagram has clear start and end events and a title with version and owner. Activities use verb-noun names such as Approve invoice. Each gateway is labelled with a question and its outgoing flows with answers. Splits and joins use matching gateway types. Message flows only connect separate pools. No dangling or crossing arrows where avoidable. The happy path reads left to right. Exceptions are handled, and complex rules are referenced to decision tables rather than drawn as gateways.
15

What are acceptance criteria?

Save to ▾
Show answer
Clear, testable conditions a story must meet to be accepted, often written as Given-When-Then scenarios.
16

Write a SQL query to find the second-highest salary in an employees table.

Save to ▾
Show answer
SELECT MAX(salary) AS second_highest FROM employees WHERE salary < (SELECT MAX(salary) FROM employees); -- or with a window function SELECT DISTINCT salary FROM ( SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rk FROM employees ) t WHERE rk = 2;
17

A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?

Save to ▾
Show answer
Profit is an accrual figure, while cash depends on timing. Check working capital first: receivables may be growing because customers pay late, inventory may be piling up, or suppliers may be demanding faster payment. Then look at large capex, loan repayments, and dividends. Review the cash flow statement and compute days sales outstanding and inventory days over time. Fixes include tighter credit terms, collection drives, inventory reduction and renegotiating supplier terms.
18

Explain exclusive, parallel and inclusive gateways in BPMN.

Save to ▾
Show answer
An exclusive gateway (diamond with X) sends the flow down exactly one path based on a condition, for example approved or rejected. A parallel gateway (diamond with +) splits into all paths at once and, when joining, waits for every path to finish. An inclusive gateway (diamond with O) activates one or more paths whose conditions are true and joins only those that were activated. Choosing the wrong one causes deadlocks or duplicated work in automated processes.
19

Your project is going to miss its deadline by two weeks. How do you communicate this?

Save to ▾
Show answer
Tell the sponsor and key stakeholders as soon as you are confident, not on the deadline. Be direct about the delay, the cause and the impact. Come with options, such as reducing scope to hit the date, adding resources, or moving the date with a phased release, plus your recommendation. Agree on the new plan, update the communication plan and track the recovery visibly.
20

Write Given-When-Then acceptance criteria for applying a discount coupon at checkout.

Save to ▾
Show answer
Given a cart of 1,200 rupees and a valid coupon SAVE10 with a minimum order of 1,000 rupees, when the user applies it, then 10 percent is deducted and the new total is shown. Given an expired coupon, when applied, then the message 'This coupon has expired' appears and the total is unchanged. Given a cart below the minimum, when applied, then the user is told how much more to add.
21

What is the time value of money?

Save to ▾
Show answer
The time value of money means a rupee today is worth more than a rupee in the future, because today's rupee can be invested to earn a return and future money carries inflation and risk. Future cash is converted to present value using PV = FV / (1 + r)^n. At a 10 percent discount rate, 1,10,000 rupees received after one year is worth 1,00,000 rupees today. It is the basis of NPV, IRR, loan EMIs and valuation.
22

How do you chart a trend with a target line?

Save to ▾
Show answer
Create a line or column chart of actuals and add the target as another series formatted as a line.
23

Vendor A has a lower licence price, but Vendor B has lower running costs. How do you compare them?

Save to ▾
Show answer
Compare total cost of ownership over the same period, usually 3 to 5 years. Include licence or subscription fees, implementation, data migration, integration, training, internal staff time, infrastructure, support and upgrade costs, and exit costs. Discount the yearly totals to present value if the timing differs. Then weigh the result against non-cost factors such as fit to requirements, scalability and vendor stability. Often the cheaper licence ends up costlier once customisation and support are added.
24

Why do Agile teams estimate in story points rather than hours?

Save to ▾
Show answer
Story points measure relative effort, complexity and uncertainty compared with a reference story, using a scale like 1, 2, 3, 5, 8. People are better at comparing sizes than predicting exact hours, and points do not depend on who does the work. Over a few sprints the team's velocity, points completed per sprint, makes forecasting reliable. Points should never be used to compare productivity across teams.
25

Finance and sales blame each other for wrong numbers in a monthly report. How do you resolve it as the analyst?

Save to ▾
Show answer
Stay neutral and move the discussion from blame to facts. Trace the number end to end: source system, extraction, transformation and report logic, and find exactly where the values diverge. Share the findings with both teams together, agree on the fix and on a single owner for the definition. Then add automated reconciliation checks and a data dictionary, so the process, not people, prevents the next issue.
26

UAT starts tomorrow, but the business has not nominated any testers. What do you do?

Save to ▾
Show answer
Escalate immediately to the business sponsor with the impact: each day without testers delays sign-off and go-live. Ask for named testers with protected time, even part-time. Meanwhile, prepare so no time is lost: finalise test cases, check the environment and data, and plan a short tester briefing. If testers cannot be released, propose re-planning UAT dates rather than letting IT or the BA test on the business's behalf, because acceptance must come from the users.
27

Monthly subscription churn jumped from 3 percent to 5 percent. How do you investigate?

Save to ▾
Show answer
Confirm the data first: definition changes, failed-payment handling or a billing date shift. Then segment churn by plan, tenure, acquisition channel, city and device to find where it concentrates. Separate voluntary cancellations from involuntary card failures. Look at events before the jump, like a price change, app release or competitor offer, and read cancellation reasons. Recommend targeted fixes, such as payment retries or win-back offers, and track the affected cohort.
28

How would you size the market for IT courses in Delhi NCR?

Save to ▾
Show answer
Top-down: NCR population aged 18–30 × share of graduates × share wanting paid upskilling × average fee. Cross-check bottom-up with institutes × batches × students × fees. State your assumptions.
29

What steps would you follow to create an AS-IS process map for a customer refund process?

Save to ▾
Show answer
Define the scope: where the process starts, such as a refund request, and where it ends, such as money credited. Identify the roles involved and draw swimlanes. Interview and observe each role, capturing steps, decisions, systems used, handoffs and time taken. Draw the flow in BPMN, mark pain points like rework loops and waiting time, and add measures such as average refund time. Validate the map with the people who do the work.
30

What are LOD expressions in Tableau and how do FIXED, INCLUDE and EXCLUDE differ?

Save to ▾
Show answer
Level of Detail expressions compute an aggregate at a granularity different from the view. FIXED computes at the stated dimensions regardless of the view, for example { FIXED [Customer ID] : MIN([Order Date]) } for first purchase date. INCLUDE adds a dimension to the view level, useful for average sales per customer by region. EXCLUDE removes a dimension, useful for comparing each month with the yearly total. FIXED ignores normal dimension filters unless they are context filters.
31

Write a SQL query to get each customer's first order date and first order amount.

Save to ▾
Show answer
WITH ordered AS ( SELECT customer_id, order_date, amount, ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY order_date, order_id) AS rn FROM orders ) SELECT customer_id, order_date AS first_order_date, amount AS first_order_amount FROM ordered WHERE rn = 1;
32

How do you handle changing requirements?

Save to ▾
Show answer
Log the change, assess impact on scope, cost and timeline, get approval through change control or backlog grooming, and update documents and stakeholders.
33

What is an event tracking plan and why does it matter?

Save to ▾
Show answer
A tracking plan is a document listing every event the product should log, such as 'checkout_started', with its trigger, properties like price, plan or source, naming rules and owner. It keeps data consistent across web, Android and iOS, prevents duplicate or vague events and makes analysis trustworthy. Without one, teams end up with events like 'click1' and 'buttonClick' meaning the same thing, and analysis becomes guesswork.
34

Explain Porter's Five Forces.

Save to ▾
Show answer
A model assessing industry attractiveness through supplier power, buyer power, threat of new entrants, threat of substitutes and rivalry among competitors.
35

Write an Excel formula for the weighted average selling price across orders.

Save to ▾
Show answer
// B2:B200 = price per unit, C2:C200 = units sold =SUMPRODUCT(B2:B200, C2:C200) / SUM(C2:C200) // a simple AVERAGE(B2:B200) would wrongly give a small order // the same weight as a large one
36

Revenue grew 20 percent this quarter but the number of active customers stayed flat. How do you interpret it?

Save to ▾
Show answer
Growth came from more value per customer, not more customers. Break revenue into customers times orders per customer times average order value to see which moved. It could be price increases, larger baskets, a shift to premium products or a few large accounts. Then check risks: is new customer acquisition stalling, is churn being masked, and is growth concentrated in a small segment that could leave?
37

What are UAT entry and exit criteria? Give examples.

Save to ▾
Show answer
Entry criteria are conditions that must be met before UAT starts, for example system and integration testing completed, no open critical defects, UAT environment and test data ready, test cases reviewed and testers trained. Exit criteria define when UAT is complete, for example 100 percent of critical test cases executed, at least 95 percent passed, no open critical or high defects, and workarounds agreed for remaining medium ones. Clear criteria stop arguments about readiness near go-live.
38

A release passed all system testing, but business users reject it during UAT. What went wrong and what do you do?

Save to ▾
Show answer
The team built what was written, but not what users needed, which points to gaps in elicitation, missing real-world scenarios or users not involved early. Capture each rejection and classify it as a defect, a missed requirement or a new request. Prioritise blockers with the product owner and agree on a fix plan and date. Going forward, involve users in demos every sprint and base UAT scenarios on real workflows.
39

What is a market entry strategy case?

Save to ▾
Show answer
Decide whether and how to enter a market by evaluating attractiveness, competition, capabilities and entry mode (build, buy, partner), then risks and next steps.
40

What is the use of the IFERROR function?

Save to ▾
Show answer
It returns a custom value when a formula errors out, keeping reports clean, for example =IFERROR(VLOOKUP(...), "Not found").

Tips to crack the Stripe Business Analytics interview

  • Practise practical coding tasks like parsing data, calling APIs and fixing bugs in existing code, rather than only puzzle-style DSA.
  • Read Stripe's API documentation and try a test-mode integration to understand payment intents and webhooks.
  • Prepare examples of clear written communication, such as design docs or detailed reports, which Stripe culture strongly values.
  • Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
  • Practise the hard questions on this page aloud; Stripe interviewers usually ask follow-ups on your first answer.

Frequently asked questions

How many rounds are there in the Stripe Business Analytics interview?

Candidates usually go through 5 stages: Recruiter screening; Technical phone screen (practical coding); Onsite coding and bug squash rounds; Integration or design round; Behavioural round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.

Which topics should I prepare for the Stripe Business Analytics interview?

This practice set leans on Requirements and Agile (7), Case Studies and Guesstimates (5), Stakeholder Communication (4), Business Metrics and KPIs (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Stripe interviewers ask you to walk through real work.

Are these the exact questions asked at Stripe?

No. These are curated practice questions that match the skills and difficulty usually tested in fintech interviews like Stripe's. They are not a leaked or verified list of past questions.

Where does Stripe hire Business Analytics professionals in India?

Stripe has large teams in Bengaluru. Openings and locations change often, so check the Stripe careers page and filter by city and experience.

Business Analytics questions for similar companies