Revenue Analyst

Capital Vacations - Myrtle Beach, SC

Full-time - Entry Level

Myrtle Beach, SC

Accommodation

About the position

The Revenue Analyst position is a critical role within the Revenue Management team, focused on driving data-driven decision-making to support the hotel's revenue strategy and maximize profitability. The analyst will be responsible for creating, analyzing, and distributing revenue performance reports, utilizing tools like Power BI and Excel to visualize insights effectively.

Responsibilities

• Collect and analyze data from various sources, including PMS, CRS, and RMS, to provide accurate and timely revenue reports.
• Regularly audit data for accuracy, identifying and resolving discrepancies.
• Develop, manage, and maintain daily, weekly, and monthly revenue reports for multiple properties.
• Design dashboards and visualizations in Power BI to make complex data easy to understand and actionable for all stakeholders.
• Ensure reporting tools and processes are streamlined and automated where possible.
• Design and implement Power BI dashboards for revenue insights, demand trends, and performance KPIs, with guidance from the Financial Planning & Analysis team.
• Provide ad hoc reporting and analytics support for special projects and strategic initiatives.
• Continuously optimize Power BI dashboards and reports based on user feedback and evolving business needs.
• Track key revenue metrics, such as ADR, RevPAR, occupancy, and market share, to support revenue management strategies.
• Assist in the preparation of forecasting models to predict future demand and optimize pricing.
• Collaborate with the Revenue Management team and other departments to ensure alignment with revenue goals.
• Present findings and insights to key stakeholders, translating data into actionable recommendations.
• Continuously review and enhance data collection and reporting processes to improve efficiency and accuracy.
• Proactively identify opportunities to improve reporting tools and streamline processes.

Requirements

• Bachelor's degree in Business, Finance, Hospitality, or a related field.
• 1-3 years of experience in revenue management, data analysis, or a similar role in the hospitality industry.
• Knowledge or proficiency in Power BI, including the creation of dashboards, data modeling, and DAX calculations is a plus.
• Advanced skills in Microsoft Excel; experience with SQL or other data tools is a plus.
• Strong analytical skills with the ability to interpret data and communicate findings clearly.
• Detail-oriented and highly organized, with a proactive approach to problem-solving.
• Excellent communication and collaboration skills.

Nice-to-haves

• Experience with SQL or other data tools is a plus.
• Knowledge of DAX calculations in Power BI.