Role Overview
This is an excellent opportunity for a highly analytical and commercially minded professional with advanced Excel and data analysis skills to join a fast-growing online retail business.
Working closely with the Senior Leadership Team, the successful candidate will analyse sales performance across more than 8,000 product lines, providing insight-driven recommendations on stock planning, purchasing strategies, and future product development to support continued business growth.
Key Responsibilities
- Manage the end-to-end purchasing process across an extensive product portfolio.
- Analyse sales performance across more than 8,000 product lines to identify trends, opportunities, and areas for improvement.
- Produce detailed reports, forecasting models, and commercial insights to support purchasing and stock planning decisions.
- Forecast future product demand using historical sales data, seasonal trends, and market intelligence.
- Recommend future product ranges, stock levels, and purchasing strategies based on performance analysis.
- Develop and maintain advanced Excel reports, dashboards, Pivot Tables, and forecasting tools.
- Monitor product profitability, stock turnover, and sales performance to optimise commercial outcomes.
- Work closely with senior management to provide data-driven recommendations that support business growth.
- Build and maintain strong supplier relationships across the UK and Europe.
- Negotiate pricing, lead times, and supply agreements to ensure best value for the business.
- Coordinate purchase orders and supplier deliveries to maintain stock availability.
- Identify opportunities to introduce new product lines based on customer demand and market trends.
- Support supplier reviews and product range evaluations through performance reporting and analysis.
- Continuously review purchasing processes and reporting methods to improve efficiency and decision-making.
- Utilise Microsoft Navision, Volo Commerce, and Microsoft Excel to manage purchasing, inventory, and performance data.
Skills & Experience
- Previous experience in purchasing, procurement, buying, merchandising, stock planning, commercial analysis, inventory planning, or supply chain roles.
- Advanced Microsoft Excel skills, including Pivot Tables, VLOOKUP/XLOOKUP, reporting, forecasting, and data analysis.
- Strong analytical and numerical abilities with experience interpreting large data sets and translating findings into commercial recommendations.
- Experience producing management reports, sales analysis, performance dashboards, and forecasting models.
- Proven ability to analyse sales trends and make commercially sound purchasing recommendations.
- Strong commercial awareness with an understanding of stock management, product performance, and profitability.
- Excellent attention to detail and organisational skills.
- Ability to manage and prioritise multiple projects within a fast-paced environment.
- Strong communication skills with the confidence to present findings and recommendations to senior stakeholders.
- Experience using ERP systems, ideally Microsoft Navision or similar platforms.
- Experience within retail, e-commerce, wholesale, distribution, or product-based environments would be highly advantageous.
- A proactive and solutions-focused approach with a passion for data-driven decision-making.
Offering
- Full-time, permanent position based in Lanarkshire.
- 40-hour working week with flexible start and finish times.
- Salary up to £35,000 depending on experience.
- 29 days annual leave.
- Generous staff discount across an extensive product range.
- Opportunity to work within a fast-growing and ambitious business.
- Exposure to international suppliers and product sourcing opportunities.
- Supportive and collaborative working environment.
- Career development opportunities with genuine progression potential.
- Opportunity to directly influence purchasing strategy and future product development through data-driven insight.
