Shadowfax Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

Data Analysts at Indian unicorns and high-growth startups like Shadowfax work on live business problems such as tracking delivery performance, customer retention, and pricing efficiency. They write SQL queries, build dashboards, and present insights to product, operations, and marketing teams to drive quick decisions in a fast-paced environment.

Role and Technical Knowledge

1. 1

   What is the difference between a left join and an inner join in SQL, and when would you use each in a delivery analytics context?

   Explain that inner join returns only matching rows, while left join keeps all rows from the left table. Give an example like joining orders with delivery partners to find orders without a partner.

2. 2

   How would you calculate the average delivery time per city from a table of orders with pickup and drop timestamps?

   Show a SQL query using TIMESTAMPDIFF or DATEDIFF, GROUP BY city, and AVG. Mention filtering out cancelled or invalid orders.

3. 3

   What are DAU, MAU, and stickiness ratio? How would you use them to measure engagement for a hyperlocal delivery app?

   Define daily active users, monthly active users, and stickiness as DAU/MAU. Explain that a higher stickiness means more frequent usage, useful for retention strategies.

4. 4

   Explain the difference between correlation and causation with an example from a startup's data, such as discounts and order volume.

   State that correlation does not imply causation. Use an example like discounts and orders may both rise during festivals, but the festival causes both.

Practical Scenarios and Case Questions

1. 5

   You are given a dataset of delivery partners with their daily completed orders and ratings. How would you identify the top 10 percent performers?

   Describe sorting by a composite score (orders and ratings), using percentiles or NTILE in SQL, and validating with business context like tenure or zone.

2. 6

   A city manager says delivery times increased last week. How would you investigate the root cause using data?

   Outline steps: check data quality, break down by zone, time of day, partner availability, weather, and order volume. Compare with previous weeks and suggest hypotheses.

3. 7

   How would you design an A/B test to check if a new in-app banner increases repeat orders?

   Cover random assignment, control and treatment groups, sample size, success metric like repeat order rate, and duration. Mention checking for novelty effects.

4. 8

   You need to present weekly performance to non-technical operations managers. What charts or metrics would you include?

   Suggest simple line charts for trends, bar charts for comparisons, and key metrics like on-time delivery rate, average delivery time, and partner utilization. Avoid jargon.

Behavioural and Situational Questions

1. 9

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

   Use the STAR method: situation, task, action, result. Highlight the data tools used and the impact, even if small.

2. 10

   Describe a situation where you had to explain a technical finding to someone with no data background.

   Focus on simplifying without losing accuracy. Mention using analogies, visuals, and checking for understanding.

3. 11

   How do you handle tight deadlines when multiple stakeholders ask for reports at the same time?

   Show prioritization based on business impact, clear communication about timelines, and using templates or automation to save time.

4. 12

   Give an example of a mistake you made in an analysis and how you corrected it.

   Be honest about a small error, like a wrong join. Emphasize learning, double-checking, and adding validation steps.

HR and Company Fit

1. 13

   Why do you want to work as a Data Analyst at a high-growth startup like Shadowfax rather than a large corporate?

   Mention the fast pace, ownership, direct impact on business decisions, and exposure to multiple functions. Avoid generic answers about 'learning'.

2. 14

   Where do you see yourself in three years in terms of analytics skills and career growth?

   Show a plan to deepen SQL and Python, learn advanced experimentation, and take ownership of a business area. Align with startup growth paths.

3. 15

   How would you handle a situation where your analysis contradicts a senior manager's intuition?

   Stress respectful communication, presenting data clearly, listening to their perspective, and suggesting a small test to validate.

4. 16

   What do you know about the Indian unicorn ecosystem and the challenges these companies face with data?

   Mention scale, real-time decisions, data quality issues, and the need for quick insights. Show awareness of logistics, fintech, or e-commerce contexts.