HR Executive | Coordinator |

Malhotra Book Depot; New Delhi; On-site; INR 350,000 - 550,000; Full time

Job summary

Malhotra Book Depot is seeking a detail-oriented HR Coordinator to join our HR team in Delhi. You will manage employee lifecycle activities, onboarding, HR operations, and compliance, with a strong emphasis on accurate data in MS Excel.

The role centers on advanced HR analytics, monthly/quarterly reporting, payroll inputs, and data management. You will collaborate with departments to maintain records, improve processes, and ensure data confidentiality.

Qualifications

• Bachelor's or Master's degree in HR, Business Administration, or related field.
• 2–4 years of HR Generalist or HR Coordinator experience.
• Excellent proficiency in MS Excel (VLOOKUP, XLOOKUP, Pivot Tables, Dashboards).
• Strong communication and data confidentiality.

Responsibilities

• Coordinate end-to-end onboarding, background verification, and orientation.
• Support attendance, leave management, and personnel records.
• Assist in offboarding and final settlement processes.
• Provide HR information to employees about policies and benefits.
• Maintain real-time HR master data and generate reports.

Skills

Attention to detail

Analytical thinking

Communication

Problem-solving

Education

Bachelor's or Master's in HR/Business Administration

Tools

MS Excel

Job description

Job Overview

We are looking for a detail-oriented, analytical, and proactive HR Coordinator to join our Human Resources team. In this role, you will act as a core HR Generalist, managing employee lifecycle activities, onboarding, HR operations, and compliance. Additionally, this position requires advanced proficiency in MS Excel to handle HR reporting, workforce analytics, payroll inputs, and data management with precision.

Key Responsibilities

1. HR Generalist Operations & Employee Lifecycle

• Coordinate end-to-end employee onboarding, background verification, and orientation programs.
• Support daily HR operations, including attendance, leave management, and employee record maintenance.
• Act as a point of contact for employee inquiries regarding company policies, benefits, and HR procedures.
• Assist in offboarding, exit interviews, and full & final settlement processes.
• Support employee engagement initiatives, performance management cycles, and team-building activities.

2. Advanced HR Analytics & Excel Reporting

• Maintain, update, and audit real-time HR master data and employee databases.
• Prepare monthly, quarterly, and ad-hoc HR reports (headcount analysis, attrition tracking, hiring metrics, compensation data).
• Utilize Advanced Excel functions (VLOOKUP/XLOOKUP, INDEX/MATCH, Pivot Tables, Data Validation, Nested IF Statements, Conditional Formatting, Charts/Dashboards) to process large datasets.
• Prepare accurate monthly payroll inputs, attendance summaries, and stipend/salary reconciliation sheets.
• Automate routine reporting sheets to streamline HR data tracking and operational reporting.

Key Qualifications & Skills

• Education: Bachelors or Masters degree in Human Resources, Business Administration, or a related field.
• Experience: 2-4 years of experience in an HR Generalist or HR Coordinator role.
• Excel Expertise (Must-Have): Excellent proficiency in MS Excel (VLOOKUP, XLOOKUP, Pivot Tables, Data Summarization, Formulae, Dashboards).
• HR Knowledge: Good understanding of labor law basics, HR operations, payroll processing inputs, and onboarding workflows.
• Communication: Strong written and verbal communication skills.
• Attributes: High attention to detail, problem-solving mindset, data confidentiality, and multi-tasking abilities.