Sr. Analyst, Business Intelligence

Royal Caribbean Cruises Ltd•Miami, FL

2d•Onsite

About The Position

The Sr. Analyst role is responsible for financial analysis and management of North American commission programs that support strategic and tactical sales initiatives, promotional activities, and decision-making. The analyst provides recommendations to sales leadership based on analysis, reporting, and interpretation of sales data; identifies regional sales trends; forecasts sales; supports goal-setting; and calculates and monitors performance to ensure sales effectiveness. The role works with Revenue Planning, Revenue Management, Finance, and Accounting to align work with corporate goals and initiatives. The position is based on-site in Miami, Florida. It includes leading monthly North American commission certification, managing multiple budgets totaling more than $50 million, reconciling external payments to travel agencies with Accounting, and developing trade commission programs. The analyst also develops reporting and financial models, prepares analyses and presentations, supports projects, and makes recommendations to sales management and business leadership.

Requirements

Bachelor’s degree (BA) from a four-year college or university, or equivalent work experience.
Two to four years of related experience in financial or business analysis or a related field is preferred.
Analytical skills to interpret data trends.
Excellent knowledge of Microsoft Word, Excel, and PowerPoint.
Detail-oriented approach to ensure accuracy in data and analysis.
Ability to present information effectively to executive management and public groups.
Ability to work, interact, and communicate with internal and external customers at all levels.
Ability to apply fractions, percentages, ratios, and proportions to practical situations.
Ability to define problems, collect data, establish facts, and draw valid conclusions.
Ability to interpret technical instructions in mathematical or diagram form and handle abstract and concrete variables.
Ability to work independently on projects and as part of a cross-functional team.
Ability to solve complex problems with varied factors where no standardization exists.

Nice To Haves

Master of Business Administration (MBA) or other master’s degree.
Previous experience with Sales or Marketing.
Knowledge of Hyperion, Brio, Access, Microsoft Project, Visio, Lotus Notes, and the AS400 or an equivalent mainframe reservations system.

Responsibilities

Lead monthly North American commission certification.
Manage multiple budgets totaling more than $50 million.
Reconcile external payments to travel agencies in coordination with Accounting.
Gather, analyze, and interpret data, including sales trends by region, product, account, market, or segment.
Develop, implement, and enhance business reporting and develop financial models and projections for complex business problems.
Provide information and recommendations to leadership on regular and ad hoc matters.
Provide analytical support for tactical and strategic special projects.
Prepare reports and presentations for all levels of the department, including executive-level analysis and presentations.
Build productive working relationships with Sales Managers, Directors, Executives, peers, and colleagues across departments.
Track departmental metrics and interpret data to recommend sales strategies, process execution, and revenue opportunities or risks.
Provide decision support to Sales and business leadership through analysis and tracking of sales and product performance.
Coordinate with other departments to identify policy changes or projects affecting processes and develop solutions.
Track and report results against initiatives and programs, and recommend timely improvements.
Develop new reports and revise or maintain existing reports and operational procedures.
Develop trade commission programs.