Inventory Analytics Engineer

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

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.