Assortment Planner

Job Description

Workday Job Profile: Assortment Planner  

Business/Posting Title: Assortment Planner

Grade: 8

Job Summary:  

The Assortment Planner will play a crucial role in driving sales and optimizing inventory by developing and managing product assortments across various categories. This position requires strong analytical skills, a deep understanding of market trends, and the ability to collaborate effectively with cross-functional teams. 

What will you do? 

• Assortment Strategy: Develop and execute seasonal and promotional assortment plans that align with overall business objectives and customer demand. 
• Data Analysis: Analyze sales data, market trends, and customer preferences to inform assortment decisions and identify opportunities for growth. 
• Collaboration: Work closely with merchandising, marketing, and supply chain teams to ensure optimal product availability and alignment with promotional activities. 
• Inventory Management: Monitor inventory levels and turnover rates to maximize profitability and minimize excess stock. 
• Reporting: Create and present reports on assortment performance, highlighting key metrics and recommendations for improvement. 
• Market Research: Stay informed about industry trends, competitor offerings, and consumer behavior to drive informed assortment decisions. 

Location & Work Availability:   

This position is Hybrid (4 days in office, 1 day remote), based at our corporate headquarters in Raleigh, North Carolina. Flexibility for occasional travel may be required. 

Benefits Summary: 

We believe in supporting our Team Members and those they love through comprehensive health & wellness benefits. Learn more here: https://jobs.advanceautoparts.com/us/en/benefits  

Qualifications: 

• Retail Math Expertise: Gross Margin, Turn, GMROI, Weeks of Supply, Sell Through %, Balance of Sale, Average Unit Cost, Average Unit Retail, Sales per Sq Ft
• Advanced Excel and Power Point: Leverages advanced Excel capabilities (including pivot tables, formulas, and data analysis) and PowerPoint to deliver clear, actionable insights.
• Basic/Moderate SQL proficiency for data extraction, analysis, and reporting across assortment planning systems.
• Project management, ability and willingness to manage multiple initiatives with competing deadlines, utilizing Project Management tools
• Excellent communication and collaboration skills, with the ability to work independently while effectively engaging with project owners and cross-functional stakeholders.
• Analytical mindset with attention to detail and a proactive approach to problem-solving.
• Comfortable navigating complex datasets and systems, with a focus on driving actionable insights and operational efficiency.

Certifications, Experience, and Education: 

• Certifications: None 
• Experience: 2-4 years related experience in Inventory Management, Assortment Planning, or Supply Chain  
• Education: Bachelor’s degree in Business, Merchandising, Mathematics or related field; OR equivalent combination of experience and education.  

Benefits Summary: 

We believe in supporting our Team Members and those they love through comprehensive health & wellness benefits. Learn more here: https://jobs.advanceautoparts.com/us/en/benefits  

Company Overview: 

Advance Auto Parts, Inc. is a leading automotive aftermarket parts provider that serves both professional installer and do-it-yourself customers. As of January 3, 2026, Advance operated 4,305 stores primarily within the United States, with additional locations in Canada, Puerto Rico and the U.S. Virgin Islands. The Company also served 809 independently owned Carquest branded stores across these locations in addition to Mexico and various Caribbean islands. Additional information about Advance, including employment opportunities, customer services, and online shopping for parts, accessories and other offerings can be found at www.AdvanceAutoParts.com. 

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age national origin, religion, sexual orientation, gender identity, status as a veteran and basis of disability or any other federal, state, or local protected class. 

#LI-AC1

California Residents click below for Privacy Notice: