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”