Data Analyst Executive (R&D - System & Optimization)

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

Job summary

MR DIY Malaysia is seeking a skilled data tooling specialist to implement and maintain in‑house tools aligned with business needs. You will write Python/pandas scripts and SQL queries to support automation and data processing, while applying inventory planning concepts for efficient operations.

The role emphasizes collaboration with cross‑functional teams, proactive improvement of processes, and the ability to adapt to evolving business requirements. Malaysia‑based location preferred.

Qualifications

• Strong proficiency in Python and SQL with real‑world project experience.
• Advanced Excel skills for analyses and reporting.
• Excellent analytical and problem‑solving abilities with attention to detail.
• Proactive mindset to learn new tools and adapt to changing business needs.
• Experience with data analytics and handling large datasets is a plus.

Responsibilities

• Implement and maintain in‑house tools based on business requirements.
• Write, optimize, and maintain SQL queries and Python/pandas scripts to support system logic and automation.
• Apply inventory planning logic and best practices in system implementations.
• Troubleshoot, debug and refine tools based on stakeholder feedback.
• Support data analysis tasks with cross‑functional collaboration to meet business needs.
• Identify opportunities to improve processes, tools, and workflows.

Skills

Python

SQL

Advanced Excel

Analytical thinking

Data analytics

Power BI

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