Sr Analyst Sales

Norwegian Cruise Line•Miami, FL

About The Position

Responsible for supporting the Sales Analytics and Planning team by collecting accurate data, processing, modeling and analysis. Consolidate data from several different systems and sources to provide department timely and accurate information. Benchmark and compare agencies against peer set and provide recommendations and strategies to focus on most profitable agencies while reducing expense to underperforming agencies. Work closely with BI and Marketing Analytics to maintain decisive reporting to measure key metrics of sales performance.

Requirements

Bachelor's degree in Finance, Accounting or related field of study or any equivalent combination of relevant background and work experience
3 years experience including but not limited to finance, strategic planning, sales analysis or related analytical experience, data analytics/reporting.
Must understand advanced analytical modeling and/or accounting practices and techniques, including knowledge of data mining principles: predictive analytics, mapping, collecting data from multiple data systems on premises and cloud-based data sources
Understanding of and experience using analytical concepts and statistical techniques including analyzing data, drawing conclusions, and developing actionable recommendations for business units
Experience working with and creating databases and dashboards using all relevant data to inform decisions
Excellent problem solving, quantitative and analytical abilities
Excellent analysis and reporting capabilities, and extensive knowledge of market and regional trends and behaviors, as well as lead management
Strong ability to work with numerous processes and projects simultaneously
Excellent communication and collaboration skills
Ability to manage multiple priorities and deadlines under pressure
Experience with Microsoft office required
Advanced use of Excel, Tableau and Essbase preferred
Excellent working knowledge of database management software and advanced Excel with ability to write macros

Nice To Haves

Knowledge of travel/cruise industry and reservation/revenue management systems, Essbase and Hyperion preferred

Responsibilities

Prepare periodical and accurate reporting from various sources to provide actionable information and insights to team members and management.
Maintain internal/external sales incentive programs along with supporting processes including revenue breakout and agency alignment.
Prepare periodical and accurate reporting from various sources to provide actionable information and insights to team members and management.
Liaise with Business Intelligence and Marketing Analytics team(s) to maintain best in class Tableau dashboards and business objects reporting.
Continually review reporting and propose changes to enhance reporting effectiveness.
Prepare monthly financial expense variance reporting and consolidate explanations across the North America Sales cost centers while providing potential prospective impact from results.
Maintain and catalogue periodical analysis and reporting distributed to internal and external customers inclusive of all tableau dashboards and business objects reports inclusive or purpose and overview.
Run analysis for channel performance, market performance, booking volume, yield, account performance, including various metrics, etc).
Run routine cost of sale analysis inclusive of all direct expenses associated with each NA channel and travel agency segmentation.
Continually enhance and develop return on investment analysis and provide recommendation to Sales Leadership for programs to drive demand in the most profitable manner.
Ensure accuracy of data and deliverables of reporting employees with comprehensive policies and processes.
Perform special projects and provide analytical support to internal customers ranging from Corporate Finance, Revenue Management and Operations.
Must rely on extensive experience to coordinate and reconcile various financial reporting systems to properly measure and evaluate corporate performance.
Perform various ad hoc analysis to provide internal/external customers analytical support.
Perform other job-related functions as assigned.