Executive - MIS

Cushman & Wakefield; Chennai District; On-site; INR 400,000 - 650,000; Full time

Job summary

Cushman & Wakefield in Chennai seeks an Executive - MIS to own daily/weekly/monthly MIS reporting, consolidate data from stores and vendors, and maintain dashboards. The role emphasizes advanced Excel, data validation, and timely submission of reports.

You will monitor complaint status, track attendance and material status, and support Power BI dashboards, ensuring data accuracy and audits. Minimum 12th or graduate with 5–6 years in facilities/retail operations preferred.

Qualifications

• 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.

Responsibilities

• 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.
• 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.
• 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.
• 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.
• 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.
• 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.

Skills

Advanced Excel

Pivot Tables

Pivot Charts

XLOOKUP

VLOOKUP

Data analysis

Attention to detail

Communication

Coordination

KPI reporting

Multi-reporting

Education

12th or Graduate

Tools

Excel

Power BI

Job description

Job Title

Executive - MIS

Key Responsibilities

• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.

Key Responsibilities

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