Business Analyst

About Treebo Hospitality Ventures

Treebo Hospitality Ventures (THV) is a hotel group driven by the goal of making travel joy accessible to all, focusing on affordable market segments from economy to mid-market. Serving over 800 hotels in more than 120 cities, Treebo caters to budget-conscious travelers through multiple brands spanning various price segments, including Itsy, Treebo, Treebo Premium, and the newly introduced Medalio affordable luxury brand. Additionally, THV operates as the master franchisee for Accor Hotels in India, managing the Ibis and Mercure brands targeting larger mid-market properties. Renowned as the favored hotel chain in the affordable segment, Treebo maintains an average rating of 7.8 out of 10 across independent review sites and continues expanding.

Role Overview

The organization seeks a skilled MIS & Financial Reporting Analyst to drive precise reporting and financial analysis that underpin strategic business and financial decisions. This role requires end-to-end ownership of MIS reporting processes, effective collaboration with Finance, Business, and Operations teams, and the delivery of insightful, timely reports that reflect business performance.

Key Responsibilities

• Manage and ensure punctual, accurate, and consistent production of daily, weekly, and monthly MIS reports reflecting business metrics.
• Work in close conjunction with Finance, Business, Operations, and Leadership teams to decipher reporting needs and design meaningful MIS dashboards and reports.
• Conduct comprehensive analyses of business and financial data, identifying trends and actionable insights.
• Create, maintain, and automate recurrent MIS reports utilizing Excel, SQL, BI tools (e.g., Tableau, Power BI), and other reporting platforms.
• Guarantee data reliability through rigorous validation, reconciliation, and monitoring across multiple business systems.
• Develop and sustain standardized reporting frameworks, KPIs, and metrics to facilitate informed business choices.
• Assist budgeting, forecasting, variance evaluations, and financial reporting activities in collaboration with the Finance team.
• Initiate automation of manual reporting tasks using AI technologies, scripting, and workflow automation to enhance operational efficiency.
• Employ AI-powered tools and Large Language Models (LLMs) to optimize reporting processes, automate repetitive functions, generate analytic insights, and boost productivity.
• Collaborate with Data Engineering and Analytics teams to enhance data accessibility, report infrastructure, and quality.
• Prepare specialized analyses and presentations for executives to aid strategic initiatives.
• Remain informed on best practices in MIS reporting, business analytics, automation, and emerging AI technology trends.

Candidate Profile

• Bachelor's degree in Commerce, Finance, Business Administration, Business Analytics, Engineering, or related fields.
• At least 3 years' experience in MIS reporting, business or financial analysis, or business intelligence roles.
• Comprehensive knowledge of finance processes involving book closure, audits, budgeting, forecasting, financial statements, and variance analysis that support managerial decisions.
• Advanced expertise in Microsoft Excel, including pivot tables, Power Query, complex formulas, and data modeling.
• Proficient in SQL, capable of crafting detailed queries for reporting and analytical purposes.
• Experienced in BI and visualization software such as Tableau, Power BI, or equivalents.
• Strong analytical thinking and problem-solving skills, adept at distilling complex data into strategic business insights.
• Prior experience automating reporting workflows utilizing AI tools, scripting, or automation platforms preferred.
• Practical familiarity with AI solutions like ChatGPT, Microsoft Copilot, Tableau AI, or similar tools to advance reporting efficiency and productivity.
• Excellent communication and stakeholder engagement skills with an ability to convey insights clearly to business and executive audiences.
• Detail-oriented with superior organizational skills to effectively manage competing reporting deadlines.