Q1
Walk us through how you would analyze product performance data across a category using tools like Excel, Tableau, or SQL. What metrics would you prioritize and why?
Why they ask this:* They're assessing your ability to extract actionable insights from data, understand which KPIs matter for category optimization, and demonstrate proficiency with industry-standard analytics tools.
Q2
Describe your experience with inventory management systems and demand forecasting. How have you used these tools to reduce stockouts or overstock situations in an ecommerce environment?
Why they ask this:* They want to know if you can balance supply-side constraints with customer demand, manage working capital efficiently, and prevent lost sales or excess inventory costs.
Q3
Explain how you approach assortment planning and SKU rationalization. What framework or methodology do you use to decide which products to keep, expand, or discontinue?
Why they ask this:* This tests whether you understand product portfolio strategy, can make data-driven decisions about product mix, and can optimize shelf space and inventory investment for profitability.
Q4
How do you track and optimize pricing strategy within your category? What tools or methodologies do you use to monitor competitor pricing and implement dynamic or promotional pricing?