Senior analyst, Data architecture

Royal Caribbean Cruises Ltd•Miami, FL

104d•Onsite

About The Position

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.

Requirements

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