Mis Executive

Hurix; Pune District; On-site; INR 300,000 - 520,000; Full time

Job summary

Hurix in Pune is seeking a data-focused MIS Analyst to support the HR team with reporting, data management and dashboard maintenance.

You will handle data collection, audits and ad-hoc SQL extractions, contributing to workforce analytics, payroll and compliance. This role emphasizes accuracy, independence, and translating complex data into clear HR insights.

Qualifications

• Experience: Fresher to 4 years of experience in MIS, Data Analysis, or a related field.
• Advanced Excel/Google Sheets: Expertise in complex formulas, VLOOKUP, HLOOKUP, Pivot Tables, SUMIFS, conditional formatting, and dashboard creation is essential.
• Database Skills: Proficiency in Google Spreadsheets/ Excel for extracting and manipulating data from databases.
• MIS Software: Familiarity with MIS software platforms or Applicant Tracking Systems (ATS) is beneficial
• Attention to Details: Strong communication, attention to detail & a commitment to data integrity.
• Ability to work independently, manage time effectively, and take ownership of tasks.
• Data Visualization: Familiarity with data analysis/visualization

Responsibilities

• MIS Reporting: Prepare and maintain daily, weekly, and monthly MIS reports and trackers for the HR department.
• Data Management: Collect, clean, organize, and maintain data from various HR systems and sources (e.g., attendance records, payroll inputs, recruitment databases).
• Dashboard Support: Assist in updating, maintaining, and creating dashboards and performance trackers related to HR KPIs such as attrition, recruitment funnel, and employee performance metrics.
• Data Accuracy: Conduct regular audits and checks to ensure data accuracy and consistency, identifying and correcting errors or inconsistencies in data sets.
• HR Analytics Support: Support the HR team with basic data analysis on workforce planning, payroll, compliance, and recruitment lifecycle data.
• Ad-hoc Reporting: Generate ad-hoc reports and data extracts using SQL and other tools as required by senior HR management for strategic reviews.
• Documentation: Maintain documentation for MIS procedures and report generation processes.

Skills

Advanced Excel

Google Sheets

SQL basics

Data Visualization

Dashboarding

Data Management

Attention to detail

Independent worker

Dashboard creation

Tools

MIS software

ATS

SQL

Job description

Key Responsibilities:

• MIS Reporting: Prepare and maintain daily, weekly, and monthly Management Information System (MIS) reports and trackers for the HR department.
• Data Management: Collect, clean, organize, and maintain data from various HR systems and sources (e.g., attendance records, payroll inputs, recruitment databases)
• Dashboard Support: Assist in updating, maintaining, and creating dashboards and performance trackers related to HR Key Performance Indicators (KPIs) such as attrition, recruitment funnel, and employee performance metrics.
• Data Accuracy: Conduct regular audits and checks to ensure data accuracy and consistency, identifying and correcting errors or inconsistencies in data sets.
• HR Analytics Support: Support the HR team with basic data analysis on workforce planning, payroll, compliance, and recruitment lifecycle data.
• Ad-hoc Reporting: Generate ad-hoc reports and data extracts using SQL and other tools as required by senior HR management for strategic reviews.
• Documentation: Maintain documentation for MIS procedures and report generation processes.

Qualifications & Experience

• Experience: Fresher to 4 years of experience in MIS, Data Analysis, or a related field;
• Advanced Excel/Google Sheets: Expertise in complex formulas, VLOOKUP, HLOOKUP, Pivot Tables, SUMIFS, conditional formatting, and dashboard creation is essential.
• Database Skills: Proficiency in Google Spreadsheets/ Excel for extracting and manipulating data from databases.
• MIS Software: Familiarity with MIS software platforms or Applicant Tracking Systems (ATS) is beneficial
• Attention to Details: Strong communication, attention to detail & a commitment to data integrity.
• Ability to work independently, manage time effectively, and take ownership of tasks.
• Data Visualization: Familiarity with data analysis/visualization