Data Analyst Executive (R&D - Analytic & Improvement)

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

Job summary

MR D.I.Y. is seeking a data analytics professional to tackle complex retail inventory, replenishment and allocation challenges across stores and warehouses. You will own end-to-end analysis from data identification to actionable recommendations, using SQL, Python/pandas and BI tools to process and visualise large datasets.

You will validate results, prepare clear reports for diverse audiences, and proactively identify issues while exploring AI and automation opportunities.

Qualifications

• Bachelor's degree or above in data analytics or related field.
• Strong SQL, Python/pandas and advanced Excel skills.
• Experience with BI tools (Power BI, Looker Studio) is a plus.
• Ability to work with large datasets and perform data validation.

Responsibilities

• Analyse complex retail inventory, replenishment and allocation problems across stores, SKUs and warehouses.
• Take ownership from data identification through findings, recommendations and follow-up.
• Use SQL, Python/pandas, Excel and BI tools to process, analyse and visualise large datasets.
• Validate data and results with cross-checks before informing decisions.
• Prepare clear reports and presentations for varied technical audiences.
• Identify issues proactively and explore AI/automation opportunities.

Skills

SQL

Python/pandas

Advanced Excel

BI tools

Education

Bachelor's degree or above

Tools

Power BI

Looker Studio

Job description

• Analyse complex retail inventory, replenishment and allocation problems involving stores, SKUs, stock, sales, warehouse supply, lead time, festivals and other business conditions.
• Take ownership of analysis from problem understanding, data identification and validation through analysis, findings, recommendations and follow-up.
• Use SQL, Python/pandas, Excel and BI tools to process, analyse and visualise large datasets.
• Validate data and analytical result, cross-checking and reasonableness checks before using them for decisions.
• Prepare clear reports and presentations, adapting explanations for different levels of technical knowledge.
• Proactively identify issues, ask questions, challenge assumptions and bring ideas.
• Leverage AI, automation and other suitable tools to improve productivity while understanding and validating the underlying logic and results.

Key Responsibilities

• Analyse complex retail inventory, replenishment and allocation problems involving stores, SKUs, stock, sales, warehouse supply, lead time, festivals and other business conditions.
• Take ownership of analysis from problem understanding, data identification and validation through analysis, findings, recommendations and follow-up.
• Use SQL, Python/pandas, Excel and BI tools to process, analyse and visualise large datasets.
• Validate data and analytical result, cross-checking and reasonableness checks before using them for decisions.
• Prepare clear reports and presentations, adapting explanations for different levels of technical knowledge.
• Proactively identify issues, ask questions, challenge assumptions and bring ideas.
• Leverage AI, automation and other suitable tools to improve productivity while understanding and validating the underlying logic and results.

Requirements

• Bachelor's Degree or above in Data Analytics, Data Science, Statistics, Mathematics, Computer Science, Business Analytics, Engineering, Economics or related fields.
• Strong logical thinking, problem-solving ability and attention to detail.
• Good foundation in SQL, Python/pandas and advanced Excel; experience with Power BI, Looker Studio or similar tools is an advantage.
• Able to work with large datasets and understand data cleaning, transformation, validation and reconciliation.
• Able to determine an appropriate analytical approach while discussing key directions with the superior.
• Proactive and willing to ask questions, investigate unclear issues, challenge existing practices and contribute ideas.
• Able to explain analytical methodology, assumptions and findings clearly to both technical and non-technical audiences.
• Retail, inventory, replenishment or allocation knowledge is an advantage but not mandatory.
• Experience with databases, Parquet, automation, AI-assisted tools, simulation or machine learning is an advantage.
• Fresh graduates with strong analytical ability and relevant academic/internship projects are welcome.

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