How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Job Description – Merchandiser
Job Title
Merchandiser
Department
Merchandising
Reports To
Head of Merchandising
Role Overview
We are looking for a commercially minded 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.
Key Responsibilities
Data Analysis & Reporting
- 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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Process Improvement
- 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.
Size & Fit Analysis
- 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.
Seasonal & Product Performance Analysis
- 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.
Commercial Support
- 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.
Essential Skills & Experience
- 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
- ARRAYFORMULA
- 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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Desirable
- 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.
Key Performance Indicators (KPIs)
- 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.
Personal Attributes
- 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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location