Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

Home
>
Jobs in durgapur
>
Pinnacle Infotech
>
Job Opening For Senior Executive -HR Operations-Durgapur

Job Opening For Senior Executive -HR Operations-Durgapur

Pinnacle Infotech

3 - 8 years

3 - 6 Lacs

durgapur

Posted:-1 days ago| Platform:

Apply

Skills Required

hr mis payroll management attendance management ms office leave management

Work Mode

Work from Office

Job Type

Full Time

Job Description

Roles & Responsibilities of HR Operations Executive

Role Overview:

Excel-based data analysis, reporting, and HR MIS

Key Responsibilities:

1. HR MIS & Reporting (Primary Focus)

Maintain and update daily, weekly, and monthly HR dashboards using
Excel
.
Prepare reports related to headcount, attrition, joining/leaving trends, absenteeism, etc.
Generate pivot tables, VLOOKUP, XLOOKUP, IF statements, and other
advanced Excel functions
to analyze HR data.
Automate repetitive reports using formulas/macros (where applicable).
Consolidate and validate data from multiple sources to maintain data integrity.

2. Attendance & Leave Data Management

Collate and analyze employee attendance data from HRMS in
Excel
format.
Identify and flag irregularities (late marks, absenteeism, missing punch, etc.) using Excel formulas.
Prepare monthly attendance summary reports for payroll processing.

3. Payroll Support

Prepare Excel sheets with payroll inputs (attendance, leaves, bonus, variable pay, deductions, etc.).
Perform data validation, ensure zero errors in final Excel files submitted for payroll.
Assist in reconciliations using Excel lookups and cross-checking formulas.

4. Employee Master Data Management

Maintain master Excel files for employee records PIS, department, grade, band, cost center, etc.
Perform periodic audits and cleanup of data using Excel tools (filters, conditional formatting, duplicates removal).

6. Ad Hoc Analysis

Support HR management in providing quick data insights via Excel – e.g., gender ratio, location-wise distribution, etc.
Assist in management dashboards and presentations by exporting and visualizing Excel data in charts and graphs.

Skills Required:

Proficiency in Excel
– Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IFERROR, INDEX-MATCH, conditional formatting.
Basic to intermediate knowledge of
Excel macros/VBA
is a plus.
Detail-oriented with a high degree of accuracy in data entry and analysis.
Strong analytical and data interpretation skills.

Kindly share your resume at ramachandrans@pinnacleinfotech.com

More Jobs at Pinnacle Infotech

Job Opening For Motion Graphics Designer-Pinnacle Infotech -Madurai

Madurai, Durgapur

4 - 9 yrs

INR 2 - 7 Lacs

Training Head

Madurai

7 - 10 yrs

INR 10 - 14 Lacs

COE Head

Madurai

10 - 15 yrs

INR 20 - 25 Lacs

Site Engineer

Madurai

2.0 - 5.0 yrs

INR 1 - 3 Lacs

BIM Modeler Electrical Position Madurai

Madurai

3.0 - 12.0 yrs

INR 5 - 14 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.