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 experienceCollect & analyze groups of data to look for conclusions, patterns, and potential opportunitiesContinue to streamline, develop, and simplify regular reportingCommunicate findings to cross functional teams conciselyProject Manage macro-analysis needed for quarterly submissions, store relays, special projects, and new stores:
Identify sales opportunities through data analysisAnalyze data to help finalize merchandising and space assortment decisionsExecute the block planning model as needed for Floor Planning projects and new store planningRun models needed to drive data-driven, analytic decisions on store relay projectsCommunicate project status, goals, and objectives to project stakeholdersOther duties as assigned
Minimum Knowledge/Skills/Abilities
Minimum Education
Bachelor’s degree in any of the following disciplines - Finance, Statistics, Analytics, Data Science, or BusinessMinimum Special Certifications or technical skills
Expert level in Excel and AccessAbility to write intermediate or advanced SQL codeAbility to create simple-to-understand visualizations of data using Tableau and/or Power BIMinimum Type of experience the job requires
2-4 years of Advanced Analytics experience creating actionable insightsAbility to manage and analyze data across multiple databases requiredPresent and communicate findings in an actionable and easy to understand formatPreferred Knowledge/Skills/Abilities
Preferred Type of experience
Alteryx experience preferred but not requiredAbility to query in Tableau and/or Power BIRetail analytic experienceApplicants 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 and Michaels.ca. The Michaels Companies, Inc. also owns Artistree, a manufacturer of custom and specialty framing merchandise, and MakerPlace by Michaels, 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 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).
EEOC Know Your Rights Poster in English
EEOC Know Your Rights Poster in Spanish
EEOC Poster Optimized for Screen Readers
Federal FMLA Poster
Federal EPPAC Poster