Senior Data-Driven Assortment Planner

Advance Auto Business Support (300); Raleigh (NC); On-site; USD 75,000 - 110,000; Full time

Job summary

Advance Auto Parts, Inc. is seeking a data analyst to analyze and model product assortment, produce reports, and present insights to key stakeholders.

The role emphasizes SQL, Excel, and big data techniques, with cross-functional collaboration to identify business issues and optimize assortment. The ideal candidate holds a Bachelor’s degree in a relevant field, 3–5 years of business analysis experience, and strong communication skills.

Qualifications

• In-depth exposure to SQL.
• Ability to write and produce SQL queries for difficult business problems.
• Demonstrated analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Confidence in analytical abilities, able to present and champion optimal assortment decisions.
• Comfortable working with big data to find insights and reach conclusions.
• Basic object oriented programming concepts (loops, if statements, objects, classes, etc.).
• Able to map and trace data from system to system to detect inaccuracies.
• Able to translate complex business processes and data into an easily understandable format.

Responsibilities

• Analyze, mine, and use statistical methods to identify patterns from data regarding our current product assortment.
• Develop reports and presentations leveraging data visualization tools that communicate findings and assortment recommendations to stakeholders.
• Communicate and work cross-functionally with team members to identify business issues.
• Measure and optimize the effectiveness of current product assortment using established and new techniques.
• Develop partnerships with business management teams and participate in weekly category meetings.
• Stay abreast of developments in big data and data analytics.
• Support ad hoc analytic needs as requested.

Skills

SQL

Analytical thinking

Communication

Presentation skills

Big data concepts

Programming basics

Education

Bachelor's Degree in Mathematics, Computer Science, Engineering or related field

Tools

Excel

Python

VBA

Job description

Advance Auto Parts, Inc. is seeking a data analyst to analyze and model product assortment, produce reports, and present insights to key stakeholders.

The role emphasizes SQL, Excel, and big data techniques, with cross-functional collaboration to identify business issues and optimize assortment. The ideal candidate holds a Bachelor’s degree in a relevant field, 3–5 years of business analysis experience, and strong communication skills.