Zapyle Supply Chain Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Supply Chain Analyst in e-commerce, retail, and D2C manages inventory planning, demand forecasting, and order fulfilment to ensure products reach customers quickly and cost-effectively. They analyse sales data, coordinate with warehouse and logistics teams, and optimise stock levels to balance availability with working capital. In fast-growing companies, they often work on process automation, vendor management, and last-mile delivery improvements.

Role and Technical Knowledge

1. 1

   Explain the difference between demand forecasting and inventory planning in an e-commerce setting.

   Demand forecasting predicts future customer demand using historical data and trends, while inventory planning decides how much stock to hold and when to reorder based on that forecast. A strong answer links both to avoiding stockouts and excess inventory.

2. 2

   What are the key metrics you would track to measure supply chain performance for a D2C brand?

   Mention order fulfilment cycle time, inventory turnover ratio, perfect order rate, and cost per shipment. Relate each metric to customer experience and cost efficiency.

3. 3

   How would you use Excel or SQL to analyse a large dataset of orders to identify slow-moving SKUs?

   Describe using pivot tables or SQL queries to calculate sales velocity per SKU, then filter for low turnover. Highlight the goal of reducing dead stock and freeing up warehouse space.

4. 4

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

   The bullwhip effect is demand variability amplifying up the supply chain. Mitigation includes sharing real-time sales data with suppliers, using smaller and more frequent orders, and improving forecast accuracy.

Practical Scenarios

1. 5

   During a festive sale, you notice that a popular product is out of stock in the North region but overstocked in the South. What steps would you take?

   Suggest immediate inter-warehouse transfer if feasible, then analyse regional demand patterns to adjust future allocation. Also consider a temporary promotion in the South to clear excess stock.

2. 6

   A key supplier is consistently late by 3-4 days, causing delivery delays. How would you handle this?

   Start by quantifying the impact on customer satisfaction and costs. Then discuss root cause analysis with the supplier, exploring alternatives like buffer stock, dual sourcing, or renegotiating lead times.

3. 7

   You are asked to reduce last-mile delivery costs by 10% without affecting delivery speed. What ideas would you propose?

   Consider route optimisation, consolidating shipments, using local micro-fulfilment centres, or negotiating better rates with courier partners. Emphasise data analysis to identify cost drivers first.

4. 8

   How would you decide the reorder point for a product with highly variable demand?

   Explain using safety stock based on demand variability and lead time, and setting reorder point as average demand during lead time plus safety stock. Mention using historical data to calculate variability.

Behavioural and HR Questions

1. 9

   Tell me about a time you worked under a tight deadline. How did you manage?

   Use the STAR method: describe the situation, task, action (prioritisation, time management), and result. Highlight learning and ability to stay calm.

2. 10

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

   Show passion for the fast-paced, data-driven nature of e-commerce and how supply chain directly impacts customer experience. Connect it to your skills and career goals.

3. 11

   Describe a situation where you had to convince a team member to adopt your idea.

   Focus on listening to their concerns, presenting data or logic, and finding a compromise. Emphasise teamwork and achieving a better outcome.

4. 12

   How do you handle criticism or feedback on your work?

   Show openness to feedback as a learning opportunity. Give an example where you improved a process or analysis after receiving feedback.

Company and Sector Awareness

1. 13

   What do you understand about Zapyle's business model and how supply chain fits into it?

   Research Zapyle's focus (e.g., fashion, D2C) and explain how supply chain ensures timely delivery, inventory management, and cost control. Avoid claiming specific internal details.

2. 14

   What are the biggest supply chain challenges for Indian e-commerce companies today?

   Mention infrastructure gaps, high return rates, cash on delivery complexities, and festive demand spikes. Show awareness of how companies address these.

3. 15

   How can a supply chain analyst contribute to sustainability in e-commerce?

   Discuss optimising routes to reduce emissions, using eco-friendly packaging, and reducing returns through better product descriptions. Link sustainability to cost savings and brand value.

4. 16

   If you were to improve one aspect of Zapyle's supply chain, what would it be and why?

   Pick a realistic area like returns management or demand forecasting, and suggest a data-driven improvement. Focus on impact and feasibility.