Rebel Foods Cloud Kitchens Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

A data analyst at an Indian unicorn or high-growth startup like Rebel Foods Cloud Kitchens spends the day pulling data from multiple sources (POS, app, delivery partners, supply chain) to build dashboards, run experiments, and answer business questions about demand, kitchen operations, and customer retention. You will work closely with operations, marketing, and product teams to turn raw data into actionable insights that drive daily decisions. Expect fast-paced ad-hoc requests, weekly reporting, and a strong emphasis on SQL, spreadsheets, and basic Python or BI tools.

Role and sector knowledge

1. 1

   What does a typical day look like for a data analyst at a cloud kitchen startup like Rebel Foods?

   Mention morning metric checks (orders, cancellations, prep time), ad-hoc queries from city managers, building or updating dashboards, and end-of-day reporting. Show you understand the fast, operations-heavy rhythm.

2. 2

   How would you measure the success of a new menu item launched across 50 cloud kitchens?

   Define metrics like attach rate, repeat order rate, contribution margin, and kitchen prep time impact. Suggest a test vs control group across similar kitchens and a 4-week observation window.

3. 3

   Why do Indian food-tech unicorns rely heavily on data analysts compared to traditional restaurants?

   Highlight scale (multiple brands, hundreds of kitchens), thin margins, real-time delivery promises, and the need to optimise supply chain, demand forecasting, and customer lifetime value continuously.

4. 4

   What are the key differences between analysing data for a cloud kitchen versus an e-commerce marketplace?

   Focus on perishable inventory, kitchen capacity constraints, delivery radius, and hyperlocal demand patterns. E-commerce has more stable inventory and broader geography.

Technical SQL and data skills

1. 5

   Write a SQL query to find the top 5 cuisines by total revenue in the last 30 days, excluding cancelled orders.

   Use JOIN between orders and menu tables, filter status = 'delivered' and date >= current_date - 30, GROUP BY cuisine, SUM revenue, ORDER BY DESC LIMIT 5. Mention handling NULLs and time zones.

2. 6

   How would you identify kitchens with declining week-over-week order volume?

   Use a window function like LAG to compare current week vs previous week per kitchen. Filter where decline is more than 10 percent. Explain how you would exclude new kitchens or one-off holidays.

3. 7

   Given a table with order timestamps, how do you calculate average preparation time per kitchen per hour of day?

   Extract hour from timestamp, compute difference between ready_time and order_time, then GROUP BY kitchen_id and hour. Mention using EXTRACT and AVG, and handling missing ready_time.

4. 8

   What is the difference between a LEFT JOIN and an INNER JOIN, and when would you use each in a kitchen operations report?

   LEFT JOIN keeps all kitchens even if no orders, useful for identifying inactive kitchens. INNER JOIN only shows kitchens with orders, useful for revenue analysis. Give a concrete example.

Practical scenarios and case studies

1. 9

   A city manager says orders dropped 15 percent last week in one zone. How would you investigate?

   Break down by day, hour, kitchen, and cuisine. Check external factors (rain, festival, competitor launch), internal factors (app downtime, kitchen closure, delivery partner shortage). Suggest a funnel from app open to order placed.

2. 10

   You have to design a dashboard for the head of operations showing kitchen health. What metrics would you include?

   Include order volume, average prep time, cancellation rate, customer rating, wastage percentage, and kitchen utilisation. Suggest filters by city, brand, and time period. Mention refresh frequency.

3. 11

   How would you test whether a new packaging reduces delivery time without hurting food quality?

   Run an A/B test across matched kitchens. Define primary metric (delivery time) and guardrail metrics (complaints, ratings, return rate). Choose sample size and duration, then analyse with a t-test or simple confidence intervals.

4. 12

   You find that 20 percent of customers account for 60 percent of orders. What actions would you recommend?

   Suggest a loyalty program, personalised offers, and priority support for high-value customers. Also analyse what drives their frequency (specific cuisines, time slots) and try to replicate for others. Mention cohort retention.

Behavioural and HR questions

1. 13

   Tell me about a time you used data to solve a problem in a college project or internship.

   Use STAR format. Focus on the data you collected, the tool you used (Excel, SQL, Python), the insight you found, and the outcome. Quantify the impact if possible.

2. 14

   How do you handle a situation where a senior manager asks for a report but you are already overloaded with requests?

   Show prioritisation based on business impact and deadlines. Mention communicating trade-offs transparently, offering a quick interim answer, and using automation or templates to save time.

3. 15

   Why do you want to work in a high-growth startup like Rebel Foods rather than a large IT services company?

   Talk about ownership, speed of learning, direct impact on business decisions, and exposure to multiple functions. Avoid criticising other sectors. Show genuine interest in food-tech or consumer internet.

4. 16

   Describe a time you received critical feedback on your analysis. How did you respond?

   Pick a real example. Show you listened, asked clarifying questions, rechecked your assumptions, and improved the analysis. Emphasise that you value accuracy over ego.