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

MR D.I.Y Trading Sdn Bhd; Kajang , Bandar Baru Bangi, Seri Kembangan; On-site; MYR 60,000 - 96,000; Full time

Job summary

MR D.I.Y Trading Sdn Bhd is seeking a Data Analyst Executive (R&D - Analytic & Improvement) to tackle complex retail inventory, replenishment and allocation challenges across stores, SKUs, stock, sales and warehouse flow.

You will own analyses from data identification to recommendations, using SQL, Python/pandas, Excel and BI tools, and will present findings to both technical and non-technical audiences.

Qualifications

• 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.
• 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, data cleaning, transformation, validation and reconciliation.
• Able to explain methodology, assumptions and findings to technical and non‑technical audiences.

Responsibilities

• Analyse complex retail inventory, replenishment and allocation problems across stores, SKUs, stock, sales and warehouse flow.
• Own analyses from problem understanding and data validation through findings, recommendations and follow-up.
• Use SQL, Python/pandas, Excel and BI tools to process, analyze and visualize large datasets.
• Validate data and analytical results with cross-checks before informing decisions.
• Prepare clear reports and presentations for diverse audiences.
• Identify issues, ask questions, challenge assumptions and propose improvements.
• Leverage AI, automation and other tools to boost productivity while validating results.

Skills

SQL

Python/pandas

Advanced Excel

Power BI

Looker Studio

Education

Bachelor’s degree or above in Data Analytics/Data Science/Statistics/Mathematics/CS/Business Analytics/Engineering/Economics

Tools

Parquet

Automation tools

AI-assisted tools

Simulation/ML basics

Job description

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

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.

As we continue our rapid expansion across the Klang Valley and other states in Malaysia, we're seeking passionate and qualified Malaysian to join our growing team.

In 2024, we recorded an Employee Satisfaction Score of 91% - a meaningful benchmark that reflects our ongoing commitment to creating a workplace where people thrive.

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