Data-Driven Retail Assortment Strategist

DotActiv; Johannesburg; On-site; ZAR 223,000 - 335,000; Full time

Benefits offered by this job

Laptop allowance

CTC package

Job summary

DotActiv is seeking data-driven Assortment Planners to shape how retailers choose and display products. You will perform analytical heavy lifting behind product selection, ensuring each SKU earns its place on the shelf.

The role requires a Consumer Science or Commerce degree, advanced Excel, and 2+ years in retail. You’ll travel on-site to meet clients and work with DotActiv’s category management software to optimize ranges and space.

Qualifications

• Consumer Science or Commerce degree from an accredited university.
• Advanced MS Excel skills with complex formulas, VLOOKUPs, and Pivot Tables.
• Proficient English (written and spoken) at business level.
• 2+ years in a retail environment is advantageous.
• Willingness to travel on-site to meet clients.
• Laptop with Windows; DotActiv software requires Windows.

Responsibilities

• Strategic Assortment Planning: Using specialized software to create data-driven assortment plans that balance consumer demand with physical space constraints.
• Cluster Analysis: Analyse cluster plans per product category to optimise the ranges within the clusters.
• The Right Product Mix: Ensuring the ideal variety and breadth of products are available at the right locations to meet shopper needs and preferences.
• Performance Analysis: Maximizing category performance by analyzing product financial performance and shopper psychology.
• SKU Rationalization: Identifying high-performing products and opportunity gaps within a range.
• Client Advisory: Supporting and guiding retail customers through complex data-driven recommendations that drive sales and profitability.

Skills

Data analysis

Advanced MS Excel

Analytical thinking

Retail analytics

Problem-solving

Education

Consumer Science or Commerce degree

Tools

Excel (advanced)

Pivot Tables

VLOOKUP

Job description

DotActiv is seeking data-driven Assortment Planners to shape how retailers choose and display products. You will perform analytical heavy lifting behind product selection, ensuring each SKU earns its place on the shelf.

The role requires a Consumer Science or Commerce degree, advanced Excel, and 2+ years in retail. You’ll travel on-site to meet clients and work with DotActiv’s category management software to optimize ranges and space.