Job Title: HR & Personnel Associate – Advanced Excel Expert

Company: Brightech HR Services Private Limited

Job Location: Near Acropolis Mall, Kolkata, West Bengal

Job Type: Full-time, Work from Office

Joining Requirement: Immediate joiners preferred

Job Summary:

We are looking for an HR & Personnel Associate with excellent practical knowledge of Advanced Excel and good understanding of HR operations. The candidate will be responsible for maintaining employee records, attendance and payroll data, preparing HR MIS reports, handling personnel documentation and supporting day-to-day HR activities.

Key Responsibilities:
- Maintain employee master data, attendance, leave and payroll inputs.
- Prepare daily, weekly and monthly HR MIS reports.
- Manage employee joining, transfer, confirmation and exit documentation.
- Maintain personal files and statutory employee records.
- Prepare salary inputs, attendance summaries and other HR-related reports.
- Maintain PF, ESIC, Bonus and other statutory compliance-related data.
- Assist in recruitment,



interview coordination and joining formalities.
- Draft appointment letters, warning letters, official emails and other HR documents.
- Prepare qualified PowerPoint presentations and management reports.
- Perform data cleaning, reconciliation, verification and analysis.
- Coordinate with employees, internal departments, clients and site teams.
- Maintain confidentiality and accuracy of employee and company information.

Required Skills:
- Expert-level practical knowledge of Advanced Excel is mandatory.
- Strong command of Pivot Tables, Pivot Charts and Advanced Filters.
- Good knowledge of VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIF, SUMIFS, COUNTIF and COUNTIFS.
- Knowledge of Data Validation, Conditional Formatting, Charts and Dashboards.
- Ability to handle large employee databases and prepare accurate MIS reports.
- Knowledge of Excel text, date and logical functions.
- Knowledge of Power Query and Macros will be an added ad

📌 Back Office Executive – Advanced Excel Expert (Kasba)
🏢 BRIGHTECH HR SERVICES PRIVATE
📍 Kasba