Senior Analyst Sales Position Available In Miami-Dade, Florida

Job ID11053
Location
Miami, FL
Full/Part TimeFull-Time
Regular/TemporaryRegular Responsibilities

BASIC PURPOSE

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.

POSITION 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.

KNOWLEDGE AND EXPERIENCE

EDUCATION:

Bachelor’s degree in Finance, Accounting or related field of study; or any equivalent combination of relevant background and work experience.

EXPERIENCE

3 years’ experience including but not limited to finance, strategic planning, sales analysis or related analytical experience, data analytics/reporting.

KNOWLEDGE & SKILLS

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. Knowledge of travel/cruise industry and reservation/revenue management systems, Essbase and Hyperion preferred.