Sales & Manpower Analysis Manager

MR D.I.Y Trading Sdn Bhd; Selangor; On-site; MYR 78,000 - 123,000; Full time

Job summary

MR D.I.Y Trading Sdn Bhd is expanding its regional operations and seeks a Workforce Planning & Analytics Analyst to join our retail team in Malaysia. The role focuses on headcount optimization, store staffing and performance analytics across multiple stores.

You will collaborate with Operations, HR and Finance to deliver insights that drive staffing efficiency and sales performance, while maintaining high standards of data accuracy and reporting.

Qualifications

• Bachelor's degree or higher in business, retail management, statistics or related field.
• 3–5 years of experience in retail operations, workforce planning or sales performance analysis.
• Strong analytical mindset with proficiency in Excel and data tools (Power BI, Tableau).
• Good understanding of retail store operations and manpower planning principles.
• Excellent communication, presentation and coordination skills.
• Able to manage multiple priorities and work cross-functionally with Operations, HR and Finance.

Responsibilities

• Store PIC updates and maintain accurate reporting structures.
• Monitor over-hiring and coordinate with HR and Area Managers for corrective actions.
• Review headcount allocations store-by-store to align with business needs.
• Analyze store sales performance, salary ratios and staff turnover trends.
• Investigate significant sales declines and identify underlying issues.
• Develop and refine store targets, optimize staff schedules and adjust hours.
• Enhance hiring and customer service SOPs for efficiency and consistency.

Skills

Excel

Data analysis

Analytical mindset

Communication

Education

Bachelor's degree in Business Administration / Retail Management / Statistics

Tools

Power BI

Tableau

Job description

At MR DIY International, we're more than a global home improvement brand, we're a catalyst for ambitious talent ready to grow beyond borders.
With over 5,000+ stores across 14 countries globally, we offer unmatched international exposure to those looking to build a meaningful, global career. From retail operations and merchandising to strategy, tech, and supply chain. Your work here shapes how millions of customers shop every day.

Key Responsibilities

1. Store PIC Updates
   • Ensure all store PIC (Person-in-Charge) records are accurate and regularly updated.
   • Coordinate with HR and Operations to maintain up-to-date reporting structures.
2. Over-Hiring Control
   • Monitor and flag over-hiring instances across stores.
   • Implement corrective actions and coordinate with Area Managers and HR for follow-up.
3. Headcount Optimization
   • Review manpower allocations store-by-store to ensure alignment with business needs.
   • Recommend headcount changes based on store size, sales, and operational demands.
4. Sales & Manpower Analysis
   • Analyse store sales performance, salary ratios, and staff turnover trends.
   • Study staff turnover patterns and identify root causes for improvement.
5. Sales Drop Investigations
   • Conduct audits and deep-dives on stores experiencing significant sales declines.
   • Coordinate with relevant departments to identify and resolve underlying issues.
6. Target & Scheduling Optimization
   • Develop and refine store targets, optimize staff schedules, and adjust business hours as needed.
7. SOP Development
   • Enhance hiring and customer service SOPs for efficiency and consistency.

Requirements

• Bachelor's Degree in Business Administration, Retail Management, Statistics, or a related field.
• Experience: Minimum 3 to 5 years of experience in retail operations, workforce planning, or sales performance analysis.
• Strong analytical mindset with proficiency in Excel and data tools (e.g., Power BI, Tableau).
• Good understanding of retail store operations and manpower planning principles.
• Excellent communication, presentation, and coordination skills.
• Able to manage multiple priorities and work cross-functionally with Operations, HR, and Finance.
• High attention to detail and a proactive approach to problem-solving.

Preferred Attributes

• Experience in a multi-store or chain retail environment.
• Familiarity retail KPIs and manpower cost metrics.
• Strong leadership and management skills.

From a single store in 2005 on Jalan Tuanku Abdul Rahman, Kuala Lumpur, MR.DIY has evolved to become a household name associated with home improvements and more by providing convenience, accessibility and affordability to all; to meet the needs of Malaysians from all walks of life.

From a single store in 2005 on Jalan Tuanku Abdul Rahman, Kuala Lumpur, MR.DIY has evolved to become a household name associated with home improvements and more by providing convenience, accessibility and affordability to all; to meet the needs of Malaysians from all walks of life.

Researching careers? Find all the information and tips you need on career advice.