Senior analyst, Data architecture

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’s E-commerce Data and Analytics Team has an exciting career opportunity for a full-time Senior Analyst, Data architecture reporting to the Senior Manager RM Dev and systems

The position is onsite and based in Miami, Florida.

PositionSummary:

The Senior Analyst will play a key role in supporting the migration of the new reservation system database to a new platform by performing detailed data analysis, validation, and transformation activities. This position is responsible for assessing data quality, mapping legacy structures to the new schema, developing testing scenarios, and ensuring the accuracy and integrity of migrated data. The Senior Analyst will collaborate closely with database administrators, developers, and business stakeholders to document requirements, identify risks, and support end-to-end testing and reconciliation. The ideal candidate has strong analytical and SQL skills, experience with large-scale transactional or reservation systems, and a solid understanding of database environments and migration methodologies. Attention to detail, problem-solving ability, and cross-functional communication are critical for success in this role.

• EssentialDutiesandResponsibilities:
  
  Database management: 

• Proficiency with different database technologies (Oracle, Databricks) 

• Familiarity with various database management systems like MySQL, Oracle, and SQL Server. 

• SQL Query Optimization: 

• Writing and optimizing complex SQL queries for efficient data retrieval, manipulation, and reporting. 

• Troubleshooting and Performance Tuning: 

• Identifying and resolving issues within Python applications and SQL databases and optimizing performance for scalability and efficiency. 

• ETL (Extract, Transform, Load) skills: 

• Designing and implementing ETL processes and workflows. 

• Knowledge of ETL tools  

• Data warehousing: 

• Understanding of data warehouse concepts, structures, and best practices. 

• Implementing and maintaining data warehousing solutions. 

• Cloud computing: 

• Familiarity with cloud platforms and services like AWS, Azure, or Google Cloud. 

• Ability to design and deploy data solutions in a cloud environment. 

• Data security: 

• Ensuring data security, privacy, and compliance with relevant regulations. 

• Implementing data encryption, masking, and auditing techniques. 

2. Data quality management: 

• Ensuring that the data is accurate, available, and reliable. 

• Implementing data quality frameworks and validation processes. 

• Working with data scientists, analysts, and other developers to understand requirements and deliver effective solutions. 

3. Business acumen: 

• Understanding business objectives: 

• Comprehending the company’s goals and translating them into data architecture and management strategies. 

• Strategic planning: 

• Ability to develop and implement strategic plans related to data acquisition, storage, and usage to support business objectives. 

• Regulatory compliance: 

• Knowledge of data-related regulations and standards in the relevant industry. 

• Ensuring that data architecture and practices comply with these standards. 

4. Communication skills 

• Documentation: 

• Creating clear and comprehensive documentation related to data architectures, systems, and processes. 

• Communication: 

• Effectively communicating complex data concepts to non-technical stakeholders. 

• Collaborating with various departments and IT teams to align data strategies with organizational needs. 

5. Infrastructure / Cloud

• Provision and configure target infrastructure (on-premises or cloud). 
• Manage networking, storage, and compute resources. 
• Optimize performance and cost in cloud environments. 

6. QA / Testing

• Define and execute migration testing plan (functional, performance, regression). 
• Validate data accuracy, completeness, and consistency. 
• Conduct user acceptance testing (UAT) with business stakeholders. 
• Verify reports, dashboards, and downstream data feeds. 

7. Post-Migration Support 

• Monitor system performance and resolve issues. 
• Validate ongoing data synchronization (if hybrid). 
• Conduct lessons learned and finalize documentation

Qualifications, Knowledge and Skills:

• 
  Master’s degree in computer science, Engineering, Information Systems, Business or related field preferred.
• Bachelor’s degree from four-year college or university required (in Computer Science, Information Systems, Data Analytics, or related field).
• 6-8 years of work experience in related field preferred.

• Experience and Skills:
  
  Proficiency with different database technologies (Oracle, Databricks), knowledge of RDBMS (Oracle, MySQL, SQL Server) and NOSQL, and experience with Cloud databases.
• Ability to code in SQL and Python to manipulate data
• Ability to create conceptual, logical, and physical data models, including normalization/denormalization, OLTP, OLAP, Star schemas.
• Experience with tools to design and implement ETL processes and workflows, implementing Python/Spark-based pipelines that are scalable and optimized for performance
• Understanding of data warehouse concepts, structures, and best practices, and ability to design and deploy data solutions in a cloud environment.
• Experience establishing data security, privacy, and compliance frameworks and guidelines, implementing data encryption, masking, and auditing techniques.
• Experience implementing frameworks for data quality management, ensuring data accuracy, proper testing, validation, and data availability.
• Ability to align company goals with data architecture and management strategies, to build data acquisition, storage, and usage capabilities to support business objectives.
• Experience planning phases of new development, migration, and system building, including cut-over and roll back strategies.
• Ability to provide clear and comprehensive documentation related to data architectures, systems, and processes.
• Experience communicating complex data concepts to non-technical stakeholders and effectively collaborating with various departments to align data strategies with organizational needs
• Experience leading projects and teams towards achieving data-related objectives, delivering multiple projects simultaneously and ensuring timely delivery
• Experience mentoring engineers and analysts on architecture, data development, performance tuning, and cloud design

Power Skills:

• Action Oriented
• Collaborates Effectively
• Communicates Effectively
• Drives Results
• Situational Adaptability

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