Merchandising Data Analyst

Major Activities

• Performance Reporting & Discovery Reporting
• 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
• 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.
• Quantitative Deep-Dives: Perform analysis on supply chain subject areas to identify insights and support fact-based decision making.

Process & Collaboration Space

• Productivity: Deliver data-driven insights on space performance to enable merchants in optimizing floor layouts and increasing overall store productivity.
• Process Improvement: Collect and process business data to identify trends and issues that improve performance and support scalable analytical solutions.
• Cross-Functional Support: Provide on-demand support to Buyers and Planners needing help navigating reporting systems.

Technical Expertise

• 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.

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.
• Other Interest: In retail trends and consumer behavior.

Pay

Details about pay are not specified in the job posting.

Schedule

Details about schedule are not specified in the job posting.

Benefits

Details about benefits are not specified in the job posting.

Skills

Details about skills are not specified in the job posting.

Qualifications

Details about qualifications are not specified in the job posting.

Requirements

Details about requirements are not specified in the job posting.

Benefits

Details about benefits are not specified in the job posting.

Pay

Details about pay are not specified in the job posting.

Schedule

Details about schedule are not specified in the job posting.

Application Instructions

Application instructions are not specified in the job posting.