Job Title

Job Description Summary

Job Description

Key Responsibilities

1. MIS & Reporting

• Prepare daily, weekly and monthly operational MIS reports.
• Prepare daily breakdown complaint reports and track complaint status.
• Monitor complaint ageing, closure status and TAT performance.
• Prepare management dashboards and reports as required.
• Consolidate data received from various stores, vendors and operational teams.
• Ensure accuracy and timely submission of all reports.

2. Housekeeping MIS

• Track housekeeping manpower attendance across stores.
• Monitor and report housekeeping staff absenteeism.
• Track manpower shortages and replacement status.
• Maintain housekeeping material requirement and availability trackers.
• Monitor material delivery status and pending requirements.

3. Data Management & Analysis

• Maintain operational databases and trackers.
• Validate data received from different sources.
• Identify data gaps, discrepancies and variances.
• Analyze trends and prepare actionable reports for management.
• Maintain historical records for performance analysis and audits.

4. Advanced Excel & Dashboarding

• Develop and maintain advanced Excel-based reports and trackers.
• Use formulas, Pivot Tables, Pivot Charts, conditional formatting and other Excel functions for data analysis.
• Automate repetitive reporting activities wherever possible.
• Prepare management dashboards and performance summaries.
• Support Power BI/dashboard reporting wherever required.

5. Coordination & Follow-up

• Coordinate with FE teams, store teams and vendors for data collection.
• Follow up for pending or incomplete information.
• Ensure timely receipt and validation of operational data.
• Support review meetings by providing accurate and updated reports.

6. Compliance & Documentation

• Maintain proper records of MIS reports and supporting data.
• Ensure data confidentiality and accuracy.
• Maintain version-controlled trackers and reports.
• Support audits, QBRs, MMRs and management reviews with required data and analysis.

Key Skills & Competencies

• Strong proficiency in Advanced MS Excel.
• Excellent knowledge of Pivot Tables, Pivot Charts, XLOOKUP/VLOOKUP, SUMIFS/COUNTIFS, IF functions and data validation.
• Knowledge of Power BI will be an added advantage.
• Strong data analysis and problem-solving skills.
• Excellent attention to detail and accuracy.
• Good communication and coordination skills.
• Ability to manage multiple reports and deadlines.
• Good understanding of operational MIS and KPI reporting.

Qualification & Experience

• Minimum qualification 12th or Graduate in any discipline.
• Strong practical knowledge of MS Excel and MIS reporting.
• Experience in Facility Management, Retail, Operations or similar service environments preferred with 5-6 years’ experience.
• Candidates with experience in dashboard creation and data automation will be preferred.

Key Performance Indicators

• Accuracy of MIS and operational reports.
• Timely submission of daily/weekly/monthly reports.
• Data completeness and validation.
• Effectiveness of dashboards and analysis.
• Timely tracking of complaints, absenteeism and material status.
• Reduction in manual reporting and improvement in reporting efficiency.