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

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

Job summary

MR D.I.Y. is seeking a data analytics professional to analyze complex retail inventory, replenishment, and allocation challenges across stores, SKUs and sales data. You will own the analytics process from problem framing through data validation, analysis, and delivering actionable recommendations.

You will apply SQL, Python/pandas and advanced Excel to process large datasets and create clear reports. Experience with Power BI or Looker Studio is advantageous; strong communication to both

Qualifications

• Bachelor's degree or above in a quantitative field such as data analytics, data science, statistics, mathematics, CS, business analytics, engineering or economics.
• Strong logical thinking, problem-solving ability and attention to detail.
• Solid 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 explain analytical methodology, assumptions and findings clearly to technical and non-technical audiences.

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

Skills

SQL

Python/pandas

Advanced Excel

Education

Bachelor's degree or above in a related field

Tools

Power BI

Looker Studio

Job description

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