Wakefit Supply Chain Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Supply Chain Analyst in e-commerce, retail, and D2C ensures products move efficiently from suppliers to customers. Day to day, they analyse demand forecasts, inventory levels, and logistics data to optimise costs and delivery times. At a company like Wakefit, this means balancing fast delivery promises with warehouse and shipping costs.

Role and Technical Knowledge

1. 1

   What are the key differences between supply chain management in e-commerce versus traditional retail?

   Highlight demand variability, last-mile delivery, returns handling, and real-time inventory visibility.

2. 2

   How would you calculate and improve inventory turnover for a D2C furniture brand like Wakefit?

   Explain the formula (COGS / average inventory) and suggest strategies like demand forecasting, reducing lead times, and ABC analysis.

3. 3

   What is the bullwhip effect and how can an e-commerce company mitigate it?

   Define the phenomenon of demand amplification upstream, and mention information sharing, shorter lead times, and vendor-managed inventory.

4. 4

   Which supply chain KPIs would you track for an online furniture retailer?

   Include order fulfilment cycle time, fill rate, OTIF (on-time in-full), return rate, and cost per shipment.

Practical Scenarios

1. 5

   During a festive sale, orders spike 5x but your warehouse is understaffed. How would you handle it?

   Prioritise high-value orders, temporarily hire staff, coordinate with logistics partners, and communicate realistic delivery timelines.

2. 6

   A key supplier for mattress foam is delayed by two weeks. What steps would you take?

   Assess current inventory, find alternative suppliers, expedite shipping, and update demand forecasts to manage customer expectations.

3. 7

   Your company wants to reduce last-mile delivery costs by 15% without affecting delivery speed. How would you approach this?

   Analyse route optimisation, consolidate shipments, negotiate with couriers, and consider micro-fulfilment centres.

4. 8

   You notice that return rates for a particular product are 30% higher than average. How would you investigate and address it?

   Check product quality, packaging, and customer feedback; work with product and quality teams to fix root causes.

Data and Analytical Skills

1. 9

   How would you use Excel to analyse a large dataset of shipment delays?

   Mention pivot tables, VLOOKUP, conditional formatting, and charts to identify patterns by carrier, region, or time.

2. 10

   Write a SQL query to find the top 5 products with the highest return rates in the last quarter.

   Use GROUP BY, COUNT, and ORDER BY with a date filter; explain the logic clearly.

3. 11

   What is the difference between correlation and causation in supply chain analytics? Give an example.

   Explain that correlation does not imply causation; example: ice cream sales and shipment delays both rise in summer but are not directly linked.

4. 12

   How would you forecast demand for a new product with no historical sales data?

   Use market research, analogous product data, and pilot launches; mention qualitative methods like expert opinion.

Behavioural and HR Questions

1. 13

   Tell me about a time you worked under pressure to meet a deadline. How did you manage?

   Use STAR method; focus on prioritisation, communication, and a positive outcome.

2. 14

   Why do you want to work in supply chain for an e-commerce or D2C company?

   Show passion for fast-paced environments, data-driven decisions, and impact on customer experience.

3. 15

   Describe a situation where you had to convince a team member to adopt your idea. What was the result?

   Highlight listening, data-backed reasoning, and collaboration; end with a successful implementation.

4. 16

   Where do you see yourself in three years in this role?

   Express interest in deepening supply chain expertise, taking on larger projects, and contributing to strategic decisions.