Senior Analyst, Financial Data Analytics & Visualization

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 Senior Analyst, Financial Data Analytics & Visualization 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.