Store Planning Analyst

The Store Planning role analyzes store productivity by identifying opportunities to improve sales & GMROI performance and providing data-driven recommendations that optimize store space utilization. This role is responsible for reporting, analytics, and performance measurements across the store fleet, helping business partners understand where stores are underperforming and developing recommendations to improve productivity. The ideal candidate is highly analytical, advanced Excel skills, enjoys working with data, and can translate insights into meaningful business recommendations. Experience with retail merchandising, store operations, space planning, or CAD tools is a plus.
What you will do
STORE PRODUCTIVITY ANALYSIS
Analyze store productivity metrics, including sales per square foot, merchandise performance, category productivity, and space utilization.
Identify underproductive stores, departments, and categories through data analysis and performance reporting.
Develop recommendations to improve sales productivity and optimize store space allocation.
Monitor performance trends and provide insights to support strategic business decisions.
REPORTING & ANALYTICS
Create and maintain recurring reports, dashboards, floor plans and scorecards that measure store and merchandising performance.
Compile, validate, and analyze data from multiple sources to support planning initiatives.
Develop ad hoc analyses and presentations for Store Planning, Merchandising, and Field Leadership teams.
Translate complex data into clear and actionable business insights.
PARTNERSHIP
Partner with Merchandising, Finance, and Field teams to understand performance opportunities and business needs.
Support merchandise planning discussions by providing data-backed recommendations.
Assist with store layout reviews and space productivity analyses.
Participate in special projects related to store growth, remodels/consolidations, store openings/closings, productivity improvement initiatives and other company priorities.
STORE PLANNING SUPPORT
Assist with measuring and maintaining store square footage and space allocation records.
Support store layout and floor plan updates as needed.
Help evaluate space productivity and recommend adjustments to improve overall store performance
Utilize CAD tools and store planning software when applicable.
Completes ad hoc tasks as assigned.
Education Qualifications
Bachelor's Degree business, finance, operations, or other related field Preferred
Experience Qualifications
1-3 years Retail analytics, store planning, merchandising, business analysis or related field Required
Skills and Abilities
Advanced Excel skills, including pivot tables, VLOOKUPs, and other complex formulas
Strong analytical and problem solving skills
Ability to work with large data sets and identify meaningful business insights
Strong communication skills
Detail oriented with excellent organizational skills
Experience in retail, merchandising, store operations or space planning
Knowledge of CAD software for store measurements and floor plan analysis
Understanding of retail KPIs such as sales per square foot, inventory productivity, and category performance
Merchant or merchandising background
Requires designated hybrid in-office work schedule.
* The job posting highlights the most relevant / essential responsibilities and requirements of the role. It is not all-inclusive. There may be additional duties, responsibilities, and qualifications for this job.