Carnival Cruise Line offers an online platform that enables travelers to plan and book cruise tours from a range of packages. The Trade Analytics & Reporting Analyst will support cross-functional projects impacting the Trade Sales department, manage data extraction and budget analysis, and collaborate with various internal teams.
Ability to demonstrate successful application of analytical and decision-making skills and Ability to work in fast-paced, multi-tasking environments
Attention to detail, accuracy, thoroughness and A methodical process in performing work assignments are critical. Capable of effectively managing multiple projects simultaneously. Understands basic accounting principles and can develop and manage budgets. Ability to work in A fast-paced environment and adapt easily to change.
Excellent oral and written communication skills. Ability to communicate complex analysis across all levels of the organization in A simple and quickly understandable format with the appropriate amount of detail and explanation.
Must have hands-on experience extracting Data from database application systems such as SAS and SQL developer. Preferred knowledge of the cruise industry.
High proficiency in Microsoft Excel (xlookup, pivot tables, conditionals, etc.), Microsoft PowerPoint, database systems such as SAS and SQL developer, and business intelligence tools such as Tableau and Microsoft Power BI.
Creates and maintains technical knowledge of database/reporting applications such as SQL, SAS, SSRS. Identifies, develops and executes recommendations to increase report automation and efficiencies amongst the Trade Department’s work.
Monitors various department mailboxes as requested by management to address time sensitive ad-hoc reporting requests. Delivers daily, weekly, and monthly budget reports and performance updates. Provides support with any questions regarding the submission and status of invoices.
Audits and monitors the expenses for the Trade Sales department in multiple database platforms, reconciling them versus the approved budget/forecast for each cost center, identifying gaps and providing variance explanations between budget and forecast to management. Conducts General Ledger (GL) verification to ensure expenses are being coded per accounting principles and management guidelines. Provides feedback/support as needed to ensure users adhere to payment guidelines to remain in compliance with company policy.
Attends meetings and collaborates with a diverse group of internal and external stakeholders for functions including and not limited to communicating results, providing input to increase efficiency, and supporting projects from end-to-end across all phases in various categories impacting the Trade Sales department.
Supports projects from end-to-end across all phases in various categories impacting the Trade Sales department. Obtains an in-depth understanding of all Travel Agency commercial terms and contractual agreements to support its execution, including but not limited to sending agreements, providing periodic performance updates for select Travel Agencies and/or stakeholders, and participating in the creation of ad hoc incentive plans.
Qualification
Required
Bachelor's Degree required - Business, Economics, Operations, Finance, or related field.
2-3 years of experience in analytics, project management, problem solving, database management.
Ability to demonstrate successful application of analytical and decision-making skills.
Ability to work in fast-paced, multi-tasking environments.
Attention to detail, accuracy, thoroughness and a methodical process in performing work assignments are critical.
Capable of effectively managing multiple projects simultaneously.
Understands basic accounting principles and can develop and manage budgets.
Ability to work in a fast-paced environment and adapt easily to change.
Excellent oral and written communication skills.
Ability to communicate complex analysis across all levels of the organization in a simple and quickly understandable format with the appropriate amount of detail and explanation.
Must have hands-on experience extracting data from database application systems such as SAS and SQL developer.
High proficiency in Microsoft Excel (xlookup, pivot tables, conditionals, etc.), Microsoft PowerPoint, database systems such as SAS and SQL developer, and business intelligence tools such as Tableau and Microsoft Power BI.
Creates and maintains technical knowledge of database/reporting applications such as SQL, SAS, SSRS.
Identifies, develops and executes recommendations to increase report automation and efficiencies amongst the Trade Department’s work.
Monitors various department mailboxes as requested by management to address time sensitive ad-hoc reporting requests.
Delivers daily, weekly, and monthly budget reports and performance updates.
Provides support with any questions regarding the submission and status of invoices.
Audits and monitors the expenses for the Trade Sales department in multiple database platforms, reconciling them versus the approved budget/forecast for each cost center.
Identifying gaps and providing variance explanations between budget and forecast to management.
Conducts General Ledger (GL) verification to ensure expenses are being coded per accounting principles and management guidelines.
Provides feedback/support as needed to ensure users adhere to payment guidelines to remain in compliance with company policy.
Attends meetings and collaborates with a diverse group of internal and external stakeholders for functions including and not limited to communicating results, providing input to increase efficiency, and supporting projects from end-to-end across all phases in various categories impacting the Trade Sales department.
Supports projects from end-to-end across all phases in various categories impacting the Trade Sales department.
Obtains an in-depth understanding of all Travel Agency commercial terms and contractual agreements to support its execution, including but not limited to sending agreements, providing periodic performance updates for select Travel Agencies and/or stakeholders, and participating in the creation of ad hoc incentive plans.
Preferred
Preferred knowledge of the cruise industry.
Benefits
Cost-effective medical, dental and vision plans
Employee Assistance Program and other mental health resources
Additional programs include company paid term life insurance and disability coverage
401(k) plan that includes a company match
Employee Stock Purchase plan
Holidays – All full-time and part-time with benefits employees receive days off for 8 company-wide holidays, plus 2 additional floating holidays to be taken at the employee’s discretion.
Vacation Time – All full-time employees at the manager and below level start with 14 days/year; director and above level start with 19 days/year. Part-time with benefits employees receive time off based on the number of hours they work, with a minimum of 84 hours/year. All employees gain additional vacation time with further tenure.
Sick Time – All full-time employees receive 80 hours of sick time each year. Part-time with benefits employees receive time off based on the number of hours they work, with a minimum of 60 hours each year.
Complementary stand-by cruises, employee discounts on confirmed cruises, plus special rates for family and friends
Personal and professional learning and development resources including tuition reimbursement
On-site Fitness center at our Miami campus
Carnival Cruise Line offers an online platform that enables travelers to plan and book cruise tours from a range of packages.
