Data Analyst (Category Optimization & Allocation - Research & Development)

Key Responsibilities

• Apply inventory planning logic to optimize inventory allocation.
• Analyze store-SKU performance, trigger orders, and replenishment models.
• Write and optimize SQL queries for aggregation and inventory analysis.
• Perform data cleaning, transformation, and analysis using Python/pandas.
• Develop PyQt tools to visualize and manage store-level data.
• Create and maintain Excel analyses and PowerBI/Looker Studio dashboards.
• Prepare ad-hoc reports to support decision-making.
• Leverage modern AI-driven analytical techniques to enhance productivity and insights in a responsible and confidential manner.
  
  

Requirements

• Degree in Data Science, Supply Chain, Computer Science, Statistics, or related fields.
• Experience in retail operations and inventory planning.
• Fresh graduates are encouraged to apply.
• SQL, Python/pandas, and PyQt skills; Machine Learning is a plus.
• Solid understanding of inventory planning concepts.
• Advanced Excel skills; experience with PowerBI/ Looker Studio/ BigQuery is a plus.
• Detail-oriented, problem solver, and able to work with large datasets.
  
  

MR D.I.Y. is a home-grown enterprise with over 1,300 stores across Malaysia and Brunei. The home improvement retailer has dedicated to make a positive difference in the lives of its valued customers by offering convenience at all its stores nationwide and online at mrdiy.com.my

All MR. D.I.Y. stores are managed directly and the retailer often works in collaboration with owners of shopfront properties or owners of malls. MR. D.I.Y. stores offer a wide selection of SKUs across five major categories, namely hardware; household and furnishing; electrical; stationery and sports equipment products; and others (comprising toys, car accessories, jewellery, cosmetics, food and beverage items, as well as health and personal care).

The Company strives to put its customers first by operating an innovative business that is flexible when it comes to providing a wide variety of products, good quality and value-for-money, holding true to the Company’s motto of “Always Low Prices”.