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 professional 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 advantage.
- Good knowledge of Microsoft PowerPoint, MS Word, email and internet operations.
- Good communication, coordination and documentation skills.
- Strong attention to detail and ability to meet deadlines.
Educational Qualification:
Graduation in any discipline is mandatory. Candidates with an HR-related qualification or computer certification will be preferred.
Experience:
Previous experience in HR Operations, Personnel Management, Payroll, HR MIS or Back Office will be preferred. Freshers may apply only if they have excellent practical knowledge of Advanced Excel.
Selection Process:
An Advanced Excel practical test will be conducted during the selection process. Candidates without strong practical knowledge of Excel should not apply.
Salary:
As per the candidate’s knowledge, experience and interview performance.
How to Apply:
Interested candidates should email their updated CV to:
[email protected]
Email Subject: Application for HR & Personnel Associate – Advanced Excel Expert
Please mention your current location, current salary, expected salary and notice period in the email.
Pay: From ₹12,000.00 per month
Work Location: In person
