Space Planning Analyst

Support Center - Irving

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.

Major Activities

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

Minimum Knowledge/Skills/Abilities

Minimum Education

• Bachelor's degree in any of the following disciplines - Finance, Statistics, Analytics, Data Science, or Business

Minimum Special Certifications or technical skills

• Expert level in Excel and Access
• Ability to write intermediate or advanced SQL code
• Ability to build, maintain and debug Power BI dashboards

Minimum Type of experience the job requires

• 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

Preferred Knowledge/Skills/Abilities

Preferred Type of experience

• Intermediate Phyton/R coding skills
• Intermediate understanding of DAX and Power BI
• Retail analytic experience

Applicants in the U.S. must satisfy federal, state, and local legal requirements of the job.

At The Michaels Companies Inc., our purpose is to fuel the joy of creativity and celebration. As the leading destination for creating and celebrating in North America, we operate over 1,300 stores in 49 states and Canada and online at Michaels.com "and" Michaels.ca ."The Michaels Companies, Inc. also owns Artistree, a manufacturer of custom and specialty framing merchandise. Founded in 1973 and headquartered in Irving, Texas, Michaels is the best place for all things creative. For more information, please visit" www.michaels.com .

At Michaels, we prioritize the wellbeing of our teams by providing robust benefits for both full-time and part-time Team Members. Our benefits include health insurance (medical, dental, and vision), paid time off, tuition assistance, generous employee discounts, and much more. For more information, visit www.michaels.com .

Michaels is an Equal Opportunity Employer. We are here for all Team Members and all customers to create, innovate and be better together.

Michaels is committed to the full inclusion of all qualified individuals. In keeping with this commitment, Michaels will assure that people with disabilities are provided reasonable accommodations. Accordingly, if a reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the job, and/or to receive all other benefits and privileges of employment, please contact Customer Care at 1-800-642-4235 (1800-MICHAEL).