Data Analyst

MR.DIY; Selangor; On-site; MYR 67,000 - 112,000; Full time

Job summary

MR.DIY is seeking an inventory planning/data analytics professional in Malaysia to optimize stock allocation and drive smarter replenishment decisions. You will analyze store-SKU performance, write SQL queries, and transform data using Python/pandas, while building PyQt tools and dashboards to enable store-level insights.

The role involves Excel-driven analyses and ad-hoc reporting, with opportunities to apply AI-enabled techniques for productivity and deeper business insights.

Qualifications

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

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.

Skills

SQL

Python/pandas

PyQt

Advanced Excel

PowerBI / Looker Studio

Education

Degree in Data Science / Supply Chain / CS / Stats

Tools

PowerBI

Looker Studio

BigQuery

Job description

Jora Malaysia will close on 9th September 2026. Thank you for being with us, we are cheering you on as you continue your career journey.

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.