Stock Coordinator | Décor Brand

Recruit for Africa; Bellville; On-site; ZAR 240,000 - 380,000; Full time

Job summary

Recruit for Africa seeks a Stock Coordinator for a décor brand in Cape Town to ensure national showroom stock is optimized and replenished accurately. The role emphasizes data-driven replenishment decisions, forecasting, and Excel-based planning across multiple showrooms.

The candidate will analyse stock levels, sales and demand to balance availability against excess inventory while maintaining data integrity and meeting tight replenishment deadlines. Immediate start preferred.

Qualifications

• 2–5 years’ experience in stock planning, replenishment, inventory management, merchandise planning or supply chain.
• Strong experience working with large volumes of stock and sales data.
• Advanced Excel skills including Pivot Tables and advanced formulas.
• Ability to translate data into actionable replenishment recommendations.
• Attention to detail and data accuracy.
• Ability to manage competing priorities and meet deadlines.

Responsibilities

• National Stock Replenishment: manage and coordinate national showroom stock replenishment on a daily/weekly basis.
• Demand & Inventory Analysis: analyse historical sales and stock data to identify demand patterns and replenishment trends.
• Stock Performance Monitoring: produce regular reports on showroom stock levels, stock availability and replenishment performance.
• Ensure showrooms receive appropriate stock quantities based on demand, stockholding targets and product availability.
• Identify slow-moving, excess, aged and obsolete stock; take corrective action.
• Investigate discrepancies between forecast demand, actual sales and stock availability.

Skills

Stock replenishment

Inventory management

Advanced Excel

Demand analysis

Data analysis

Large data handling

Tools

Excel

Power Query

Power Pivot

ERP systems

Pivot Tables

Job description

Stock Coordinator | Décor Brand

Upmarket and well-known Home Décor Retail Brand is seeking an experienced STOCK COORDINATOR to join their team in Stickland, Cape Town.

The Showroom Stock Coordinator is responsible for ensuring that all showrooms nationally maintain the right stock, in the right quantities, at the right time.

The role is heavily focused on stock replenishment, inventory optimisation, demand analysis and stock availability, ensuring showroom requirements are accurately translated into replenishment requirements while balancing availability against excess and aged inventory.

The successful candidate will be highly detail-oriented, analytical and commercially minded, with advanced Excel capability and the ability to work confidently with large volumes of data.

The role requires someone who can identify stock requirements proactively, investigate variances, resolve replenishment issues and provide accurate, data-driven recommendations to improve stock availability and inventory efficiency across the showroom network.

Start: Immediate

The main function of the Stock Coordinator job include:

National Stock Replenishment

• Manage and coordinate national showroom stock replenishment on a daily/weekly basis.
• Analyse showroom stock levels, sales, stock movements and demand to determine replenishment requirements.
• Generate and maintain replenishment recommendations in line with agreed processes.
• Ensure showrooms receive appropriate stock quantities based on demand, stockholding targets and product availability.

Demand & Inventory Analysis

• Analyse historical sales and stock data to identify demand patterns and replenishment trends.
• Monitor product-level and showroom-level demand to support accurate stock allocation.
• Identify slow-moving, excess, aged and obsolete stock.
• Highlight stock imbalances and recommend corrective action.
• Analyse stock cover and inventory levels across the showroom network.
• Monitor product availability and identify recurring supply or replenishment issues.
• Investigate discrepancies between forecast demand, actual sales and stock availability.

Stock Performance Monitoring

• Produce regular reports on showroom stock levels, stock availability and replenishment performance.
• Identify trends and exceptions requiring management attention.
• Monitor key inventory measures, including: Stock availability, Out-of-stock levels, Stock cover / weeks of supply, Excess stock, Inventory value, Sales versus stockholding

Advanced Excel capability is essential to the Stock Coordinator role.

The individual will be expected to work confidently with large and complex datasets and use Excel to analyse information, identify trends, build planning tools and support decision-making.

Key Excel requirements for the Stock Coordinator include:

• Advanced use of Pivot Tables and Pivot Charts.
• Advanced formulas including XLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, IF/IFS and nested formulas.

• Data cleansing, manipulation and validation.
• Conditional formatting and exception reporting.
• Building and maintaining planning models and replenishment templates.
• Developing automated or semi-automated reporting solutions.
• Working with large datasets while maintaining data accuracy.
• Identifying and correcting data anomalies and discrepancies.
• Using Excel to model stock requirements, stock cover and replenishment scenarios.
• Experience with Power Query and/or Power Pivot would be highly advantageous.
• Ability to translate complex data into clear, actionable recommendations.

REQUIRED EXPERIENCE & QUALIFICATIONS FOR THE STOCK COORDINATOR

Essential:

• 2–5 years’ experience in stock planning, replenishment, inventory management, merchandise planning or supply chain.
• Strong experience working with large volumes of stock and sales data.
• Demonstrated experience in stock replenishment and inventory optimisation.
• Advanced Excel skills.
• Strong numerical and analytical ability.
• Excellent attention to detail and data accuracy.
• Ability to identify trends, exceptions and potential stock risks.
• Strong organisational and time-management skills.
• Ability to work independently and manage competing priorities.
• Strong communication and stakeholder-engagement skills.
• Ability to work under pressure and meet strict reporting/replenishment deadlines.

Advantageous

• Experience managing stock across a multi-site/showroom network.
• Retail, wholesale, furniture, consumer goods or similar industry experience.
• Experience with ERP, merchandise planning or inventory management systems.
• Power Query / Power Pivot experience.
• Experience developing automated Excel reports or planning models.
• Understanding of forecasting, safety stock, lead times and inventory optimisation.

CORE COMPETANCIES FOR THE STOCK COORDINATOR

Analytical Thinking: Able to interpret large datasets, identify patterns and convert data into practical replenishment decisions.

Attention to Detail: Highly accurate when working with stock quantities, SKUs, locations, reports and replenishment calculations. Able to identify anomalies that others may overlook.

Advanced Excel Capability: Able to build, manipulate and interrogate complex spreadsheets and develop efficient tools to support replenishment and inventory decisions.

Commercial Awareness: Understands the balance between stock availability, customer requirements, inventory investment and working capital.

Problem Solving: Proactively investigates the root cause of stock issues and develops practical solutions rather than simply reporting problems.

Organisation & Planning: Able to manage large volumes of information, multiple locations and recurring replenishment deadlines without compromising accuracy.

Communication: Able to communicate analytical findings and recommendations clearly to both operational and management stakeholders.

Ownership & Accountability: Takes responsibility for replenishment outputs and follows issues through to resolution.

Stock Coordinator salary: Competitive Remuneration: market-related salary package.

We are looking for individuals who can balance the art of retail that loves Home Décor. If you have the wow factor, thrive in dynamic environments, and are ready to make your mark, we want to hear from you.