Assortment Planner

Advance Stores Company • Raleigh, NC

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

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

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level