Trade Analytics & Reporting Analyst

About the position

The Trade Analytics & Reporting Analyst is responsible for supporting end-to-end cross-functional projects that have a high impact to Trade Sales department at Carnival Cruise Line. This role will be responsible for supporting data extraction from multiple databases, consolidating results, updating dashboards, and providing ad hoc analysis as needed. He/she will also manage, control, and analyze multiple aspects of the Trade Sales budget and forecasting process, facilitating expense submissions and reconciliations for all employees across various cost centers. This role works closely with key inter-departmental functional areas such as Financial Planning and Reporting, Trade Sales, Trade Support, and Accounts Payable.

Responsibilities

• Support data extraction from multiple databases and consolidate results.
• Update dashboards and provide ad hoc analysis as needed.
• Manage, control, and analyze multiple aspects of the Trade Sales budget and forecasting process.
• Facilitate expense submissions and reconciliations for all employees across various cost centers.
• Communicate complex analysis across all levels of the organization in a simple and understandable format.
• Monitor various department mailboxes to address time-sensitive ad-hoc reporting requests.
• Deliver daily, weekly, and monthly budget reports and performance updates.
• Audit and monitor expenses for the Trade Sales department, reconciling them versus the approved budget/forecast.
• Conduct General Ledger (GL) verification to ensure expenses are coded per accounting principles.
• Attend meetings and collaborate with internal and external stakeholders.

Requirements

• Bachelor's Degree in Business, Economics, Operations, Finance, or related field.
• 2-3 years of experience in analytics, project management, problem solving, database management.
• Hands-on experience extracting data from database application systems such as SAS and SQL developer.
• High proficiency in Microsoft Excel, Microsoft PowerPoint, and business intelligence tools such as Tableau and Microsoft Power BI.

Nice-to-haves

• Preferred knowledge of the cruise industry.
• Experience with database/reporting applications such as SQL, SAS, SSRS.

Benefits

• Cost-effective medical, dental and vision plans.
• Employee Assistance Program and other mental health resources.
• 401(k) plan that includes a company match.
• Employee Stock Purchase plan.
• Paid Time Off including 8 company-wide holidays and 2 floating holidays.
• Vacation Time starting with 14 days/year for full-time employees at manager level and below.
• 80 hours of sick time each year for full-time employees.
• Complementary stand-by cruises and employee discounts on confirmed cruises.
• Personal and professional learning and development resources including tuition reimbursement.
• On-site Fitness center at our Miami campus.