Wow Momo Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Data Analyst at an Indian unicorn or high-growth startup like Wow Momo works on business problems that change weekly, from tracking outlet-level sales and delivery-app performance to building dashboards for marketing spend and supply-chain efficiency. You will pull data with SQL, clean and analyse it in Excel or Python, and present findings to non-technical teams so they can act quickly. The role rewards speed, ownership, and the ability to connect numbers to real operational decisions.

Role and company knowledge

1. 1

   How would you measure the success of a single Wow Momo outlet in a month?

   A strong answer covers revenue, order volume, average order value, repeat customer rate, food cost percentage, and delivery versus dine-in mix, and explains why each metric matters.

2. 2

   A quick-service restaurant chain sees rising revenue but falling profit. What data would you pull first?

   Focus on cost drivers like ingredient prices, discount depth, delivery aggregator commissions, wastage, and outlet-level contribution margin before jumping to conclusions.

3. 3

   Why does a high-growth startup need a data analyst rather than just relying on the finance team?

   Explain that startups need fast, granular, and forward-looking views on customer behaviour, marketing spend, and operations, which finance reports alone may not provide at the needed speed.

4. 4

   What is one metric you would track daily for a food-delivery-first brand?

   Pick a metric like orders per outlet per day or delivery-app rating, and justify why daily tracking helps spot operational issues early.

Technical skills and tools

1. 5

   Write a SQL query to find the top 5 cities by total orders in the last 30 days from an orders table.

   Show a clear GROUP BY city, SUM of orders, a WHERE clause on order date, ORDER BY total descending, and LIMIT 5; mention handling nulls or cancelled orders.

2. 6

   How would you use Excel or Google Sheets to compare month-on-month sales across 20 outlets?

   Describe pivot tables, calculated fields for growth percentage, conditional formatting, and a simple chart to highlight outliers.

3. 7

   You have a customer table with duplicate phone numbers. How would you clean it before analysis?

   Explain identifying duplicates, deciding a rule for keeping one record, using formulas or Python to deduplicate, and validating that the final count matches business expectations.

4. 8

   What is the difference between an inner join and a left join, and when would you use each in a restaurant sales dataset?

   Define both clearly and give one example each, such as inner join for orders with valid outlet IDs and left join to keep all outlets even if some had zero orders.

Practical scenarios and case questions

1. 9

   A new momo variant is not selling well in two cities. How would you investigate?

   Break the problem into demand, pricing, placement, and promotion; compare with similar products, check local taste preferences, and suggest a small pilot before a full rollout.

2. 10

   Marketing wants to increase spend on a delivery app. What analysis would you do before agreeing?

   Look at return on ad spend, customer acquisition cost, repeat order rate from those customers, and incrementality rather than just last-click orders.

3. 11

   You find that weekend sales are strong but weekday lunch sales are weak. What could you recommend?

   Suggest analysing footfall patterns, office density near outlets, competitor pricing, and testing weekday combos or corporate tie-ins, then measuring the impact.

4. 12

   Your dashboard shows a sudden 40 percent drop in daily orders. How do you respond?

   First check data pipeline issues, missing dates, or filter errors, then verify with a second source, and only then investigate real-world causes like outlet closures or app outages.

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 the STAR format, keep it specific, and highlight what you found, what you recommended, and what changed as a result.

2. 14

   You are given a messy dataset and a tight deadline. How do you prioritise?

   Show that you clarify the key question first, do quick sanity checks, deliver a first useful cut fast, and then refine; mention communicating trade-offs to the stakeholder.

3. 15

   A senior manager disagrees with your analysis. How do you handle it?

   Stay calm, ask about their assumptions, re-check your data and logic, and present evidence clearly without being defensive; be open to being wrong.

4. 16

   Why do you want to work as a data analyst in a fast-growing food and beverage startup?

   Connect your interest in data to real-world operations, speed of learning, and visible impact; mention specific aspects of the sector like supply chain, delivery, or customer retention.