Assorment Planning Intern - Summer 2027

Genuine Parts Company; Atlanta (GA); On-site; USD 22,000 - 30,000; Full time

Job summary

Genuine Parts Company (GPC) invites rising juniors and seniors to join its 10-week Assortment Planning Internship in Atlanta. The program runs May 24–July 20, 2027, in person, with a cohort experience designed to build skills and community.

You will develop an Assortment Engine to optimize SKU productivity, build dashboards in Power BI, and present findings to senior leaders, collaborating with analytics, inventory planning, and category teams.

Qualifications

• Currently a rising junior or senior pursuing an undergraduate degree in Data Analytics, Data Science, Computer Science, Statistics or related field.
• Experience with data analysis tools such as SQL, Python, R, Power BI, Tableau, Excel.

Responsibilities

• Develop a data-driven methodology to evaluate SKU and product line performance using key metrics.
• Create a scoring framework for SKU rationalization candidates.
• Quantify optimization opportunities to reduce inventory investment and improve GMROI.
• Analyze categories and suppliers to identify optimization opportunities.
• Support sensitivity analysis for assortment strategies.
• Design and build interactive dashboards in Power BI or similar tools.
• Summarize findings and recommendations for senior leaders through presentations.

Skills

Data analysis

Data visualization

Education

Undergraduate degree in Data Analytics/ related field

GPA 3.25+ preferred

Tools

SQL

Python

R

Power BI

Tableau

Excel

AI

Job description

Students are encouraged to submit their application by October 29, 2026 for priority consideration.

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.

GPC conducts its business without regard to sex, race, creed, color, religion, marital status, national origin, citizenship status, age, pregnancy, sexual orientation, gender identity or expression, genetic information, disability, military status, status as a veteran, or any other protected characteristic. GPC's policy is to recruit, hire, train, promote, assign, transfer and terminate employees based on their own ability, achievement, experience and conduct and other legitimate business reasons.