Executive, Inventory Planning Optimisation COA (Research & Development)

MR DIY Malaysia; Seri Kembangan; On-site; MYR 60,000 - 100,000; Full time

Job summary

MR D.I.Y. is seeking a data tooling engineer to implement and maintain in-house tools and systems based on defined business requirements.

You will write and optimize SQL queries and Python/pandas scripts to support system logic, data processing, and automation. You will apply inventory planning logic within system implementations to support efficient operations, troubleshoot tools, and collaborate with cross-functional teams to deliver outputs that meet business needs while identifying

Qualifications

• Strong proficiency in Python and SQL with real-world experience.
• Advanced Excel skills for analyses and reporting.
• Strong analytical and problem-solving abilities with attention to detail.
• Proactive mindset and willingness to learn new tools and responsibilities.
• Good applied math/quantitative skills to reason through business problems is an advantage.
• Understanding of inventory planning concepts is an advantage.
• Experience with data analytics or large datasets is an advantage.
• Familiarity with PyQt or similar frameworks for internal applications is an advantage.
• Experience with BI/reporting tools such as PowerBI or Looker Studio is an advantage.

Responsibilities

• Implement and maintain in-house tools and systems based on defined business requirements
• Write, optimize, and maintain SQL queries and Python/pandas scripts to support system logic, data processing and automation
• Apply inventory planning logic and best practices within system implementations to support efficient operations
• Troubleshoot, debug and refine existing tools based on feedback from stakeholders across the department
• Support data analysis tasks as needed, collaborating closely with cross-functional teams to ensure tools and outputs meet business needs
• Take initiative in identifying opportunities to improve existing processes, tools, and workflows

Skills

Python

SQL

Advanced Excel

Analytical thinking

Problem-solving

Proactive mindset

Quantitative skills

Tools

PyQt

PowerBI

Looker Studio

Job description

• Implement and maintain in-house tools and systems based on defined business requirements
• Write, optimize, and maintain SQL queries and Python/pandas scripts to support system logic, data processing and automation
• Apply inventory planning logic and best practices within system implementations to support efficient operations
• Troubleshoot, debug and refine existing tools based on feedback from stakeholders across the department
• Support data analysis tasks as needed, collaborating closely with cross-functional teams to ensure tools and outputs meet business needs
• Take initiative in identifying opportunities to improve existing processes, tools, and workflows

Key Responsibilities

• Implement and maintain in-house tools and systems based on defined business requirements
• Write, optimize, and maintain SQL queries and Python/pandas scripts to support system logic, data processing and automation
• Apply inventory planning logic and best practices within system implementations to support efficient operations
• Troubleshoot, debug and refine existing tools based on feedback from stakeholders across the department
• Support data analysis tasks as needed, collaborating closely with cross-functional teams to ensure tools and outputs meet business needs
• Take initiative in identifying opportunities to improve existing processes, tools, and workflows

Requirements

• Strong proficiency in Python and SQL, with practical experience applying these skills to real-world projects
• Advanced Excel skills, with the ability to build and maintain analyses and reports
• Strong analytical and problem-solving skills, with meticulous attention to detail
• A proactive mindset and willingness to pick up new tools, technologies, and responsibilities as business needs evolve
• Good applied math/quantitative skills, with the ability to reason through business problems is an advantage
• Understanding of inventory planning concepts is an advantage
• Prior experience in data analytics or working with large datasets is an advantage
• Familiarity with PyQt or similar frameworks for building internal applications is an advantage
• Experience with BI/reporting tools such as PowerBI, Looker Studio, or similar is an advantage

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".