Supply Chain Analyst - Inventory Optimization

Placements24; Queenstown; On-site; NZD 38,000 - 60,000; Full time

Benefits offered by this job

Competitive salary

Performance-based increases

Medical aid & retirement contributions

Training & development

Regional impact in Queenstown

Job summary

Placements24 is seeking a Supply Chain Analyst to optimize FMCG inventory within the Queenstown/Eastern Cape region. You will analyze inventory, identify trends, and develop strategies to minimize stockouts while reducing excess inventory costs.

You will build and monitor KPIs, forecast demand, and collaborate with procurement and logistics to ensure timely replenishment. Proficiency in Excel, SQL, Power BI, and Tableau is valued, along with a relevant quantitative degree and 1–3 years of

Qualifications

• Bachelor's degree in a quantitative field (Supply Chain, Logistics, IE, Statistics)
• 1–3 years in supply chain analysis, inventory management, or FMCG
• Strong Excel skills with pivot tables and VLOOKUP; SQL/Power BI/Tableau a plus

Responsibilities

• Analyze inventory data across multiple locations in the Eastern Cape to identify patterns and risks
• Develop and implement inventory optimization strategies to improve stock availability and reduce costs
• Monitor inventory, forecast demand, and coordinate with procurement and logistics for timely replenishment
• Identify root causes of inventory discrepancies and implement corrective actions
• Develop and maintain KPIs such as turnover, stockouts, and carrying costs
• Use data analysis tools to provide insights and recommendations for SCM improvements
• Support development of inventory management systems and processes
• Collaborate with sales, operations, and finance to align inventory strategies
• Prepare regular reports on inventory performance and present findings to management
• Assist in development of supply chain models and scenario planning

Skills

Analytical thinking

Attention to detail

Team collaboration

Communication

Education

Bachelor's degree in a quantitative field

Tools

Excel ( Pivot, VLOOKUP )

SQL

Power BI

Tableau

Job description

About the Role

Our client, a significant player in the Fast-Moving Consumer Goods (FMCG) industry, is looking for a detail-oriented and analytical Supply Chain Analyst to focus on inventory optimization. This role is based in Queenstown, Eastern Cape, a strategic location for distribution within the province. You will be responsible for analyzing inventory levels, identifying trends, and developing strategies to minimize stockouts while reducing excess inventory costs. The ideal candidate will possess strong quantitative skills, a solid understanding of supply chain principles, and proficiency in data analysis tools. This is an excellent opportunity for an analyst to make a tangible impact on operational efficiency and profitability within a growing FMCG business. Our client is committed to fostering a data-driven culture and supports professional development. Working from Queenstown offers a unique opportunity to contribute to regional economic growth within the Eastern Cape. Join our client and play a key role in optimizing their supply chain.

Key Responsibilities

• Analyze inventory data across multiple locations within the Eastern Cape to identify patterns, trends, and potential risks.
• Develop and implement inventory optimization strategies to improve stock availability and reduce holding costs.
• Monitor inventory levels, forecast demand, and collaborate with procurement and logistics teams to ensure timely replenishment.
• Identify root causes of inventory discrepancies and implement corrective actions.
• Develop and maintain key performance indicators (KPIs) related to inventory management, such as inventory turnover, stockout rates, and carrying costs.
• Utilize data analysis tools and techniques to provide insights and recommendations for supply chain improvements.
• Support the development and implementation of inventory management systems and processes.
• Collaborate with cross-functional teams, including sales, operations, and finance, to align inventory strategies with business goals.
• Prepare regular reports on inventory performance and present findings to management.
• Assist in the development of supply chain models and scenario planning.

Requirements

• A Bachelor's degree in Supply Chain Management, Logistics, Industrial Engineering, Statistics, or a related quantitative field.
• 1-3 years of experience in supply chain analysis, inventory management, or a related role, preferably in the FMCG sector.
• Strong analytical and problem-solving skills with a keen eye for detail.
• Proficiency in Microsoft Excel, including advanced functions (e.g., pivot tables, VLOOKUPs).
• Familiarity with data analysis tools and techniques (e.g., SQL, Power BI, Tableau) is a plus.
• Understanding of inventory management principles and supply chain concepts.
• Good communication and interpersonal skills, with the ability to work effectively in a team.
• Ability to work independently and manage multiple tasks.
• Must reside in or be willing to relocate to Queenstown or surrounding areas within the Eastern Cape.
• Eagerness to learn and grow within the FMCG supply chain domain.

Benefits

• A competitive annual salary of R, commensurate with experience.
• Opportunities for performance-based increases and professional growth.
• Company-sponsored medical aid and retirement fund contributions.
• A challenging and rewarding role focused on optimization.
• Supportive work environment in Queenstown, Eastern Cape.
• Training and development opportunities in supply chain analytics.
• Exposure to diverse inventory management challenges in the FMCG sector.
• Contribute to efficiency and cost savings for a reputable company.