Sr. Analyst, Business Intelligence Job Details | Royal Caribbean Cruises Ltd jobs in United States
Royal Caribbean Group
Responsibilities
- Design, develop, and deploy machine learning models and advanced analytics to forecast revenue, optimize pricing, and improve inventory management for Shorex and PCP
- Collaborate with IT and the data engineering team to oversee the migration to the Alpha Data platform, ensuring alignment with business needs, data integrity, and scalable architecture
- Develop Power BI Dashboards to replace all Hyperion queries
- Engineer and maintain robust data pipelines using modern ETL tools and cloud platforms (e.g., Azure, AWS, GCP) to support real-time and batch analytics
- Develop New Data Objects and Power BI dashboards to pull data from the new reservation system
- Assists Shorex and PCP in revenue generation by utilizing data and implementing a wide range of operational as well as analytical solutions and influence the business by effectively communicating results to management
- Helps manage pricing, inventory, and promotional efforts in multiple online systems and provides a wide range of solutions and support to grow onboard revenue
- Ensure data quality, governance, and security across all analytics and reporting activities
- Performs analysis to prove effectiveness of pricing changes during frequent PCP online promotions
- Works closely with Shorex and PCP teams to understand their business challenges and objectives and identify opportunities to develop potential business improvements, and efficiency gains
- Mentor team members and promote best practices in data science, analytics, and technology adoption
- Stay current with emerging technologies, tools, and methodologies in data science, analytics, and cloud computing
- Responds to ad-hoc data and analysis needs while supporting various projects and conducts analyses of business data, evaluate trends and pattern changes, and learn to disperse results in a format appropriate for the audience
- Assists with the development of revenue and Shorex forecasts using benchmarking and other techniques to continually improve the accuracy of these forecasts
- Transform large data sets into insightful components that will effectively develop pricing strategies and lead to continued iterative growth of revenue
- Represents onboard revenue when required specifically with many of the Shared Services departments, to gain support for initiatives
- Performs any other job-related duties assigned by their supervisor or management
- Support reporting, systems to support daily and strategic revenue decisions and analyses for the onboard revenue department, impacting the company’s annual net onboard revenue stream of over $1 Billion
Preferred
- (MBA or MS preferred)
- Familiarization and experience in revenue management, inventory and pricing concepts strongly preferred
- Experience in cruise, casino, hospitality or a similar industry preferred
- SAS, Essbase, Hyperion, and database management/administration (DBM/DBA) preferred
Qualifications
- Four-year Bachelor's or equivalent; or two to three years related financial and business analysis experience and/or training; or equivalent combination of education and experience
- Microsoft Office (Excel, Word, PowerPoint) and basic analytical skills are required
- Proficiency in SQL, Python, Power BI, VBA, Alteryx is required
- Strong written as well as verbal communication skills, interpersonal skills and ability to work in global environment
- Able to define problems, collect data, establish facts, and draw valid conclusions
- Finding and understanding the correct data sources for a given analysis
- Ability to work in a fast-paced environment while managing multiple projects and responsibilities at once with little direction
- Proven experience in project management
- Understanding of the business to validate findings and conclusions and always ensure data integrity and accuracy
- Willingness to accept immediate product and project responsibility
- Facilitate meetings and present solutions to issues with groups while dealing with variety of variables in situations where no standardization exists
- Ability to respond to inquiries from other departments, customers, or members of the business community
- Knowledge and support of Photo, Internet, and all onboard revenue categories, with the ability to analyze and optimize data and reporting for these areas
- Demonstrated experience in database management and administration (DBM/DBA), including support for cloud and on-premises data platforms
- (MBA or MS preferred)
- Familiarization and experience in revenue management, inventory and pricing concepts strongly preferred
- Experience in cruise, casino, hospitality or a similar industry preferred
- SAS, Essbase, Hyperion, and database management/administration (DBM/DBA) preferred
Required skills
- Alteryx, Database Management and Administration, Essbase, Hyperion, Microsoft Office, Power BI, Pricing and Inventory Management, Python, Revenue Management, SAS, SQL, VBA
Preferred skills
Experience
Company
- Global cruise vacation company.
- Miami, Florida, USA
- https://www.royalcaribbeangroup.com