Sr. Assortment Planner

Advance Auto Parts; Raleigh (NC); On-site; USD 70,000 - 110,000; Full time

Job summary

Advance Auto Parts is seeking a data analytics professional to analyze patterns in our product assortment and develop clear reports for stakeholders. You will work cross-functionally to identify business issues, measure effectiveness, and propose optimization strategies using both established and innovative techniques.

The role requires strong SQL, Excel, and Python skills, plus experience with data visualization tools to illustrate recommendations.

Qualifications

• Bachelor's degree in Mathematics, Computer Science, Engineering or other relevant discipline
• 3-5 Years Business Analyst Experience or related field
• Intermediate to Advanced SQL Skills
• Intermediate to Advanced Excel Skills
• Proven Communication and Presentation Skills
• Track Record of Analytics Projects
• Basic Programming Language Skills in Python or VBA

Responsibilities

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

Skills

SQL

Data visualization

Analytical skills

Python

Excel

Communication

Big data

Education

Bachelor's degree in Mathematics/CS/Engineering

Tools

Tableau

Power BI

Job description

Job Description

• Analyze, mine, and use statistical methods to identify patterns from various data points regarding our current product assortment
• Develop reports and/or presentations leveraging data visualization tools that clearly and concisely communicate analytical findings and assortment recommendations to key stakeholders
• Able to communicate and work cross-functionally with team members to identify existing business issues
• Measure and optimize the effectiveness of current product assortment, deploying both established and groundbreaking techniques
• Develop strong partnerships with business management teams and participate in weekly category meetings
• Maintain knowledge and stay abreast of developments in the field of big data and data analytics
• Support ad hoc analytic needs as requested

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. General knowledge of loops, if statements, objects, classes, etc.
• Able to map and trace data from system to system in order to detect inaccuracies
• Able to translate complex business processes and data into an easily understandable format

The Ideal Candidate

• Bachelor's Degree in Mathematics, Computer Science, Engineering or other relevant discipline
• 3-5 Years Business Analyst Experience or related field
• Intermediate to Advanced SQL Skills
• Intermediate to Advanced Excel Skills
• Proven Communication and Presentation Skills
• Track Record of Analytics Projects
• Basic Programming Language Skills in Python or VBA

We comply with all applicable federal, state, and local laws.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age national origin, religion, sexual orientation, gender identity, status as a veteran and basis of disability or any other federal, state or local protected class.