Country Delight Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

A data analyst at Indian unicorns and high-growth startups like Country Delight supports teams across operations, marketing, and supply chain by turning raw data into actionable insights. Day to day, you will write SQL queries, build dashboards, run experiments, and present findings that help the company scale efficiently. You will work with large datasets from app usage, orders, and delivery logistics to improve customer retention and unit economics.

Role and company knowledge

1. 1

   What does a data analyst do at a quick-commerce or subscription-based startup like Country Delight?

   Focus on daily tasks: writing SQL to pull order data, building dashboards for delivery metrics, analyzing customer retention, and supporting pricing or supply chain decisions.

2. 2

   How would you measure the success of a subscription milk delivery service?

   Mention metrics like daily active subscribers, churn rate, average order value, delivery cost per order, and customer lifetime value. Show awareness of unit economics.

3. 3

   Why do Indian unicorns need data analysts more than traditional companies?

   Highlight fast scaling, large user bases, need for real-time decisions, experimentation culture, and optimizing logistics or marketing spend.

4. 4

   What are the key differences between working as a data analyst in an early-stage startup versus a large corporate?

   Talk about broader responsibilities, less structure, faster iteration, direct impact on product, and need to wear multiple hats.

Technical skills and tools

1. 5

   Write a SQL query to find the top 5 cities by number of orders in the last 30 days.

   Use GROUP BY city, COUNT(order_id), WHERE order_date >= DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY), ORDER BY count DESC LIMIT 5. Explain each clause.

2. 6

   How would you calculate the month-over-month churn rate for subscribers?

   Define churn as subscribers who cancelled in a month divided by active subscribers at start of month. Mention using SQL window functions or self-joins to track status changes.

3. 7

   Explain the difference between a JOIN and a UNION in SQL with an example relevant to orders and customers.

   JOIN combines columns from related tables (e.g., orders and customers on customer_id). UNION stacks rows from similar tables (e.g., orders from two different regions).

4. 8

   How would you use Excel or Python to clean a dataset with missing delivery timestamps?

   Discuss options: drop rows, impute with median or mode, or flag missing values. Show awareness of impact on analysis and need to document assumptions.

Practical scenarios and case studies

1. 9

   Daily deliveries are often late in a particular zone. How would you investigate and suggest improvements?

   Break down by time of day, delivery partner, route density, and order volume. Suggest A/B testing route changes or adding more partners during peak hours.

2. 10

   A new feature in the app increased sign-ups but not repeat orders. How would you analyze this?

   Use funnel analysis to see drop-off points, cohort analysis for repeat behavior, and segment by user demographics. Check if feature attracts low-intent users.

3. 11

   You need to estimate the number of delivery partners needed for a new city launch. How would you approach this?

   Estimate from expected orders per day, average delivery time, and partner shift hours. Use guesstimates with clear assumptions and sensitivity analysis.

4. 12

   Marketing wants to know which channel gives the best return on ad spend. What data would you pull and how?

   Pull cost per acquisition, conversion rates, and customer lifetime value by channel. Use SQL to join marketing spend with order data and calculate ROAS over time.

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 method: describe the problem, your data approach, the insight, and the outcome. Quantify results if possible.

2. 14

   How do you handle a situation where your analysis contradicts what your manager believes?

   Show respect, present data clearly, acknowledge limitations, and suggest testing the hypothesis together. Emphasize collaboration over being right.

3. 15

   Why do you want to work at a high-growth startup like Country Delight rather than a large IT firm?

   Connect personal motivation to fast learning, ownership, direct impact, and interest in solving real supply chain or consumer problems.

4. 16

   Describe a time you had to learn a new tool or skill quickly for a deadline.

   Give a specific example (e.g., learning Tableau for a hackathon). Highlight resourcefulness, time management, and the final result.