Genuine Parts Company is hiring an Assortment Planning Intern to develop an Assortment Engine that optimizes SKU productivity across Napa locations. The intern will analyze product and inventory performance, quantify assortment optimization opportunities, build executive dashboards, and present actionable recommendations.
Responsibilities
Develop a data-driven methodology to evaluate SKU and product line performance using key metrics such as: Sales velocity, Inventory investment, Gross Margin Return on Inventory Investment (GMROI), Inventory turns, Fill rate contribution, Product profitability
Create a scoring framework that identifies potential SKU rationalization candidates and highlights products that may be consuming disproportionate inventory relative to their business value
Quantify Optimization Opportunities
Analyze product categories and suppliers to identify opportunities to:
Reduce inventory investment
Improve inventory turns
Increase GMROI
Enhance assortment productivity
Estimate the impact of potential rationalization actions at the category, supplier, and product-line level
Support sensitivity analysis to evaluate the potential benefits and risks of various assortment strategies
Develop Executive Analytics & Insights
Design and build interactive dashboards in Power BI or similar visualization tools
Create executive-ready opportunity rankings that highlight the largest assortment optimization opportunities across:
Categories
Product lines
Suppliers
Stores and distribution hubs
Summarize findings and recommendations for business leaders through presentations and visual storytelling
Partner Across the Business
Collaborate with stakeholders from assortment planning, category management, inventory planning, and analytics teams
Validate business assumptions and ensure recommendations are actionable and aligned with operational realities
Qualification
Required
Currently a rising junior or senior pursuing an undergraduate degree in Data Analytics, Data Science, Computer Science, Statistics or other related field required
Experience with data analysis tools such as:SQL, Python, R, Power BI, Tableau, AI, Excel
Ability to work with large datasets and derive actionable business insights
Preferred
3.25 GPA or above preferred
Benefits
Professional development experiences designed to build your skills, confidence, and understanding of the workplace.
Hear from and connect with leaders across the organization, including senior executives, to learn more about the business, leadership, and career growth.
Build relationships with fellow interns and employees through networking, social events, and collaborative experiences.
Genuine Parts Company is a service organization engaged in the distribution of automotive replacement parts & industrial replacement parts
