Pepperfry 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 fulfillment to balance product availability with cost efficiency. Day to day, they analyze sales data, coordinate with warehouse and logistics teams, and optimize stock levels across channels. At companies like Pepperfry, this role supports furniture and home goods supply chains, where bulky items and long lead times add complexity.

Role and Technical Knowledge

1. 1

   What is the difference between demand forecasting and demand planning in an e-commerce context?

   Explain that forecasting predicts future demand using historical data and trends, while planning includes adjusting supply, inventory, and promotions to meet that forecast. Give an example like planning for festive season sales.

2. 2

   How would you calculate inventory turnover ratio and why is it important for a D2C brand?

   Define it as cost of goods sold divided by average inventory. Mention that high turnover means efficient stock management, but too high can lead to stockouts, especially for long lead-time items like furniture.

3. 3

   What are some key supply chain metrics you would track for an online furniture retailer?

   List metrics like order fill rate, on-time delivery, inventory days of supply, and return rate. Explain why each matters for bulky, high-value products.

4. 4

   Explain the concept of safety stock and how you would determine it for a product with variable demand.

   Define safety stock as buffer inventory to handle demand variability and lead time uncertainty. Mention using formulas like z-score times standard deviation of demand during lead time.

Practical Scenarios

1. 5

   You notice that a popular sofa model is frequently out of stock on the website. How would you investigate and resolve this?

   Outline steps: check inventory records, review sales trends, assess lead times from suppliers, and coordinate with buying team to increase order quantity or find alternative suppliers. Suggest setting up alerts.

2. 6

   During a festive sale, orders surge by 300 percent. How would you ensure timely delivery without overspending on logistics?

   Talk about pre-planning with temporary staff, negotiating rates with multiple couriers, prioritizing high-margin orders, and using data to predict surge locations. Mention real-time tracking and communication with customers.

3. 7

   A supplier consistently delays shipments of wooden dining tables. What steps would you take?

   Suggest discussing with the supplier to understand root causes, exploring backup suppliers, adjusting safety stock, and possibly renegotiating contract terms. Highlight communication and contingency planning.

4. 8

   How would you reduce return rates for a D2C apparel brand from a supply chain perspective?

   Focus on accurate product descriptions, size charts, and quality checks. Suggest analyzing return reasons and feeding insights back to design and sourcing teams to improve fit and quality.

Behavioural and Situational

1. 9

   Tell me about a time when you had to analyze a large dataset to solve a problem. What was your approach?

   Use STAR method: describe the situation, the data you used, tools like Excel or SQL, and the outcome. Emphasize logical steps and impact.

2. 10

   Describe a situation where you had to work under a tight deadline. How did you manage?

   Show prioritization, time management, and communication. Mention breaking tasks down and seeking help when needed.

3. 11

   Give an example of a time you disagreed with a team member. How did you handle it?

   Focus on respectful communication, listening to their perspective, and using data to reach a consensus. Highlight the positive outcome.

4. 12

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

   Connect personal interest in problem-solving and efficiency to the dynamic nature of e-commerce. Mention the challenge of managing bulky goods and the opportunity to learn.

HR and Company Fit

1. 13

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

   Research Pepperfry's online furniture marketplace, its logistics network, and how supply chain ensures timely delivery and inventory management. Show enthusiasm for the sector.

2. 14

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

   Express a desire to grow into a senior analyst or supply chain manager role, gaining expertise in demand planning and process improvement. Align with company growth.

3. 15

   How do you handle stress or pressure in a fast-paced environment?

   Share coping mechanisms like prioritizing tasks, taking breaks, and maintaining a positive attitude. Give a brief example.

4. 16

   What are your salary expectations for this role?

   Research industry standards for freshers in supply chain analytics. Give a range and express flexibility based on overall compensation and learning opportunities.