Senior Business Analyst - Revenue Management (US Shift)

Job description

G6 Hospitality (Prism) is looking for a Senior Business Analyst to join the Revenue Management team, supporting both Franchise-Owned and Company-Owned business. This role will be central to building data-driven decision-making capabilities for the Revenue function - translating large volumes of performance, pricing, and demand data into clear insights, automated dashboards, and actionable recommendations. **The ideal candidate combines strong technical analytics skills (SQL, Python) with business acumen in hospitality revenue management, and has an active interest in using AI/automation tools (including Claude) to streamline recurring analytical workflows.** **This role is for US shift (6PM-3AM)** **Key Responsibilities** **Data Analysis & Reporting** - Analyze RevPAR, ADR, Occupancy, and other key revenue performance metrics across Franchise-Owned and Company-Owned portfolios to identify trends, risks, and opportunities. - Build, maintain, and continuously improve recurring performance reports (daily, weekly, monthly, quarterly) for Revenue Management and leadership stakeholders. - Conduct deep-dive and ad hoc analyses on pricing strategy, demand patterns, channel mix, and competitive positioning. **Dashboard Creation & Automation:** - Design and build interactive dashboards (e.g., Power BI, Tableau, or equivalent) that consolidate data from multiple sources into a single source of truth for Revenue stakeholders. - Automate manual, repetitive reporting processes using SQL, Python, and scripting to reduce turnaround time and minimize errors. - Own end-to-end data pipelines - extraction, transformation, validation, and visualization - ensuring data accuracy and consistency. **Revenue Management Support** - Partner with Revenue Managers to evaluate pricing decisions, forecast accuracy, and the effectiveness of revenue strategies across both business models. - Support PMS/RMS-related data requirements, including documentation of reporting logic, data definitions, and system requirements (PRDs) as needed. - Monitor and flag anomalies in performance data, proactively surfacing insights before they are requested. **Process Improvement & AI Enablement** - Identify opportunities to apply AI/automation tools - including Claude - to streamline data processing, reporting, and routine analytical tasks. - Document and standardize analytical processes (SOPs) to ensure consistency, scalability, and ease of knowledge transfer across the team. - Continuously evaluate and recommend tools or workflow improvements that increase the team's analytical efficiency. **Required Skills & Qualifications** - 2-5 years of experience in a Business Analyst, Data Analyst, or Revenue Analyst role, preferably within hospitality, travel, or a related data-intensive industry. - B.Tech/MBA - Tier 1 Institute. - Strong proficiency in SQL for querying, joining, and manipulating large datasets across multiple sources. - Working proficiency in Python for data analysis, automation scripting, and process optimization (pandas, numpy, or equivalent libraries). - Hands-on experience building dashboards and visualizations using tools such as Power BI, Tableau, or similar BI platforms. - Demonstrated experience automating manual reporting workflows, reducing reporting cycle times, or building self-serve reporting solutions. - Strong analytical and problem-solving skills, with the ability to translate complex data into clear, actionable business recommendations. - Solid understanding of core hospitality/revenue management metrics (RevPAR, ADR, Occupancy, Forecast Accuracy) is a strong plus. - Excellent communication skills, with the ability to present data-driven insights to non-technical stakeholders and senior leadership. - Bachelor's degree in Business, Statistics, Computer Science, Engineering, or a related quantitative field. **Comfortable working in US shift (6PM-3 AM)** **Added Advantage** - **Experience using Claude (Anthropic) or similar AI tools to automate analytical workflows, generate code, build documentation, or accelerate reporting processes.** - Exposure to PMS (Property Management Systems) or RMS (Revenue Management Systems) data structures and reporting requirements. - Familiarity with cloud data warehousing tools (e.g., Snowflake, BigQuery, Redshift) or data pipeline/ETL tools. - Prior experience supporting both franchise and company-owned business models within a multi-unit or distributed business environment. **What We Offer** - The opportunity to shape analytics and automation capabilities for a high-impact Revenue Management function. - Exposure to both franchise and company-owned business operations within a large, multi-property hospitality portfolio. - A collaborative environment that encourages adoption of modern AI and automation tools to drive efficiency. - Competitive compensation and growth opportunities within the Revenue Management organization. - Experience using Claude (Anthropic) or similar AI tools to automate analytical workflows, generate code, build documentation, or accelerate reporting processes. - Exposure to PMS (Property Management Systems) or RMS (Revenue Management Systems) data structures and reporting requirements. - Familiarity with cloud data warehousing tools (e.g., Snowflake, BigQuery, Redshift) or data pipeline/ETL tools. - Prior experience supporting both franchise and company-owned business models within a multi-unit or distributed business environment.