Merchandising Data Analyst

Support Center - IrvingWe are looking for a Merchandising Data Analyst to transform raw retail data into actionable inventory strategies. You will be the engine behind our product performance, analyzing sales trends, seasonal fluctuations, and stock levels to ensure we have the right products in the right places at the right time.

Major Activities

Performance Reporting & Discovery

• Reporting Ownership: Responsible for data discovery and turning raw data into logical information for recurring and ad-hoc merchandising reports.
• KPI Tracking: Maintain dashboards that track Key Performance Indicators (KPIs) such as Sell-Through Rate, GMROI, and Stock-to-Sales ratios.
• Dashboard Support: Assist with the design and development of interactive dashboards and reports in Power BI to support daily business decisions.

Trend & Inventory Analysis

• Trend Analysis: Identify emerging consumer patterns and "bestsellers" to influence future buying decisions and markdown strategies.
• Inventory Optimization: Partner with the Planning team to forecast demand, helping to prevent overstock situations and minimize "out-of-stock" lost revenue.
• Quantitative Deep-Dives: Perform analysis on supply chain subject areas to identify insights and support fact-based decision making.

Process & Collaboration

• Space Productivity: Deliver >

  Preferred Education/Experience

  • Bachelor’s Degree or Professional Certificate in Data Analytics, Data Mining, Data Science, or a related field.

  Minimum Type of Experience Required

  • 2–4 years in retail analytics, merchandising, or business intelligence.

  Technical Skills:

  • Excel Mastery: 2+ years of experience with MS Excel (Power Query, Pivot Tables, interactive dashboards, and custom functions).
  • SQL: At least 2 years of experience writing advanced SQL queries.
  • Power BI: At least 1 year of experience with Power BI desktop/service and writing basic DAX.
  • VBA: At least 1 year of experience in VBA programming for Excel/Access automation.

  Other

  • Interest in retail trends and consumer behavior.

  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 customersto 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