Job Description – Payroll Process cum MIS Executive
Job Title: Payroll Process cum MIS Executive
Department: Human Resources
Location: Mumbai
Experience: 1–3 Years
Salary: ₹25,000 – ₹30,000 per month (Based on experience)
Job Summary
We are looking for a detail-oriented and analytical Payroll Process cum MIS Executive to manage monthly payroll processing, employee data, statutory compliance, and MIS reporting. The ideal candidate should have strong knowledge of payroll operations along with advanced Excel skills to prepare reports and dashboards.
Key ResponsibilitiesPayroll Management
- Process monthly payroll accurately and within timelines.
- Maintain employee attendance, leave, overtime, and salary records.
- Prepare salary sheets, full & final settlements, and reimbursement statements.
- Handle statutory deductions such as PF, ESIC, PT, TDS, etc.
- Coordinate with HR and Finance for payroll-related activities.
- Resolve employee payroll queries promptly.
MIS Reporting
- Prepare daily, weekly, and monthly MIS reports.
- Generate HR and business reports using Advanced Excel.
- Develop dashboards and analytical reports for management.
- Maintain employee master data and payroll databases.
- Analyze payroll and HR data to identify trends and discrepancies.
- Ensure data accuracy and confidentiality.
Documentation & Compliance
- Maintain payroll records and employee documentation.
- Support audits by providing payroll and MIS data.
- Ensure compliance with company policies and statutory regulations.
Required Skills
- Strong knowledge of payroll processing and salary calculations.
- Advanced Microsoft Excel skills:
- Pivot Tables
- XLOOKUP / VLOOKUP
- INDEX-MATCH
- IF, SUMIFS, COUNTIFS
- Power Query (Preferred)
- Data Validation
- Charts & Dashboards
- Knowledge of HRMS/Payroll software (Spine HRMS preferred).
- Good analytical and problem-solving skills.
- Strong attention to detail and accuracy.
- Good communication and coordination skills.
Educational Qualification
- Bachelor's Degree in Commerce, Management, Finance, or a related field.
- Certification in Advanced Excel or Payroll will be an added advantage.
Preferred Candidate Profile
- 1–3 years of experience in Payroll and MIS.
- Experience handling payroll for 100+ employees is preferred.
- Ability to work under deadlines with high accuracy.
- Proficient in MS Office, especially Excel.
Pay: ₹20,000.00 - ₹30,000.00 per month
Work Location: In person
