Sr. Analyst, Business Intelligence

Royal Caribbean Group; Miami, Northern (FL, KY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Royal Caribbean Group, based in Miami, seeks a Sr. Analyst, Business Intelligence to design and deliver financial reporting and analytics solutions. You will build data stories using Power BI, Python, and Excel, partnering with departments to collect data and produce dashboards and reports.

The role emphasizes data visualization, finance principles, and rigorous analysis under tight timelines, reporting to the AVP of Technology Finance. Onsite in Miami, FL.

Qualifications

• Four-year Bachelor’s degree (BS/BA) in Analytics/Business/Statistics/Engineering or related field with analytic work experience and/or certifications.
• At least 2 years of BI/Analytics development in finance/accounting related fields.
• Strong proficiency in Power BI, Excel, SQL, and preferably Python.
• Experience with large databases such as Databricks, JDE, Oracle, SQL Server, and AS400.
• Ability to work independently and communicate effectively with business and technical stakeholders.

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.
• 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 to support reports and dashboards.

Skills

Power BI

SQL

Excel

Python

Data Visualization

Finance/Accounting

Data Modeling

Stakeholder communication

Education

BS/BA in Analytics or related field

Tools

Databricks

JDE

Oracle

SQL Server

AS400

Job description

Select how often (in days) to receive an alert:

Journey with us! Combine your career goals and sense of adventure by joining our exciting team of employees. Royal Caribbean Group is pleased to offer a competitive compensation and benefits package, and excellent career development opportunities, each offering unique ways to explore the world.

The Royal Caribbean Group has an exciting career opportunity for a full time Sr. Analyst, Business Intelligence reporting to the AVP of Technology Finance .

Position is onsite and based in Miami, FL

Responsibilities include the design, implementation, and development of financial reporting and analytics solutions, with particular emphasis on Data Analytics, Visualizations, and Financial Modeling.The candidate must have strong understanding of data visualization, finance/accounting principles and an ability to deliver engaging, informative data stories using a variety of techniques and tools. This individual is capable of working under minimal supervision and tight timelines. He/She will be responsible for interacting with various departments within Royal Caribbean to collect, aggregate and process data from large databases and flat files; to analyze and interpret results; and to create visually appealing reports, presentations and dashboards.

Essential Duties and 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.
• Not directly responsible for budgeting or achievement of revenue targets.
• Performs other duties as required.

Qualifications, Knowledge and Skills:

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

The position is not eligible for work authorization sponsorship.

It is the policy of the Company to ensure equal employment and promotion opportunity to qualified candidates without discrimination or harassment on the basis of race, color, religion, sex, age, national origin, disability, sexual orientation, sexuality, gender identity or expression, marital status, or any other characteristic protected by law. Royal Caribbean Groupand each of its subsidiaries prohibit and will not tolerate discrimination or harassment.