M
Michaels Stores
Posted 138 days agoVerified live 1d ago

Merchandising Data Analyst

Brief overview

Irving-Irving Corporate Office-3939 West John Carpenter Freeway, USIn-person
UndergradOr in progress
2+ yrsMinimum
122 H-1B approvalsDept. of Labor
45 green cardsCertified filings
Data discoveryData analysisRetail analyticsMerchandisingBusiness intelligenceAdvanced SQLPower BIDAXVBA programmingReport automationDashboard developmentKPI trackingDemand forecastingSupply chain analysisConsumer behavior analysisFloor layout optimizationData-driven decision making

About the company

M
Michaels Storesteachitpro.com

At The Michaels Companies Inc., our purpose is to fuel the joy of creativity and celebration.

Visa sponsorship history

4 years sponsoring, last filed FY2026

Data powered by U.S. Department of Labor. This does not guarantee sponsorship for this specific role.
122H-1B approved
98%approval rate
14new H-1B hires
45PERM certified
$145,000median wage / yr
H-1B Petition ApprovalsVisas USCIS actually granted: the strongest sign the company sponsors.
202342
202447
202527
20266
LCA Certified ApplicationsAn early filing step, not a visa approval: it signals intent, not confirmed sponsorship.
20238
202417
20257
20264
Green Card (PERM) FilingsCertified green card filings: a long-term commitment to international hires.
202338
20251
20266
Top sponsored roles
Senior DeveloperSoftware Development Engineer Back End 3Senior Software EngineerStaff Software EngineerSr. Application Developer
Sponsored employees from
ChinaIndiaPhilippinesMexico

Job description

Summary

Michaels Stores is a leading destination for creativity and celebration in North America, operating over 1,300 stores. They are seeking a Merchandising Data Analyst to transform raw retail data into actionable inventory strategies, analyze sales trends, and support product performance through data-driven insights.

Responsibilities

  • Responsible for data discovery and turning raw data into logical information for recurring and ad-hoc merchandising reports
  • Maintain dashboards that track Key Performance Indicators (KPIs) such as Sell-Through Rate, GMROI, and Stock-to-Sales ratios
  • Assist with the design and development of interactive dashboards and reports in Power BI to support daily business decisions
  • Identify emerging consumer patterns and "bestsellers" to influence future buying decisions and markdown strategies
  • Partner with the Planning team to forecast demand, helping to prevent overstock situations and minimize "out-of-stock" lost revenue
  • Perform analysis on supply chain subject areas to identify insights and support fact-based decision making
  • Deliver data-driven insights on space performance to enable merchants in optimizing floor layouts and increasing overall store productivity
  • Collect and process business data to identify trends and issues that improve performance and support scalable analytical solutions
  • Provide on-demand support to Buyers and Planners needing help navigating reporting systems
  • Use technical expertise to support new process design and report automation, reducing manual data entry for the broader team
  • Other duties as assigned

Skills

  • Bachelor's Degree or Professional Certificate in Data Analytics, Data Mining, Data Science, or a related field
  • 2–4 years in retail analytics, merchandising, or business intelligence
  • 2+ years of experience with MS Excel (Power Query, Pivot Tables, interactive dashboards, and custom functions)
  • At least 2 years of experience writing advanced SQL queries
  • At least 1 year of experience with Power BI desktop/service and writing basic DAX
  • At least 1 year of experience in VBA programming for Excel/Access automation
  • Interest in retail trends and consumer behavior

Qualifications

Must Haves

  • Bachelor's Degree or Professional Certificate in Data Analytics, Data Mining, Data Science, or a related field
  • 2–4 years in retail analytics, merchandising, or business intelligence
  • 2+ years of experience with MS Excel (Power Query, Pivot Tables, interactive dashboards, and custom functions)
  • At least 2 years of experience writing advanced SQL queries
  • At least 1 year of experience with Power BI desktop/service and writing basic DAX
  • At least 1 year of experience in VBA programming for Excel/Access automation
  • Interest in retail trends and consumer behavior

Benefits

  • Health insurance (medical, dental, and vision)
  • Paid time off
  • Tuition assistance
  • Generous employee discounts

More jobs like this