Senior Analyst, Assortment Planning

NAPA; Atlanta (GA); On-site; USD 90,000 - 130,000; Full time

Job summary

Genuine Parts Company is seeking a Sr Analyst, Assortment Planning to support Category Managers with insights and recommendations on assortment and inventory mix across Company Owned & Independent NAPA stores and distribution centers. You will work with Category Managers to optimize assortment decisions and balance forecasted demand with inventory and space efficiency.

The role emphasizes analytics, process development, and building tools with the Sr Director and cross-functional teams to ensure

Qualifications

• 3+ years of analytics and process improvement experience.
• Strong proficiency with Excel and BigQuery.
• Experience with merchandising and assortment modeling applications.
• Excellent communication and collaboration skills; able to present to leadership.
• Bachelor’s degree in Business, Analytics or related field.
• Willingness to travel as needed.

Responsibilities

• Perform deep-dive inventory productivity analyses by location and SKU.
• Identify space distribution opportunities across categories.
• Develop & refine cross-functional review model for assortment decisions.
• Create post-review SKU add analytics to assess incrementality.
• Support forecasts by SKU to Inventory Planning and Replenishment.
• Help build onboarding and training programs for the new team.
• Collaborate with Supply Chain Strategy to build tools and analyze results.

Skills

Excel

BigQuery

Power BI

Merchandising knowledge

Assortment modeling

Education

Bachelor's degree in Business, Analytics or related

Tools

Power BI

BigQuery

SQL

Job description

Position Mission:

The Sr Analyst, Assortment Planning will provide dedicated support to Category Managers with insight, guidance and recommendations on assortment and inventory mix to maximize sales while balancing inventory and space productivity in Company Owned & Independent NAPA stores and distribution centers. The role will report to the Sr Manager, Assortment Planning, will utilize existing tools and help build new tools, processes and analyses to provide clarity on current state and recommend optimization of future assortments. The role will work directly with Category Managers to optimize assortment decisions. Through a prioritized set of reviews as well as a continuous review process the Sr Analyst will balance market demand, supplier recommendations, field & independent store owner feedback and predictive analytics along with line structure/life cycle management, store clustering and new product introduction methodologies to produce a best in class assortments. The Sr Analyst will also act as liaisons between the Category Management and Modeling team to ensure that Category role and intent are well defined, understood and executed by all parties.

Detailed Position Description:

• Analytics (60%)
  • Deep dive inventory productivity including Category line structure, potential and actual sales and inventory levels by location and SKU to help understand correct product mix
  • Identify opportunities to properly distribute space by and within Categories to allow for optimal mix across the enterprise
  • Assist in ongoing development of cross-functional review model including analytics to help Category Managers and Operators understand and optimize exit strategy cost and optimal timing of new product introductions
  • Build post-review SKU add analytics to help Category Managers understand incrementality and cannibalization of their assortment decisions
  • Assist Category Managers in providing forecasts by SKU to Inventory Planning and Replenishment team to ensure proper fill rates and service levels
• Process Creation/Change Management (30%)
  • Working directly with Sr Director, Assortment Planning and Category Management leadership, create streamlined, repeatable processes for Business Reviews and Assortment recommendations including documentation and collection of all data points needed to assort/de-assort SKUs
  • Assist in ensuring all projects are on track to be completed on time including communicating with cross-functional teams to move projects through the review process
  • Help create and refine process to translate assortment recommendations from Business Reviews to Division Modelers and Inventory Planning associates to properly place and support ongoing replenishment of SKUs
  • Partner with Supply Chain Strategy & Analytics team to refine/build tools needed to make proper assortment decisions and analyze results
• Build and Manage Assortment Planning Organization (10%)
  • Assist Sr Manager and Sr Director in building onboarding and training program, for this new team based on all of the work streams outlined above.
  • Monitor new tools and processes for opportunities to improve and build a culture of excellence around Assortment Planning principles

Key Performance Metrics:

• Company Owned and Independent Store Sales Inventory productivity including increasing inventory turnover while reducing underperforming inventory and returns
• Expense reduction associated with excess returns

Experience, Education, and Abilities:

• 3+ years of Analytics and Process Improvement experience required
• Possesses the following technical proficiencies:
  • Very strong analytical skills, highly competent using tools such as Excel and Big Query
  • Well versed in analytics visualization tools (Power BI in particular)
  • Prior knowledge of merchandising and assortment modeling applications/tools preferred
• Background in the following process improvement capabilities:
  • Ability to quickly identify, recommend solutions for and execute on process opportunities/gaps
  • Possesses strong communication, collaboration, and presentation skills including:
    • Using PowerPoint to create materials for leadership and cross-functional meetings
    • Ability to make compelling presentations to small and large groups
    • Comfortable communicating with leadership in large organizations
  • Bachelors degree in Business, Analytics, Process Improvement or equivalent experience required
  • Ability to manage complex analytical and process improvement projects while demonstrating a positive, collaborative approach with fellow associates across the organization
  • High degree of business acumen with the ability to influence at all levels of the organization, balancing multiple stakeholder imperatives
  • Work is performed in a typical office environment. Ability to travel when called upon.

GPC conducts its business without regard to sex, race, creed, color, religion, marital status, national origin, citizenship status, age, pregnancy, sexual orientation, gender identity or expression, genetic information, disability, military status, status as a veteran, or any other protected characteristic. GPC's policy is to recruit, hire, train, promote, assign, transfer and terminate employees based on their own ability, achievement, experience and conduct and other legitimate business reasons. Since 1928, GPC has set the standards for performance and value for our customers and our stakeholders. Today, we’re proud to say we’re the largest global auto parts network and a leading industrial parts distributor, one that offers rewarding careers that combine small company feel with a global scale. Our strengths are in the relationships we build and the value we deliver by merging local expertise with a global force.