Workforce Analyst
SMSUP · Maadi, Cairo, Egypt
Tailor my CV for this job — freeJob Description Analyze, plan, and optimize workforce allocation across production machines based on production requirements, machine capacity, job order estimated running time, and actual operational performance. optimal manpower utilization, accurate labor cost allocation per machine and job order, and continuous monitoring of workforce productivity through the integration and comparison of operational estimates in Insoft against actual workforce attendance, working hours, and production records in Finsys ERP . Key Responsibilities Machine Workforce Planning & Allocation Develop daily, weekly, and monthly workforce allocation plans across production machines. Determine the required number of employees for each machine based on: Job order requirements and production quantities. Estimated machine running time. Machine operating capacity and production speed. Required operators, helpers, assistants, and supporting workforce. Shift schedules and workforce availability. Identify manpower shortages, excess allocation, and underutilized employees. Recommend workforce redistribution between machines based on actual operational needs. Establish standard manpower requirements per machine and production activity. Coordinate with Production Planning and Production Supervisors to ensure workforce availability against production schedules. 2. Workforce Cost Analysis – Insoft vs. Finsys ERP Extract estimated job order running hours and workforce requirements from Insoft. Extract actual employee working hours, attendance, overtime, and job order production records from Finsys ERP. Calculate estimated versus actual direct labor costs per job order and machine. Analyze labor cost variances and identify their root causes. Monitor the impact of machine downtime, production delays, low operating speeds, and manpower inefficiencies on labor costs. Identify job orders with excessive labor consumption compared to estimated standards. Develop reports showing labor cost per machine, per job order, per production unit, and per shift. Highlight unnecessary overtime and excessive manpower allocation. 3. Workforce Productivity & Utilization Monitor direct workforce productivity and utilization rates. Analyze the relationship between machine running hours and allocated manpower hours. Identify opportunities to reduce idle time and improve workforce utilization. Measure actual labor hours against standard labor hours. Monitor manpower efficiency across machines, departments, and shifts. Recommend optimal workforce structures based on production workload. 4. Reporting & Data Analysis Develop advanced Excel-based analytical models and automated dashboards. Prepare daily, weekly, and monthly workforce performance reports. Build a historical database for workforce allocation, labor costs, and machine productivity. Provide management with actionable insights and recommendations. Ensure data accuracy and consistency between Insoft and Finsys ERP. Job Requirements Qualifications & Requirements Bachelor's degree in Business Administration, Accounting, Industrial Engineering, Statistics, or a related field. 2–4 years of experience in Workforce Planning, Workforce Analysis, Production Planning, or Manufacturing Operations Analysis. Previous experience in manufacturing environments is essential. Strong understanding of machine-based production processes and direct labor allocation. Advanced Microsoft Excel skills are mandatory. Experience with ERP systems and production planning systems is highly preferred. Experience with Insoft and Finsys ERP is an advantage. Strong analytical, numerical, and problem-solving skills. Excellent attention to detail and ability to translate operational data into management insights.