Skip to content

Tower Research Capital Business Analytics Interview Questions & Answers

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

About Tower Research Capital hiring for Business Analytics roles

Tower Research Capital is a quantitative trading firm that develops automated, high-frequency trading strategies across global markets. Its Gurugram office works on trading systems, low-latency software, infrastructure and quantitative research. It hires in India for software engineers, quantitative researchers and traders, with interviews that focus heavily on problem solving, probability and systems.

For Business Analytics roles, this Tower Research Capital practice set focuses most on Case Studies and Guesstimates (7), Requirements and Agile (6), SQL for Business Analysis (5), Process Modelling and BPMN (5). It has 1 easy, 30 medium, 9 hard questions, so you can start easy and work up to the harder ones.

Company type
Fintech
Headquarters
New York, USA
Main India offices
Gurugram

Tower Research Capital Business Analytics interview process

  1. Online assessment (coding + quant)
  2. Technical round 1 (DSA)
  3. Technical round 2 (C++ or systems)
  4. Quant or probability round
  5. HR round

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

Solved for Tower Research CapitalStart 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

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
02

What is the difference between OLTP and OLAP systems?

Save to ▾
Show answer
OLTP handles many small day-to-day transactions; OLAP supports analysis over large historical data with aggregates and reporting.
03

How do you write a query to find users active in consecutive months?

Save to ▾
Show answer
Get distinct user-month pairs, self-join or use LAG on month per user, and keep rows where the previous month is exactly one month earlier.
04

How do you estimate the annual revenue of a coffee shop chain?

Save to ▾
Show answer
Number of outlets x daily customers x average bill x operating days, then validate using footfall, peak hours and similar chains.
05

Three departments describe the same order process in three different ways during workshops. How do you arrive at the true AS-IS?

Save to ▾
Show answer
Treat each version as a hypothesis. Walk the process physically or observe real cases end to end, and pull a sample of 20 to 30 recent orders from the system to trace what actually happened. Compare timestamps and status changes with each department's story. Then hold a joint session, show the evidence-based map and mark the variants openly. Often all three are partly right because different order types follow different paths, which should be modelled explicitly.
06

What techniques do you use to elicit requirements?

Save to ▾
Show answer
Interviews, workshops, surveys, observation, document analysis, prototyping and brainstorming, chosen according to stakeholders and project stage.
07

An online learning platform finds that only 12 percent of learners complete paid courses. How do you analyse it?

Save to ▾
Show answer
Define completion and see where learners drop: first week, a specific module or before assessments. Segment by course, length, learner background, device and acquisition channel. Look at causes in content difficulty, video length, lack of deadlines, mentor support and job relevance. Recommend tests such as shorter modules, cohort-based deadlines, progress nudges and live doubt sessions, and measure completion and referral impact.
08

Stakeholders give conflicting requirements. What do you do?

Save to ▾
Show answer
Clarify the goal behind each request, map them to business objectives, prioritise with MoSCoW, run a joint session, then document the decision and get sign-off.
09

A bank's mobile app logins increased, but digital transactions fell. What could explain this?

Save to ▾
Show answer
Users are coming but not completing transactions, so look at the gap. Possible causes: a release that broke a payment flow, new security steps like extra OTPs adding friction, logins driven by balance checks or offers, or transactions shifting to another channel. Compare the funnel from login to transaction by app version and device, check failure and error rates, and review support complaints before recommending fixes.
10

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.
11

A Tableau dashboard on a 50 million row data source responds slowly to filters. How do you fix it?

Save to ▾
Show answer
Use an extract with only the needed columns and rows, aggregated to the visible grain where possible. Replace quick filters showing all values with fewer filters, use context filters wisely and avoid 'only relevant values' on large fields. Move complex calculations into the data source, reduce marks per view and the number of sheets per dashboard. Use the Performance Recorder to find the slowest queries and fix those first.
12

Write a SQL query for a 7-day rolling average of daily revenue.

Save to ▾
Show answer
WITH daily AS ( SELECT order_date, SUM(amount) AS revenue FROM orders GROUP BY order_date ) SELECT order_date, revenue, AVG(revenue) OVER (ORDER BY order_date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS rolling_7d FROM daily ORDER BY order_date; -- fill missing dates from a calendar table first, or gaps skew the average
13

A product line shows a loss after allocated overheads. Leadership wants to shut it down. How do you advise?

Save to ▾
Show answer
Separate contribution from allocation. If the product's revenue exceeds its variable and directly attributable fixed costs, it contributes to covering shared overheads, which will not disappear if it is closed and will be reallocated to other products. Check whether the overhead allocation key, such as revenue share, is fair. Also consider strategic links, like customers who buy it alongside profitable products. Recommend shutting it only if contribution is negative or the freed capacity has a better use.
14

Marketing and product teams define 'active user' differently and report conflicting numbers. How do you fix this?

Save to ▾
Show answer
Bring both teams together and list each definition, its purpose and its numbers. Agree on one company-wide definition tied to real value, such as a user who completed a core action in the last 7 days, and allow clearly named secondary metrics like 'visitors' for marketing. Assign an owner, document it in a metric glossary, implement it once in the warehouse or semantic model, and retire the duplicate dashboards.
15

Guesstimate: how many weddings take place in India in a year?

Save to ▾
Show answer
Assume a population of about 144 crore and an average life expectancy of about 70 years, so roughly 2 crore people reach a typical marriage age each year. If about 95 percent of them marry at some point, that is around 1.9 crore people, or about 95 lakh weddings, since each wedding involves two people. A reasonable estimate is around 1 crore weddings per year, concentrated in the winter wedding season.
16

A feature was launched to all users at once without an A/B test. How would you measure its impact?

Save to ▾
Show answer
Use quasi-experimental methods. Compare before and after with enough history to account for trend and seasonality. If it rolled out at different times in regions or platforms, use difference-in-differences between early and late groups. Compare users who adopted with similar non-adopters using matching, while being careful about self-selection. For future launches, recommend keeping a small holdout group so impact can be measured cleanly.
17

A food delivery company's orders fell 15%. How do you investigate?

Save to ▾
Show answer
Check data accuracy, then segment by city, restaurant, time and user type; look at supply, delivery time, pricing, competitors and seasonality before proposing fixes.
18

A quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?

Save to ▾
Show answer
Demand: population density, smartphone and digital payment penetration, average basket size and how often people buy groceries. Supply: dark store rent, rider availability and local sourcing. Unit economics: orders per store per day needed to break even, given lower average order values. Competition: local kirana delivery and other apps. Then propose a pilot in two or three cities with clear success metrics such as orders per day, contribution margin per order and repeat rate before scaling.
19

How do you handle large datasets in Excel?

Save to ▾
Show answer
Use tables, Power Query, remove volatile functions, filter before calculating and move to Power Pivot or a database when rows reach the millions.
20

How would you estimate the market size for an electric scooter in India?

Save to ▾
Show answer
Top-down: two-wheeler market x EV share x addressable segment. Bottom-up: target households x adoption rate x price. Compare both for a sanity check.
21

What are process levels such as L0 to L4 in a process architecture?

Save to ▾
Show answer
Process levels organise models from broad to detailed. L0 shows the value chain or main process areas, such as Order to Cash. L1 and L2 break these into process groups and end-to-end processes, such as Credit Management. L3 shows the detailed BPMN flow with roles and decisions. L4 covers work instructions or system steps. A level structure keeps hundreds of diagrams consistent, avoids duplicates and lets executives and operators each read the right depth.
22

What is a change request and how does change control work?

Save to ▾
Show answer
A change request is a formal proposal to modify agreed scope, requirements, timeline or budget. In change control, the request is logged, the BA analyses impact on effort, cost, schedule, risk and other requirements, and a decision body such as the sponsor or change board approves, rejects or defers it. Approved changes update the requirements, plan and traceability. In Agile, most changes go through backlog reprioritisation instead.
23

How would you forecast next quarter's sales in Excel?

Save to ▾
Show answer
Use FORECAST.ETS or a trendline on monthly history, check seasonality, compare with a simple moving average and present a range, not a single number.
24

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.
25

Tell me about a time poor or outdated documentation caused a problem. How did you fix it?

Save to ▾
Show answer
Situation: a new developer built a GST calculation from an old FRD version, and the error was caught only in UAT. Task: fix the defect and prevent repeats. Action: I moved all requirement documents into one shared space with version history, added a change log and status labels such as draft or approved, and linked each user story to the latest approved section. Result: in the next two releases we had no defects caused by outdated specifications.
26

Your A/B test was meant to split traffic 50/50, but the actual split is 52/48 on 200,000 users. What do you do?

Save to ▾
Show answer
This is a sample ratio mismatch. With 200,000 users, a 52/48 split is far outside random chance, which a chi-square test will confirm. It means the assignment or logging is broken, for example the variant page crashing before the tracking event fires, bots filtered unevenly or a redirect losing users. Do not trust the results. Investigate by segment, platform and day to find the cause, fix it and rerun the test.
27

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.
28

Write a SQL query that shows revenue, cost and gross margin percent by product category.

Save to ▾
Show answer
SELECT p.category, SUM(oi.quantity * oi.unit_price) AS revenue, SUM(oi.quantity * p.unit_cost) AS cost, ROUND(100.0 * (SUM(oi.quantity * oi.unit_price) - SUM(oi.quantity * p.unit_cost)) / NULLIF(SUM(oi.quantity * oi.unit_price), 0), 2) AS gross_margin_pct FROM order_items oi JOIN products p ON p.product_id = oi.product_id GROUP BY p.category ORDER BY gross_margin_pct DESC;
29
Save to ▾
Show answer
An Excel add-in for building data models with relationships and DAX measures over millions of rows, beyond normal worksheet limits.
30

A report query on a 200 million row table takes 15 minutes. How do you optimise it?

Save to ▾
Show answer
Read the execution plan to find full scans and expensive joins. Filter early on partitioned or indexed columns such as date, select only needed columns instead of SELECT *, and avoid functions on filter columns. Pre-aggregate in a CTE before joining, replace correlated subqueries with joins or window functions, and check join keys have matching types. For repeated use, build a summary table or materialised view refreshed daily.
31

In the middle of a sprint, a senior stakeholder asks to add an urgent feature. What do you do?

Save to ▾
Show answer
Understand the urgency and the business impact of waiting until the next sprint. Bring it to the product owner, who decides. If it truly cannot wait, the team agrees to swap out work of similar size so the sprint goal stays realistic, and the trade-off is made visible to the stakeholder. If it can wait, add it to the top of the backlog for the next sprint. Avoid silently adding scope.
32

How do you write an effective executive summary for an analysis report?

Save to ▾
Show answer
Put it first and keep it to one page or five lines on a slide. Start with the answer or recommendation, then the two or three key findings that support it, each with a number, then the impact in rupees or percentage, and finally the decision or action needed and by when. Avoid methodology details, which go in the appendix. Test it by asking whether a busy leader could act after reading only this section.
33

During UAT, users log 60 defects, but you suspect many are actually new requirements. How do you handle it?

Save to ▾
Show answer
Run a joint triage with the business owner, QA and development. Compare each item against the signed-off requirements and acceptance criteria. Real defects stay in the defect log; items not covered by requirements are reclassified as change requests and prioritised separately through change control. Keep the tone neutral so users do not feel dismissed. Also review why the gap happened, for example prototypes were not shown early enough, and fix that for the next release.
34

What is Kano model in prioritisation?

Save to ▾
Show answer
A model classifying features as basic, performance or delight attributes based on how they affect customer satisfaction, helping decide what to build first.
35

How would you prioritise 10 features with a limited budget?

Save to ▾
Show answer
Score them with RICE or value-vs-effort, align with goals, consider dependencies and risks, validate with stakeholders, then use MoSCoW for the release plan.
36

What steps would you follow to run a process discovery workshop?

Save to ▾
Show answer
Before: agree scope and process boundaries, invite people who actually do the work, not only managers, and collect existing documents and sample cases. During: state the goal, map the happy path first on a wall or digital board, then add exceptions, pain points, handoffs and volumes, and park off-topic issues. Keep timing visible. After: convert the output to a clean BPMN diagram within two days, circulate it for validation, and record open questions with owners and dates.
37

Which what-if analysis tools does Excel have?

Save to ▾
Show answer
Goal Seek (find the input for a target output), Data Tables (see outputs for many inputs) and Scenario Manager (save best, base and worst cases).
38

Describe a time you explained a complex technical topic to a non-technical audience.

Save to ▾
Show answer
Situation: operations managers did not trust a new demand forecast that drove staffing. Task: explain it so they would use it. Action: I avoided model terms and showed how it used last year's same week, recent trend and festival calendar, with a chart of past forecasts against actuals. I compared the forecast range to a weather forecast. Result: managers started using it for rosters and gave feedback that improved it further.
39

A subscription app starts the month with 8,000 customers, gains 1,200 and loses 400. Calculate churn and net growth.

Save to ▾
Show answer
Churn rate uses customers at the start: 400 divided by 8,000 gives 5 percent. Ending customers are 8,000 plus 1,200 minus 400, which is 8,800. Net growth is 800 divided by 8,000, or 10 percent. Do not divide churned customers by the ending count, since new joiners who have not had a chance to churn would understate the churn rate.
40

Why should you avoid bidirectional relationships in a Power BI model?

Save to ▾
Show answer
Relationships normally filter one way, from the dimension (one side) to the fact (many side). Bidirectional filtering lets facts filter dimensions too, which can create ambiguous filter paths, unexpected totals and slower queries, especially with multiple fact tables. Prefer a clean star schema with single-direction filters, and when you need a reverse filter for one measure, use CROSSFILTER or TREATAS inside CALCULATE instead of changing the model globally.

Tips to crack the Tower Research Capital Business Analytics interview

  • Practise probability puzzles, expected value and brain teasers, which are common in quant trading interviews.
  • For developer roles, revise C++ deeply, including memory management, templates and low-latency coding practices.
  • Learn the basics of order books, market making and latency so you can discuss how trading systems work.
  • 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; Tower Research Capital interviewers usually ask follow-ups on your first answer.

Frequently asked questions

How many rounds are there in the Tower Research Capital Business Analytics interview?

Candidates usually go through 5 stages: Online assessment (coding + quant); Technical round 1 (DSA); Technical round 2 (C++ or systems); Quant or probability round; HR 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 Tower Research Capital Business Analytics interview?

This practice set leans on Case Studies and Guesstimates (7), Requirements and Agile (6), SQL for Business Analysis (5), Process Modelling and BPMN (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Tower Research Capital interviewers ask you to walk through real work.

Are these the exact questions asked at Tower Research Capital?

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

Where does Tower Research Capital hire Business Analytics professionals in India?

Tower Research Capital has large teams in Gurugram. Openings and locations change often, so check the Tower Research Capital careers page and filter by city and experience.

Business Analytics questions for similar companies