Assortment Planner

Advance Auto Parts • Raleigh, NC

9d • Hybrid

About The Position

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.

Requirements

• 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.
• 2-4 years related experience in Inventory Management, Assortment Planning, or Supply Chain
• Bachelor’s degree in Business, Merchandising, Mathematics or related field; OR equivalent combination of experience and education.

Responsibilities

• 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.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees