Sales & Manpower Analysis Manager

MR D-I-Y Malaysia; Seri Kembangan; On-site; MYR 60,000 - 80,000; Full time

Job summary

A leading home improvement brand in Selangor, Malaysia is looking for a Retail Operations Analyst to enhance store performance. Responsibilities include updating personnel records, monitoring hiring practices, and optimizing staff allocation based on sales data. The ideal candidate holds a Bachelor's degree and has at least 3-5 years of experience in retail operations with strong analytical skills and proficiency in tools like Power BI. Join our team and contribute to our expansion across multiple stores.

Qualifications

• 3 to 5 years of experience in retail operations, workforce planning, or sales performance analysis.
• Good understanding of retail store operations and manpower planning principles.
• Able to manage multiple priorities and work cross-functionally.

Responsibilities

• Ensure all store PIC records are accurate and regularly updated.
• Monitor and flag over-hiring instances across stores.
• Review manpower allocations store-by-store.
• Conduct audits on stores experiencing significant sales declines.
• Develop and refine store targets and staff schedules.

Skills

Analytical mindset

Strong communication skills

Proficiency in Excel

Data tools knowledge

Problem-solving skills

Education

Bachelor's Degree in Business Administration, Retail Management, Statistics, or related field

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