Human Resource and MIS Executive

Job Description HR MIS Executive

Job Title: HR MIS Executive
Experience: 2 to 4 Years
Location: Chennai
Employment Type: Full-Time

Role Overview

We are looking for a detail-oriented and analytical HR MIS Executive with 34 years of experience in HR reporting, MIS, data analysis, and dashboard creation. The ideal candidate should have strong expertise in Advanced Excel, VBA/Macros, Python, HR data attributes, and dashboard development, along with a good understanding of recruitment and employee analytics.

The role will involve managing HR data, developing automated reports and dashboards, tracking key recruitment metrics, and providing actionable insights to HR and business stakeholders.

Key Responsibilities

HR MIS & Data Analytics

• Manage and maintain HR MIS and employee-related datasets with high accuracy and data integrity.
• Collect, consolidate, validate, and analyze HR data from multiple sources.
• Define and maintain relevant HR data attributes and ensure consistency across HR systems and reports.
• Prepare regular and ad-hoc HR reports for management and business stakeholders.
• Identify trends, gaps, and anomalies in HR data and provide meaningful insights.

Dashboard & Reporting

• Develop and maintain HR dashboards to track key HR and recruitment metrics.
• Create automated MIS reports using Advanced Excel, VBA/Macros, and Python.
• Build dashboards covering recruitment funnel, hiring performance, source effectiveness, attrition, retention, and other HR KPIs.
• Automate repetitive reporting processes to improve efficiency and reduce manual effort.
• Ensure timely and accurate delivery of daily, weekly, and monthly HR reports.

Recruitment Analytics

• Track and analyze Source Mix and recruitment channel effectiveness.
• Monitor the recruitment funnel, including sourcing, screening, interviews, offers, and joining.
• Analyze Offer Approval Process data and identify delays or bottlenecks.
• Track offer-to-join ratios and recruitment turnaround time.
• Provide insights to improve sourcing effectiveness and hiring efficiency.

Retention & Attrition Analytics

• Prepare and analyze employee retention and attrition reports.
• Track attrition trends by department, function, tenure, location, designation, and other relevant HR attributes.
• Identify key patterns and trends contributing to employee attrition.
• Support HR teams with data-driven insights for retention initiatives.

Required Skills

Technical Skills

• Advanced Excel – Strong
• Pivot Tables & Pivot Charts
• XLOOKUP / VLOOKUP
• INDEX-MATCH
• IF / SUMIFS / COUNTIFS
• Data validation and data cleaning
• Power Query
• Advanced formulas
• VBA / Macros – Strong
• Report automation
• Macro development
• Process automation
• Python – Strong
• Pandas
• Data manipulation and analysis
• Data cleaning
• Report automation
• Basic scripting for HR MIS automation
• Dashboard Creation – Strong
• Excel dashboards
• KPI reporting
• Data visualization
• Interactive MIS dashboards
• Strong understanding of HR Data Attributes and HR metrics.

HR Domain Knowledge

Candidates should have good knowledge of:

• Recruitment MIS
• Source Mix Analysis
• Recruitment Funnel
• Offer Approval Process
• Offer-to-Join Ratio
• Time to Hire / Time to Fill
• Retention Analysis
• Attrition Analysis
• Headcount Reporting
• Employee Movement / Manpower Reporting
• Joining & Exit Analytics
• HR KPI Reporting

Preferred Qualifications

• Bachelor's/Master's degree in HR, Business Administration, Statistics, Mathematics, Computer Science, Data Analytics, or a related discipline.
• 3–4 years of relevant experience in HR MIS, HR Analytics, Recruitment MIS, or HR Data Analytics.
• Experience working with HRMS/ATS systems and extracting HR reports will be an added advantage.

Key Competencies

• Strong analytical and problem-solving skills
• Excellent attention to detail
• Strong data interpretation skills
• Good stakeholder management and communication skills
• Ability to handle large datasets
• Strong ownership and accountability
• Ability to automate manual processes
• Ability to convert HR data into actionable business insights

Key Deliverables / KPIs

• Accuracy and timeliness of HR MIS reports
• Automation of recurring HR reports
• Dashboard accuracy and usability
• Recruitment funnel and Source Mix reporting
• Attrition and retention analytics
• Offer approval and offer-to-join tracking
• Reduction in manual reporting effort
• Timely delivery of management reports and actionable HR insights

About Matrimony.com

Matrimony.com Ltd, a Great Place to Work Certified Wed-Tech company listed on the BSE and NSE, is a leader in matchmaking and wedding services. Its flagship brand, Bharat Matrimony, is the largest and most trusted matrimony brand (Brand Trust Report 2014) spanning customers across the entire economic strata. The company serves over 8 million members with the support of 2,900+ associates and a network of 130+ company-owned retail outlets.

Key Offerings

Matchmaking Services:

• BharatMatrimony and 200+ matrimony brands segmented on religion, languages, communities, and occupation.
• Jodii: An exclusive matchmaking app for non-degree holders in 9 Indian languages
• Assisted Service and EliteMatrimony: Personalised services for the HNI, NRI and Premium segment of customers

Wedding Services:

• Wedding Bazaar: Largest wedding services provider.
• Mandap.com: Largest online wedding venues platform.
• MakeMyWedding: Personalized & curated wedding planning services.

New Initiatives & Verticals

• Astro Free Chat: It is an exclusive app for any astrology consultation
• ManyJobs: Employment platform targeting grey collar workforce. In vernacular language for the Tamil Nadu market (initial phase) and with some of industry first features for both companies and candidates
• Luv.com: A next generation serious relationship app.

International Presence

Matrimony.com has successfully expanded into international markets, with UAE operations thriving for 4+ years and Bangladesh operations commencing in 2021. With a mission to dominate the $55 billion wedding services industry.