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”