Assorment Planning Intern - Summer 2027
Core
Develop an Assortment Engine to optimize SKU productivity and rationalization across Napa locations using data-driven methodologies.
Role type
Summer Intern, Assortment Planning & Analytics
Builds
SKU Productivity & Rationalization Framework, Opportunity Sizing Model, Interactive Dashboard, Executive Opportunity Ranking
Domain
Retail / Automotive Parts / Inventory Optimization
Required skills
SQL, Python, R, Power BI, Tableau, Excel, Data Analysis, Large Dataset Handling
Responsibilities
Develop data-driven methodology to evaluate SKU performance using metrics like Sales velocity, GMROI, and Inventory turns; Create scoring framework for SKU rationalization; Quantify optimization opportunities to reduce inventory and improve turns; Design and build interactive dashboards; Summarize findings and recommendations for business leaders through presentations.
