Sr. Analyst, Business Intelligence Royal Caribbean Group - 4.2 Miami, FL Job Details Full-time 13 hours ago Qualifications Performance dashboard reports Financial forecasting Dashboard development Data preprocessing Data visualization software proficiency Financial model construction Business intelligence report generation Dashboard creation support Financial dashboard reporting SQL Business intelligence tools Accounting and finance experience VBA Financial projection model development Macro/VBA editing Productivity software Financial forecasting analysis Excel formulas Query management Project stakeholder communication Cross-functional communication Data analysis software Full Job Description 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 We know there's a lot to consider As you go through the application process our recruiters will be glad to provide guidance and more relevant details to answer any additional questions Thank you again for your interest in Royal Caribbean Group We'll hope to see you onboard soon! 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 Group and each of its subsidiaries prohibit and will not tolerate discrimination or harassment #LI-DG2

Nearest Major Market:

Miami