MIS Executive

Reports To: General Manager / Director Core Objective: To own, manage, and analyze all financial data (revenue and expenditure) to provide actionable insights that improve organizational efficiency and profitability. To act as a direct analytical support resource for management. Key Responsibilities: Data Consolidation & Management:Gather and centralize financial data from diverse sources (PMS, POS, OTAs, vendor invoices, etc.). Perform accurate and consistent menial data entry to maintain up-to-date records. Design, maintain, and cleanse databases to ensure data integrity. Reporting & Analysis: Develop and generate daily, weekly, and monthly MIS reports on key financial metrics (RevPAR, ADR, Occupancy, P&L, etc.). Create insightful dashboards and data visualizations to simplify complex information. Analyze revenue and expenditure patterns to identify trends, anomalies, and opportunities. Conduct variance analysis by comparing actual performance against budgets and forecasts. Process Streamlining & Efficiency: Evaluate and improve current data collection and reporting workflows. Adapt to and assist in the implementation of new software to automate processes. Develop Standard Operating Procedures (SOPs) for data handling. Strategic Support & Confidentiality: Provide data-driven recommendations directly to management for strategic decision-making. Maintain absolute confidentiality and discretion with all sensitive financial and operational data. Handle ad-hoc analytical projects as required. Essential Skills Required Technical Skills: Expert-Level Microsoft Excel:Advanced Formulas: Mastery of VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, Logical and Text functions. PivotTables & Pivot Charts: Ability to create and manipulate complex pivot tables for quick analysis. Data Tools: Proficient in Data Validation, Conditional Formatting, and other data management tools. Dashboard Creation: Capable of building interactive dashboards to track KPIs. Software Adaptability: A proven ability to quickly learn and navigate new software and platforms. Data Visualization: Skill in using charts and graphs to present data clearly and effectively. Basic Database Concepts: A fundamental understanding of data structure and management. Analytical & Cognitive Skills Strong Analytical Mindset: Ability to see patterns, trends, and anomalies in raw data. Problem-Solving Ability: Capable of diagnosing issues and using data to find logical solutions. Meticulous Attention to Detail: Essential for ensuring accuracy in data entry and analysis. Personal Attributes High Integrity & Discretion: Must be completely trustworthy with confidential financial information. Disciplined Work Ethic: Willing and able to perform routine, repetitive data entry tasks with diligence and accuracy. Proactive & Self-Motivated: A self-starter who can work independently and deliver results without constant supervision. Clear Communication Skills: Ability to explain complex data and findings in simple, understandable terms to management.