Merchandiser Data Analyst

Job Description – Data Analyst & Merchandiser Job Title Data Analyst & Merchandiser Department

Merchandising

Head of Merchandising

We are looking for a commercially minded Data Analyst & Merchandiser to join our Merchandising team. This role will be responsible for transforming data into actionable insights that drive better commercial decisions across our eCommerce business.

The successful candidate will analyse trading performance, develop automated reporting, improve data processes using automated reporting, and support the merchandising team with in-depth analysis of product, customer and inventory performance. They will also be responsible for maintaining accurate online merchandising, ensuring products are optimised across the Shopify website and supporting seasonal planning through detailed reporting and analysis.

This is an ideal opportunity for someone who enjoys combining analytical thinking with commercial decision-making and is passionate about improving efficiency through technology and automation.

• Develop, maintain and continuously improve trading reports and dashboards.

• Analyse sales, inventory and profitability to identify commercial opportunities and risks.

• Build automated reporting solutions using Google Sheets
  , and reporting software to reduce manual processes.

• Create daily, weekly and monthly performance reports for the merchandising and leadership teams.

• Identify trends, anomalies and actionable insights to support trading decisions.

• Produce post-season reviews and performance summaries with clear recommendations.

• Identify opportunities to automate reporting and repetitive merchandising tasks using google sheets or power BI

• Build and maintain automated reporting workflows.

• Improve data accuracy and reporting efficiency through automation.

• Introduce new reporting methods that enable faster commercial decision-making.

• Analyse sales by size to identify demand patterns and opportunities.

• Monitor size sell-through and stock availability.

• Produce size curve recommendations for future buys.

• Highlight sizing issues affecting conversion or customer returns.

• Support buying and merchandising teams with size planning recommendations.

• Produce seasonal performance reviews by category, product and collection.

• Analyse sell-through, markdown performance and stock efficiency.

• Review newness performance and identify opportunities for future range planning.

• Analyse lifecycle performance from launch through end-of-season.

• Provide recommendations for future assortment planning.

• Support weekly trade meetings with meaningful commercial insights.

• Assist in forecasting sales and inventory performance.

• Work closely with Merchandising, Buying, Digital Marketing and Finance.

• Help identify opportunities to improve sales, margin and inventory productivity.

• Experience in a data analyst, merchandising analyst or online merchandising role.

• Strong analytical skills with the ability to interpret large datasets.

• Advanced knowledge of Google Sheets
  , including:

  • QUERY

  • ARRAY FORMULA

  • FILTER

  • INDEX/MATCH

  • XLOOKUP

  • Pivot Tables

  • Dashboards

• Experience using Shopify
  .

• Excellent Excel skills.

• Strong commercial awareness within retail or fashion.

• Ability to present data clearly and communicate insights to non-technical stakeholders.

• Highly organised with excellent attention to detail.

• Knowledge of Looker Studio, Power BI or Tableau.

• SQL knowledge.

• Experience with Google Analytics (GA4).

• Understanding of inventory planning and merchandising principles.

• Experience working with APIs or automated data integrations.

• Accuracy and timeliness of reporting.

• Reduction in manual reporting through automation.

• Improvement in reporting efficiency.

• Increased visibility of key trading metrics.

• Accuracy of size recommendations.

• Quality of seasonal analysis and commercial recommendations.

• Improvement in stock productivity and sell-through.

• Stakeholder satisfaction with reporting and insights.

• Naturally curious with a passion for solving problems through data.

• Commercially minded with an interest in fashion and retail.

• Proactive and continually looking for ways to improve processes.

• Comfortable working with large volumes of data.

• Strong communication and presentation skills.

• Able to manage multiple priorities in a fast-paced environment.

• Collaborative team player who enjoys working cross-functionally.