Job Title
Executive - MIS
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.
INCO: “Cushman & Wakefield”
