Store Planning Analyst (Store Support Center, Lenexa, KS)

ACE Hardware

129d • $60,000 - $80,000

About The Position

The Store Planning Analyst position at Ace Retail Holdings is responsible for providing highly analytical and detail-driven support to new store acquisitions and store remodel projects. This role involves developing and executing data-informed strategies across the retail footprint, transforming complex data into actionable insights to optimize product placement, fixture planning, and space productivity. The analyst will work closely with various teams to analyze store-level and market performance data, support the development of Excel-based tools, and collaborate on fixture planning and merchandising execution.

Requirements

• BS/BA Degree preferred, or equivalent combination of education and experience.
• 2+ years of experience in retail merchandising, planning, space/floor planning, or data analytics.
• Highly proficient with advanced MS Excel functions.
• Experience with SQL queries and Power BI is a plus.
• Strong analytical, organizational, and communication skills with the ability to manage large data sets and draw actionable insights.
• Experience working cross-functionally with merchandising, operations, and planning teams.
• Ability to manage multiple priorities in a dynamic business environment.
• Demonstrated organizational skills and attention to detail.
• Ability to work independently, be highly self-motivated.

Responsibilities

• Analyze store-level and market performance data to inform category placement, fixture allocation, and footage recommendations for remodel locations.
• Support the development and maintenance of Excel-based tools to evaluate SKU-level assortments, footage, and planogram decisions for assortment strategies.
• Partner with the Sr. Manager to forecast opportunity categories within remodel locations.
• Prepare data sets and reports to support collaboration with Merchandising regarding buybacks, inventory transfers, or product exits.
• Work with the Facilities and Space Planning teams to coordinate fixture planning and merchandising execution.
• Support the Sr. Manager with the execution of store assortment updates in the system.
• Analyze discontinued and obsolete inventory and support profitable exit strategies.
• Build and refine reporting tools to track remodel performance, category and planogram productivity, and floor plan effectiveness.
• Develop dashboards and performance metrics to inform decision-making at both the strategic and tactical levels.
• Help identify AI tools that can improve decision-making and analysis of data.
• Support exit strategy analysis, including financial implications of markdowns, transfers, and discontinued SKUs.
• Collaborate on the refinement of key tools to ensure efficiency and data accuracy.
• Identify opportunities for automation and improved processes related to remodel planning, assortment execution, and reporting.

Benefits

• Advancement Opportunities
• Competitive Wages
• Incentive Award Programs
• Vacation Pay
• Sick Pay
• Paid Holidays
• Bereavement Pay
• Helping Hands
• 401(k) with Company Match
• Benefits (Medical/Dental/Vision & More)
• Associate Assistance Program
• Life Insurance
• Short-Term Disability Benefits
• Training & Development
• Recognition
• Associate Discounts
• Anniversary & Service Awards
• PerkSpot
• Talent Search Referral Bonuses
• Community Service Involvement

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees