"Alerted.org

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

+ 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 Python/R coding skills preferred

+ Intermediate understanding of DAX and Power BI preferred

+ Retail analytic experience preferred

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** . As the leading creative destination in North America, we operate over 1,300 stores in 49 states and Canada and online at Michaels.com (http://www.michaels.com./) and Michaels.ca . The Michaels Companies, Inc. also owns Artistree, a manufacturer of custom and specialty framing merchandise, and MakerPlace by Michaels (https://www.michaels.com/makerplace) , a dedicated handmade goods marketplace. 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 mikbenefits.com .

Michaels is an Equal Opportunity Employer. We are here for all Team Members and all** **c** **ustomers** **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)._

EEOC Know Your Rights Poster in English (https://www.eeoc.gov/sites/default/files/2022-10/22-088\_EEOC\_KnowYourRights\_10\_20.pdf)

EEOC Know Your Rights Poster in Spanish

EEOC Poster Optimized for Screen Readers (https://www.eeoc.gov/sites/default/files/2022-10/EEOC\_KnowYourRights\_screen\_reader\_10\_20.pdf)

Federal FMLA Poster

Federal EPPAC Poster (https://www.dol.gov/sites/dolgov/files/WHD/legacy/files/eppac.pdf)