Space Planning Analyst
About The Position
The Space Planning Analyst applies advanced analysis to specific planogram/modular and market performance that will drive actionable recommendations for future planning and decision making. Through the understanding of business and select store performance, the Space Planning Analyst will apply a mix of quantitative and qualitative skills to create reports and tools used by the organization on a regular basis in critical space planning sessions. This Team Member will also serve as a lead analyst for various projects centered around the impact of various strategic levers on productivity and sales, ranging from Basic and Seasonal planograms/modulars to store relays to select store tests to store level SKU rationalization.
Requirements
- Minimum Education Bachelor’s degree in any of the following disciplines - Finance, Statistics, Analytics, Data Science, or Business
- Expert level in Excel and Access
- Ability to write intermediate or advanced SQL code
- Ability to build, maintain and debug Power BI dashboards
- 2-4 years of Advanced Analytics experience creating actionable insights
- Ability to manage and analyze data across multiple databases required
- Present and communicate findings in an actionable and easy to understand format
Nice To Haves
- Intermediate Phyton/R coding skills
- Intermediate understanding of DAX and Power BI
- Retail analytic experience
Responsibilities
- Analyze sales, gross margin, & Space productivity performance at a SKU, POG or Department level: Mine large & complex data sets using SQL & various tools to drive sales & margin.
- Solve Planogram & Space opportunities through clustering & modeling to maximize sales and customer space/shopping experience
- Collect & analyze groups of data to look for conclusions, patterns, and potential opportunities
- Continue to streamline, develop, and simplify regular reporting
- Communicate findings to cross functional teams concisely
- Project Manage macro-analysis needed for quarterly submissions, store relays, special projects, and new stores: Identify sales opportunities through data analysis
- Analyze data to help finalize merchandising and space assortment decisions
- Execute the block planning model as needed for Floor Planning projects and new store planning
- Run models needed to drive data-driven, analytic decisions on store relay projects
- Communicate project status, goals, and objectives to project stakeholders
- Other duties as assigned
Benefits
- health insurance (medical, dental, and vision)
- paid time off
- tuition assistance
- generous employee discounts
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
