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