Merchandising Analytics in Raleigh, NC at Advance Auto Parts

Date Posted: 3/28/2020

Career Snapshot

  • Employee Type:
  • Location:
    Raleigh, NC
  • Career Type:
  • Experience:
    Not Specified
  • Date Posted:

Career Description

Job Description


Join the AAP Merchandise Analytics team and help shape the future of automotive retail.  You will be part of a world-class data science and data analytics team designed to disrupt a $150B auto parts industry.

As our Assortment Data Analyst you will have access to the latest cloud computing technology to help solve assortment issues, be empowered to drive assortment decisions, explore data to find trends and correlations, and partner with our category management teams to build and deliver the best assortment possible to ensure we have the right parts in the right place at the right time.

Essential Duties and Responsibilities

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


In-depth exposure to SQL.  Ability to write and produce SQL queries for difficult business problems.

Strong 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