Analyst, Data Visual and BI

Responsibilities include the design, implementation, and development of reporting and analytics solutions, with particular emphasis on Automation Metrics.  Candidate must have strong understanding of data visualization 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. He/She will be responsible for interacting with various departments within Royal Caribbean to find, consolidate & manipulate data from multiple large data sets; to analyze and understand results; and to provide updates and insights as well as maintaining dashboards / reports.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

1. Monitors Revenue Management Automation Actions and Update Management on Daily Project Stats
2. Maintain and Analyze Reporting on Automation Projects to help Quality Control our expanding portfolio.
3. Meet with business stakeholders to clarify and document visibility requirements
4. Meet with technical stakeholders to perform code reviews and elicit feedback
5. Recommend data architecture and engineering structures necessary to support reports and dashboards
6. Works autonomously and with little direction to complete assignments, coordinating business processes, programs and projects based on the outlined strategies and defined directives.
7. Aggregates large data sets in SAS, Excel and other analytical tools for analysis. Develops data strategies specifically around data structures, identifying critical information, as well as the tools used to retrieve and analyze the data. Performs research and analysis on large data sets - data exploration, trending, modeling, etc.
8. Works with management & other team members to understand & clarify data analysis and reporting needs. Provides guidance and insight on data visualization options for report design.
9. Influences business decisions through analytics and identifies actionable, data-driven insights. Makes recommendations and influences the direction of the business by effectively communicating results to a cross functional group as well as department executives.
10. Creates dashboards, automated reports, report templates and presentations. Uses advanced data visualization tools, such as PowerBI, to provide an easy to understand interface for end users to quickly identify key themes within data. Responsible for daily/weekly/monthly reporting on business trends and the status of digital experience initiatives for senior management

KNOWLEDGE AND SKILLS:

1. 2 years of BI & Analytics development experience
2. 1 years of Microsoft Power BI experience
3. Understanding of Forecasting, Data cleansing and Transformations
4. Dashboards, KPIs
5. Strong understanding of SQL and DAX
6. R and R Scripting of visualizations in Power BI
7. Experience working with databases, including Oracle, SQL Server, and AS400
8. Ability to work on complex development BI projects including the proactive identification of issues and coordination of resolutions.
9. Ability to work independently to implement solutions with minimal guidance and communicate effectively with both business and technical stakeholders.

QUALIFICATIONS AND EDUCATION:

1. Four-year Bachelors degree preferably in Mathematics/Statistics/Computer Science/ Economics /Analytics/Business/Engineering  or BS/BA with combination thereof and related analytic work experience/ and or relevant certifications.
2. 2 years of work experience in data analysis, data mining, business case development  or other related analytical projects.
3. Strong proficiency in query/reporting tools, SQL, Advanced Excel, Tableau ( or similar visualization tool), R/SAS/Python or other statistical tools.
4. 2 years of work experience required, with experience performing either strategic digital analysis, financial analysis or business intelligence/marketing analytics highly preferred
5. Experience working with very large data sets (on relational as well as non-relational data stores)
6. Understanding of Forecasting, Data cleansing and Transformations
7. Understanding of SQL and DAX
8. R and R Scripting of visualizations in Power BI
9. Experience working with databases, including Oracle, SQL Server, and AS400
10. Ability to work on complex development BI projects including the proactive identification of issues and coordination of resolutions.
11. Ability to work independently to implement solutions with minimal guidance and communicate effectively with both business and technical stakeholders