Sr. Analyst, Business Intelligence

Royal Caribbean Cruises Ltd•Miami, FL

2d•Onsite

About The Position

Royal Caribbean Group is seeking a full-time Sr. Analyst, Business Intelligence to join their team in Miami, FL. This role reports to the AVP of Technology Finance and is an onsite position. The analyst will be responsible for designing, implementing, and developing financial reporting and analytics solutions, with a focus on data analytics, visualizations, and financial modeling. The ideal candidate will have a strong understanding of data visualization, finance/accounting principles, and the ability to create compelling data narratives. This individual must be capable of working independently under tight deadlines, interacting with various departments to gather and process data, analyze results, and create visually appealing reports, presentations, and dashboards.

Requirements

Four-year Bachelor’s degree (BS/BA) or an advanced degree, preferably in Analytics/Business/Statistics/Engineering or closely related field with combination thereof and related analytic work experience and/or relevant certifications, including but not limited to reputable data analytics certificates, CPA, CFA.
At least 2 years of work experience (excluding capstone projects) in data analysis, data mining, business case development or other related analytical projects in finance/accounting related fields. Experienced in performing either strategic analysis, financial analysis or business intelligence/marketing analytics.
Strong proficiency in query/reporting tools, including but not limited to Power BI, Advanced Excel, SQL, and preferably Python.
Experience working with large databases, including Databricks, JDE, Oracle (including EPM), SQL Server, and AS400.
Proven ability to create polished, user-focused data visualizations and dashboards that reflect strong aesthetic judgment and design sensibility.
Ability to work independently on tight timelines to implement solutions with minimal guidance and communicate effectively with both business and technical stakeholders.
2 to 4 years of BI & Analytics development experience.
Strong command of Power BI, SQL, Advanced Excel (VBA and visualizations), Microsoft Office Suite and preferably Python.
Proficiency in financial forecasting and modeling, as well as data cleansing and processing.
Ability to work on complex development BI projects including the proactive identification of issues and coordination of resolutions.
Ability to work independently to implement solutions with minimal guidance and communicate effectively with both business and technical stakeholders.
Advanced analytical skill set includes critical thinking, and detail oriented.
Excellent verbal and written communication skills and interpersonal skills for interacting with external and internal partners and delivering recommendations and results to senior management.
Results-oriented team player.

Responsibilities

Collect and process raw data from various sources into report ready format using SQL, Python, Microsoft Power Query.
Design, implement and develop data visualizations using Power BI, Python, and Microsoft Office Suite.
Create financial/investment models using advanced features in Excel.
Meet with business stakeholders to clarify and document reporting requirements.
Recommend data architecture and business structures necessary to support reports and dashboards.
Work autonomously and with little direction to complete assignments on tight timelines, coordinating business processes, programs and projects based on the outlined strategies and defined directives.
Aggregate large data sets for analysis. Develop data strategies specifically around data structures, identifying critical information, as well as the tools used to retrieve and analyze the data. Perform research and analysis on large data sets—data exploration, trending, regression, and/or basic machine learning.
Work with management and other team members to understand and clarify data analysis and reporting needs. Provide guidance and insight into data visualization options for report design.
Make actionable recommendations by effectively communicating data analytics insights to a cross-functional group as well as department executives.
Create dashboards, automated reports, report templates and presentations. Use advanced data visualization tools, such as Power BI and/or Python, to provide clear, intuitive, and visually compelling interface that are well-designed for end users to quickly identify key themes and insights within data. Responsible for daily/weekly/monthly reporting on business trends and the status of digital experience initiatives for senior management.
Performs other duties as required.