Assortment Merchandise Planning Intern Summer 2027
Job Description
Job Summary
Are you ready to spend your summer as a part of something special? Imagine being with a company whose reputation for excellence paves the way for endless success. At Genuine Parts Company (GPC), people build long-lasting, highly satisfying careers and make a real difference in the community. Our 10-week summer internship program will be in person in Atlanta and run from May 24 – July 30, 2027.
As an Assortment Planning Intern, you will be developing an Assortment Engine that optimizes SKU productivity across all Napa locations.
Our internship program is designed as a cohort experience, bringing interns from across the organization together to learn, grow, and build connections throughout the summer. While gaining hands-on experience within your team, you'll also be part of a community of fellow interns sharing the journey alongside you.
As an intern at GPC, you can look forward to:
Meaningful Work: Contribute to projects that support key business priorities and showcase your impact through a final presentation to senior leaders.
Professional Development: Participate in development experiences designed to build your skills, confidence, and understanding of the workplace.
Leadership Exposure: Hear from and connect with leaders across the organization, including senior executives, to learn more about our business, leadership, and career growth.
Connection & Community: Build relationships with fellow interns and employees through networking, social events, and collaborative experiences.
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.
Expected Deliverables
By the end of the internship, the intern will deliver:
SKU Productivity & Rationalization Framework that evaluates inventory productivity and identifies optimization opportunities.
Opportunity Sizing Model that estimates potential inventory reduction, turn improvement, and profitability benefits.
Interactive Dashboard allowing users to explore opportunities by category, supplier, store, and distribution hub.
Executive Opportunity Ranking highlighting the highest-impact assortment optimization opportunities across the business.
Final Leadership Presentation summarizing key findings, recommendations, and next steps.
Qualifications
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 Qualifications
3.25 GPA or above preferred.
Leadership Skills
Embodies the following values: serve, perform, influence, respect, innovate, team.
Effectively communicates by motivating and inspiring others through clear and proactive communication.
Delivers results and drives customer success by committing and focusing on outcomes to deliver results and making the customer the center of decisions.
Makes balanced decisions and thinks strategically by being a forward thinker.
Physical Demands / Working Environment
Expected to operate in a professional office environment.
The 2027 program will run from May 24 – July 20, 2027
The work week is 40 hours.
Working hours are M-F 8:00AM – 5:00PM with a 1-hour lunch break.