Spar Hypermarket India Supply Chain Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Supply Chain Analyst in e-commerce, retail, or D2C tracks inventory, demand, and logistics data to ensure products are available at the right place and time without excess stock. Day to day, you pull data from ERP and warehouse systems, build reports on stock levels and fill rates, coordinate with store and warehouse teams, and flag slow-moving or out-of-stock items. At a company like Spar Hypermarket India, you might work on store replenishment, vendor performance, or last-mile delivery metrics.

Role and technical knowledge

1. 1

   What is safety stock and how would you decide the right level for a fast-moving product in a supermarket?

   Define safety stock as buffer against demand or lead time variability. Mention factors like average daily sales, lead time, service level target, and demand variability. Avoid giving a single formula without context.

2. 2

   Explain the difference between fill rate and order accuracy, and why both matter for an e-commerce or D2C business.

   Fill rate measures how much of demand is met from available stock. Order accuracy measures whether the right item, quantity, and quality reached the customer. Both affect customer satisfaction and repeat purchase.

3. 3

   How would you calculate inventory turnover ratio and what does a low ratio indicate for a retail store?

   Inventory turnover = cost of goods sold divided by average inventory. A low ratio suggests overstocking, slow-moving items, or poor demand forecasting, which ties up working capital.

4. 4

   What is the bullwhip effect and how can a D2C brand reduce it?

   The bullwhip effect is demand distortion moving up the supply chain. Reduce it through better information sharing, shorter lead times, and smaller, more frequent orders rather than bulk ordering.

Practical scenarios and tools

1. 5

   You notice that a top-selling SKU is frequently out of stock in three stores but overstocked in two others. How would you investigate and fix this?

   Start by checking store-level sales data, replenishment rules, and lead times. Look for allocation errors, local demand differences, or minimum order quantity issues. Suggest rebalancing stock and adjusting store-specific reorder points.

2. 6

   How would you use Excel or SQL to find the top 10 vendors with the highest late delivery percentage last month?

   Describe joining purchase order and delivery tables, filtering by date, calculating delay days, grouping by vendor, and sorting descending. Mention using pivot tables or a GROUP BY query with a date filter.

3. 7

   A last-mile delivery partner is causing high return rates in one pincode. What data would you pull and what actions would you take?

   Pull delivery attempt data, return reasons, time to deliver, and customer complaints for that pincode. Compare with other partners. Actions could include retraining, route changes, or switching partners for that area.

4. 8

   You are asked to reduce warehouse picking time by 10 percent. What steps would you take?

   Map the current process, identify bottlenecks like travel time or missing items, and suggest slotting fast movers near packing stations, batch picking, or better bin labels. Mention measuring before and after.

Behavioural and situational questions

1. 9

   Tell me about a time you had to meet a deadline with incomplete data. How did you handle it?

   Use a STAR example. Show that you made reasonable assumptions, documented them, and still delivered a useful output. Avoid saying you waited for perfect data.

2. 10

   Describe a situation where you had to convince a teammate or friend to change their approach. What was the result?

   Focus on listening first, presenting data or logic, and finding a middle ground. Show that you value the relationship and the outcome, not just being right.

3. 11

   In a retail peak season like Diwali, how would you prioritise your tasks if you have multiple urgent requests?

   Prioritise by customer impact and revenue risk. Communicate clearly with stakeholders about trade-offs. Mention using a simple urgency-importance matrix or daily check-ins.

4. 12

   Give an example of a mistake you made in a project or assignment. What did you learn?

   Choose a real but not catastrophic mistake. Explain what you did to fix it and what process you changed to avoid repeating it. Show ownership and learning.

HR and company fit

1. 13

   Why do you want to work as a supply chain analyst in retail or e-commerce rather than another sector?

   Connect your interest to the fast pace, data-driven decisions, and visible impact on product availability. Mention specific aspects like demand forecasting or last-mile challenges.

2. 14

   What do you know about Spar Hypermarket India or similar retail chains, and how do they make money?

   Show basic awareness: retail chains earn through margins on products, private labels, and efficient supply chains. Mention store formats, footfall, and inventory management as key levers.

3. 15

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

   Show realistic ambition: deepening supply chain knowledge, taking ownership of a category or region, and learning advanced tools. Avoid saying you want to leave the role quickly.

4. 16

   Are you comfortable working with store teams, warehouse staff, and vendors, sometimes outside regular hours during peak season?

   Answer honestly but positively. Mention any past experience working in teams or during busy periods. Show willingness to learn from frontline staff.