Manager, Inventory Planning Optimization

MR DIY TRADING SDN BHD; Seri Kembangan; On-site; MYR 60,000 - 80,000; Full time

Job summary

A leading retail company in Malaysia is seeking an experienced professional for category optimization and stock allocation. The role requires a Bachelor's degree and a minimum of 5 years of experience in category management or supply chain roles. Candidates must be proficient in data analysis tools like Excel and Power BI, and possess strong analytical and communication skills to drive data-driven decisions.

Qualifications

• Minimum 5 years in category management, assortment planning, allocation, or supply chain roles.
• Ability to work with large datasets using SQL & Python.
• Strong analytical skills to recommend category adjustments and optimize inventory performance.

Responsibilities

• Analyze category performance and identify assortment gaps.
• Allocate stock based on demand forecasts and sales trends.
• Produce reports on stock availability and allocation performance.

Skills

Data analysis

Problem-solving

Attention to detail

Communication

Education

Bachelor's degree in Business, Supply Chain, Data Analytics, Economics, or related field

Tools

Excel

Power BI

SQL

Python

Job description

Category Optimization

• Assortment Strategy: Analyze category performance, identify assortment gaps and propose category additions, removals, or replacements.
• Data-Driven Insights: Use data analysis to create and refine assortment strategies that improve category performance.
• Scenario Simulation: Conduct "what-if" simulations to predict the impact of assortment changes.
• Automation & Tools: Support the development and use of automated tools and dashboards for assortment planning and optimization.
• Performance Measurement: Track the impact of optimization decisions on sales, turnover and stock efficiency.

Category Allocation

• Stock Allocation: Allocate stock to stores based on demand forecasts, store capacity and sales trends.
• Replenishment: Ensure stock replenishment is timely and accurate to avoid stockouts and overstocking.
• Demand Alignment: Use sales and demand forecasts to adjust allocation decisions in real-time.
• Stock Efficiency: Minimize stockouts and overstock while optimizing store-level inventory performance.
• Reporting & Analysis: Produce reports on stock availability, allocation performance and sell-through rates for internal stakeholders.
• Collaborate with supply chain, merchandising, and retail teams to ensure proper execution of assortment and allocation strategies.
• Coordinate with IT, analytics, and system development teams to enhance and automate allocation and optimization tools.

Requirements

• Bachelor's degree in Business, Supply Chain, Data Analytics, Economics, or related field.
• Minimum 5 years in category management, assortment planning, allocation, or supply chain roles.
• Technical Skills: Proficiency in data analysis tools (Excel, Power BI). Ability to work with large datasets using SQL & Python.
• Analytical Skills: Ability to identify assortment opportunities, recommend category adjustments and optimize inventory performance.
• Attention to Detail: Track in stock, sales, and category performance to ensure timely action.
• Problem-Solving: Strong problem-solving skills to identify issues, create action plans and drive continuous improvement.
• Communication: Strong communication skills to present data-driven decisions to cross-functional teams.
• Time Management: Ability to handle multiple priorities (assortment, allocation, and reporting) simultaneously.