Senior Data Analyst

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.

POSITION SUMMARY:

The Senior Data Analyst/Modeler is responsible for both the theory and practice of making RCG a data-driven organization.  In this role, the Senior Data Analyst/Modeler will design, develop and manage data solutions for use by internal stakeholders in all areas of RCG including Product Management, Revenue, Sales, Marketing, Digital, to name a few. Working closely with Data Solutions Engineering, he or she will architect data definitions and structure and oversee the ETLs that populate them in order to deliver meaningful, high-quality data to downstream users and platforms, including data scientists, business and product analysts, reporting platforms, and automated processes.

• Strong experience in requirements engineering and the design, development, and deployment of ETL and Data Modeling.
• A broad set of skills and knowledge including software, systems and solution development spanning multiple technical domains
• Strong communication skills including the ability to socialize, influence and gain support for proposed technology and solution architectures from the business and IT community.
• Technical team leadership, mentorship, and collaboration as well as the ability to cultivate strong working relationships with end-users, peers, and vendors

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Key areas of responsibility in descending order, with the responsibility requiring the most amount of time first.

1. Gather and document business use cases with stakeholders
2. Analyze and interpret data to be modelled into the enterprise data platform
3. Design full lifecycle of data from source to target including data profiling, data mapping and data cataloguing.
4. Draw on deep experience with data management and analysis to identify improvements and increase efficiency, reliability, and usability of data across the organization.
5. Collaborate with product managers and analysts to understand business rules.
6. Indirectly manage and define requirements for engineers developing new data pipelines, database infrastructure and instrumentation.
7. Define and enforce standards for the data platform.
8. Engage with analysts throughout the organization to understand common data requests and key metrics.
9. Define and document the underlying metrics and design robust infrastructure (ETLs, table structures, metadata) to enable consistent reporting on those metrics throughout the organization.
10. Enable measurement of product KPIs within KPIs that align with product managers and data engineering.
11. Work with engineers to ensure automated quality testing and failure detection is embedded throughout every data pipeline.
12. Directly manage resources to perform data analysis as required

QUALIFICATIONS:

Minimum level of education and experience required to perform this job:

1. 7+ years of experience with data in a cross-functional role (analytics, business intelligence, data science, data warehousing, product management)
2. Bachelor’s degree or similar work experience in a technical discipline (information science, mathematics, computer science, econometrics, etc.)
3. Expert-level skills in SQL (preferably in more than one dialect), ideally with exposure to both SQL and NoSQL databases
4. Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
5. Expertise in data modelling concepts and database design
6. Experience in management and administration of cloud computing resources, preferably MS Azure Cloud Platform
7. Proven ability to overcome the challenges of processing large, structured datasets (tens of billions of rows)
8. Well-versed in the tradeoffs of different data storage approaches (row-oriented vs columnar, relational vs. non-relational, structured vs. unstructured)
9. Exposure to big data and real-time event data streaming
10. Setting and ensuring data platform standards for the management, governance, and usage of data

KNOWLEDGE AND SKILLS:

Specific knowledge and skills necessary to perform this job related to the Essential Duties and Responsibilities identified above. Technical capabilities in:

1. Erwin or similar
2. Oracle, SQL Server, Synapse, Couchbase (cloud and on-prem)
3. DW modeling
4. SQL
5. ETL concepts (working knowledge of Informatica Cloud, Informatica PowerCenter, ADF, and/or Talend)
6. Reporting tools (Microsoft Power BI, Hyperion, Oracle OBIEE, Tableau)
7. Data governance (knowledge collecting, keeping, cataloging, and using data efficiently)

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!

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-MP1