Bachelor's degree in Finance, Accounting, or related field or equivalent experience
3 years of experience in finance, strategic planning, or sales analysis
Proficiency in advanced analytical modeling and data mining principles
Strong analytical, problem-solving, and reporting skills
Experience with creating databases and dashboards
Familiarity with database management software and advanced Excel skills
Responsibilities
Prepare and deliver accurate sales performance reports to inform management
Maintain internal and external sales incentive programs and processes
Collaborate with BI and Marketing Analytics on Tableau dashboards
Continuously enhance reporting to improve decision-making
Analyze financial expenses across North America Sales cost centers
Conduct analysis on channel and market performance metrics
Provide analytical support for strategic projects and ad hoc requests
Benefits
Opportunities for professional development and growth
Collaborative work environment with cross-functional teams
Engagement in analytical projects that influence business strategies
Access to advanced tools such as Tableau and database management software
Full Job Description
JOB SUMMARY:
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 & 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
