Executive - MIS

Job description

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”