Job Title

Executive - MIS Summary

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.
- Robust 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”

📌 Executive - MIS (India)
🏢 Cushman u0026 Wakefield
📍 India