Business Intelligence Analyst

Virgin Hotels•Las Vegas, NV

About The Position

The Business Intelligence Analyst, Revenue Management will play an important role by creating and maintaining all revenue management and hotel daily, weekly, monthly, and ad hoc reporting and analyzing data to provide strategic recommendations for optimizing revenue strategy. This position will be responsible for transforming complex hotel data into actionable insights that drive room inventory optimization, pricing strategies, and overall profitability. You will serve as the bridge between technical data environments and executive decision-makers, ensuring our revenue strategies are backed by accurate, real-time analytics. The Business Intelligence Analyst will be responsible for managing the reporting needs to support the strategies set by the Executive Director of Revenue Management and Vice President of Hotel Operations and Revenue.

Requirements

Current, legal, and unrestricted ability to work in the United States
High school or equivalent education required
Communicate clearly in verbal and written English
Ability to work a flexible schedule
Proficiency in BI and visualization tools
Exceptional SQL skills for data extraction and manipulation
Advanced Microsoft Excel capabilities, including pivot tables, complex formulas, and VBA.
Experience with hotel technology systems like PMS, RMS, CRS, GDS, and Channel Managers.
Effective communication skills
Must have a strong foundation in the hospitality industry
Strong problem-solving skills and the ability to translate technical data into simple, actionable language for non-technical stakeholders
Detail-oriented with a meticulous focus on data accuracy and integrity
Great team player with the ability create excellent working relationships across the group Collaborative approach with all departments
Candidates must have a strong attention to detail
Ability to break down barriers and resolving potential conflicts swiftly and effortlessly
Strong communication and presentation skills to all levels of management
Creativity and innovation are essential!
Ability to think outside the box and approach all issues with a completely fresh approach
Candidates must think on their feet and use their initiative to solve problems and deliver solutions
Able to change direction and work on multiple project aspects at once
Enthusiastic, passionate, able to enthuse and motivate others
Leadership ability and behavior consistent with Virgin Hotels Core Values: Fun, innovative, original and personable, and striving to deliver high quality and brilliant customer service

Nice To Haves

Bachelor's degree in Business Administration, Hospitality Management, Finance, Data Analytics, or a related quantitative field
Minimum of two years in a business intelligence analyst capacity with experience in a hotel/casino resort environment is strongly preferred
Knowledge of the discipline of Revenue Management
Knowledge of financial reports, cashier audits and hotel accounting procedures.
Effective communication and sales skills, strong computer literacy

Responsibilities

Develop and maintain automated and recurring reports to track key performance indicators (KPIs) such as RevPAR (Revenue Per Available Room), ADR (Average Daily Rate), and occupancy rates
Analyze historical booking patterns, market trends, and competitor data to identify revenue opportunities and potential risks
Assist in creating accurate daily, weekly, and monthly demand forecasts to guide staffing, pricing, and marketing efforts
Provide analytical support for pricing and yield tests, evaluating the return on investment (ROI) for various promotional initiatives and guest engagement tools
Ensure data accuracy and consistency through validation, testing, and quality assurance processes across BI systems
Provide timely support for ad-hoc data requests, research inquiries, and issue resolution
Partner with Sales, Marketing, and Operations teams to align property-wide revenue goals and ensure data integrity across all system
Manage data extraction and transformation from various sources, including Property Management Systems (PMS), and Revenue Management Systems (RMS)
Design, develop, troubleshoot, and debug VBA macros to automate data entry, processing, and reporting
Develop, optimize, and maintain queries, stored procedures, views, reports, and SQL/analytics processes
Support and maintain reporting using SQL and VBA based on hotel data sources.
Assist in evaluating and implementing enhancements to BI tools, processes, and data architecture
Building and maintaining strong working relationships with all levels of staff