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

MR.DIY Group (M) Berhad; Seri Kembangan; On-site; MYR 60,000 - 90,000; Full time

Job summary

MR.DIY Group (M) Berhad is seeking a data analytics professional to analyse complex retail inventory and replenishment problems. You will own the analytical lifecycle from problem understanding to recommendations, using SQL, Python/pandas, Excel and BI tools for large datasets.

You will validate data, prepare clear reports, and communicate findings to stakeholders with varying technical knowledge, while applying AI and automation to boost productivity. Fresh graduates are welcome.

Qualifications

• Bachelor's degree or higher in a data-related field is required.
• Strong logical thinking, problem-solving and attention to detail.
• Solid foundation in SQL, Python/pandas and advanced Excel; Power BI/Looker Studio are pluses.
• Experience with large datasets, data cleaning, transformation and validation.
• Ability to discuss directions with superiors and explain methods clearly.
• Willingness to ask questions, investigate issues and contribute ideas.
• Knowledge of retail, inventory, replenishment or allocation is a plus.
• Experience with databases, Parquet, automation, and ML tools is advantageous.
• Fresh graduates with strong analytics are welcome.

Responsibilities

• Analyse complex retail inventory, replenishment and allocation problems across stores and SKUs.
• Take ownership from problem understanding to follow-up and recommendations.
• Use SQL, Python/pandas, Excel and BI tools to process and visualise large datasets.
• Validate data and results with cross-checks before decisions.
• Prepare reports and presentations for varied technical audiences.
• Proactively identify issues and propose ideas to improve processes.
• Leverage AI, automation, and tools to boost productivity while validating outcomes.

Skills

Analytical thinking

Problem solving

Attention to detail

Data cleaning & transformation

Communication

Team collaboration

SQL

Python/pandas

Excel (advanced)

Data visualization concepts

Education

Bachelor's Degree or above in Data Analytics, Data Science, Statistics, Mathematics, Computer Science, Business Analytics, Engineering, Economics or related fields

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