Data Analyst

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

Job summary

A dynamic retail company in Malaysia seeks a Data Analyst to optimize inventory allocation and analyze store performance. The candidate should have strong SQL and Python skills, along with a solid understanding of inventory planning. Responsibilities include developing dashboards and conducting detailed data analysis. Fresh graduates are welcome to apply.

Qualifications

• SQL, Python/pandas, and PyQt skills are required; Machine Learning is a plus.
• Solid understanding of inventory planning concepts is essential.
• Advanced Excel skills are necessary along with experience in PowerBI/Looker Studio/BigQuery.

Responsibilities

• Apply inventory planning logic to optimize inventory allocation.
• Analyze store-SKU performance and trigger orders.
• Write and optimize SQL queries for analysis.

Skills

SQL

Python/pandas

PyQt

Machine Learning

Advanced Excel

PowerBI

Looker Studio

Education

Degree in Data Science, Supply Chain, Computer Science, Statistics, or related fields

Tools

PowerBI

Looker Studio

BigQuery

Job description

Key Responsibilities

• Apply inventory planning logic to optimize inventory allocation.
• Analyze store‑SKU performance, trigger orders, and replenishment models.
• Write and optimize SQL queries for aggregation and inventory analysis.
• Perform data cleaning, transformation, and analysis using Python/pandas.
• Develop PyQt tools to visualize and manage store‑level data.
• Create and maintain Excel analyses and PowerBI/Looker Studio dashboards.
• Prepare ad‑hoc reports to support decision‑making.
• Leverage modern AI‑driven analytical techniques to enhance productivity and insights in a responsible and confidential manner.

Requirements

• SQL, Python/pandas, and PyQt skills; Machine Learning is a plus.
• Solid understanding of inventory planning concepts.
• Advanced Excel skills; experience with PowerBI/Looker Studio/BigQuery is a plus.
• Detail‑oriented, problem solver, and able to work with large datasets.

Preferred Qualifications

• Degree in Data Science, Supply Chain, Computer Science, Statistics, or related fields.
• Experience in retail operations and inventory planning.
• Fresh graduates are encouraged to apply.