Roles & Responsibilities

1. HR Data Management

- Maintain and update employee databases and HR records.

- Manage employee information, joining, exit, attendance, and leave records.

- Ensure data accuracy and confidentiality.

2. MIS Reporting

- Prepare daily, weekly, and monthly HR MIS reports.

- Generate reports related to employee headcount, attrition, attendance, hiring, and employee turnover.

- Prepare dashboards and performance reports for management.

3. Recruitment MIS

- Maintain candidate databases and recruitment trackers.

- Track candidates at different interview stages.

- Maintain records of shortlisted, selected, rejected, and joined candidates.

- Prepare hiring status and recruitment funnel reports.

4. Attendance & Payroll Data

- Maintain attendance, leave, overtime, and working-hour records.

- Coordinate with the payroll team for accurate employee data.

- Assist in payroll-related data preparation.

5. Data Analysis

- Analyse HR data and identify trends.

- Track employee turnover, absenteeism, and recruitment performance.

- Provide accurate data insights to management.

6. Documentation & Coordination

- Maintain employee documentation and HR files.

- Coordinate with HR, recruitment, accounts,



and management teams.

- Ensure timely submission of HR reports.

Technical Skills Required

- Advanced MS Excel.

- Pivot Tables and Pivot Charts.

- VLOOKUP, HLOOKUP and XLOOKUP.

- IF, SUMIF, COUNTIF and COUNTIFS.

- INDEX and MATCH.

- Conditional Formatting.

- Data Validation and Data Cleaning.

- Excel Dashboard Creation.

- Basic knowledge of Power BI.

- Basic knowledge of HRMS / HRIS software.

- Knowledge of Google Sheets.

- Basic knowledge of payroll and attendance management systems.

Educational Qualification

- Graduate in B.Com, BBA, BA, or any relevant discipline.

- MBA in HR or relevant certification will be an added advantage.

Key Requirements

- Strong analytical and numerical skills.

- Excellent Excel and data management skills.

- Attention to detail and accuracy.

- Valuable communication and coordination skills.

- Ability to handle confidential employee information.

- Ability to prepare and present reports within deadlines.

Pay: Up to ₹40,000.00 per month

Benefits:

- Food provided
- Health insurance
- Provident Fund

Work Location: In person

📌 HR MIS (Zirakpur)
🏢 Innvocon Learning Solutions
📍 Zirakpur