Hybrid Assortment & Inventory Planner

Advance Auto Parts; Raleigh (NC); Hybrid; USD 70,000 - 95,000; Full time

Job summary

Advance Auto Parts is seeking an Assortment Planner to drive sales and optimize inventory by developing product assortments across categories. This role requires strong analytical skills, market trend understanding, and cross-functional collaboration.

The position is hybrid (4 days in office, 1 day remote) at our Raleigh, NC corporate headquarters with potential travel. Qualifications include retail math, advanced Excel, SQL basics, and project management experience.

Qualifications

• Retail Math: Gross Margin, Turn, GMROI, Weeks of Supply, Sell Through, AUR, ASR.
• Advanced Excel with pivot tables, formulas, data analysis; PowerPoint for insights.
• SQL proficiency for data extraction, analysis, reporting.
• Project management skills; manage multiple initiatives with deadlines.
• Excellent communication and collaboration; work with project owners and stakeholders.
• Analytical mindset with attention to detail and proactive problem solving.
• Comfort navigating complex datasets and systems to drive actionable insights.

Responsibilities

• Develop and execute seasonal and promotional assortment plans.
• Analyze sales, market trends, and customer preferences to inform decisions.
• Collaborate with merchandising, marketing, and supply chain teams.
• Monitor inventory levels and turnover to maximize profitability.
• Create and present assortment performance reports with recommendations.
• Stay informed on industry trends and consumer behavior.

Skills

Retail math

Advanced Excel

PowerPoint

SQL basics

Project management

Communication & collaboration

Analytical mindset

Data analysis

Education

Bachelor's degree in Business, Merchandising, Mathematics or related field; OR equivalent combination of experience and education

Job description

Advance Auto Parts is seeking an Assortment Planner to drive sales and optimize inventory by developing product assortments across categories. This role requires strong analytical skills, market trend understanding, and cross-functional collaboration.

The position is hybrid (4 days in office, 1 day remote) at our Raleigh, NC corporate headquarters with potential travel. Qualifications include retail math, advanced Excel, SQL basics, and project management experience.