Assortment Planner

Advance Auto Parts•Raleigh, NC

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

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.