{bc}
workday

Assorment Planning Intern - Summer 2027

Genuine Parts Company
Atlanta, USA
Full-time
Intern
Onsite
Discovered 2 days ago
power-bipythonsqltableau

Full Job Posting

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.
  • Not the right fit? Let us know you're interested in a future opportunity by joining our Talent Community on jobs.genpt.com or create an account to set up email alerts as new job postings become available that meet your interest!
  • 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.
  • 25 GPA or above preferred.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Genuine Parts Company