Workforce MIS & Analytics Executive

Job description

**Key ResponsibilitiesVENDOR ONBOARDING MANAGEMENT** - Identify, evaluate onboard manpower vendors for contractual workers across categories: housekeeping, security, blue-collar, admin. - Negotiate commercials: Rate cards, SLAs, payment terms, penalty clauses Maintain vendor database and performance scorecards. - Conduct quarterly business reviews with vendors **Payroll Support** - Assist in processing monthly payroll for third-party manpower. - Verify attendance, overtime, leave, and holiday data received from ops teams. - Reconcile payroll inputs with employee master data before payroll processing. - Support payroll validation and resolve discrepancies. - Need to Create PO and GRNS for pan India vendors **MIS Reporting** - Maintain employee master databases with accurate and updated information. - Generate reports using Microsoft Excel and Google Sheets. - Create dashboards for payroll, attendance, headcount, absenteeism, and manpower analysis. **Data Management** - Maintain payroll records and employee documentation for FLEX Manpower. - Ensure data accuracy and completeness in payroll trackers. - Archive payroll and attendance records systematically. **Vendor Coordination** - Coordinate with manpower vendors for attendance, payroll inputs, invoices, and clarifications. - Follow up on missing or incorrect data before payroll deadlines. - Support invoice verification against payroll records. **Compliance Documentation** - Maintain payroll-related documentation for audit purposes. - Maintain and verify statutory compliance documents submitted by manpower vendors to ensure completeness, accuracy, and regulatory compliance. - Assist in preparing reports required by Finance team. Grievances **Required Skills** - Strong knowledge of Microsoft Excel (VLOOKUP/XLOOKUP, INDEX-MATCH, Pivot Tables, IF, SUMIFS, COUNTIFS, Filters, Charts). - Advanced Excel/data visualization skills (Power BI, Tableau, etc.) would be a plus - Working knowledge of Google Sheets. - Good analytical and numerical skills. - Strong attention to detail and accuracy. - Good communication and coordination skills. - Ability to manage multiple tasks within strict deadlines. **Key Performance Indicators (KPIs)** - Payroll accuracy. - Timely completion of payroll activities. - Accuracy of MIS reports. - Attendance reconciliation within defined timelines. - Vendor response and issue resolution. - Data accuracy and completeness. Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.