Senior Data Engineer

Journey with us! Combine your career goals and sense of adventure by joining our incredible team of employees at Royal Caribbean Group . We are proud to offer a competitive compensation and benefits package, and excellent career development opportunities, each offering unique ways to explore the world.

We are proud to be the vacation-industry leader with global brands — including Royal Caribbean International, Celebrity Cruises and Silversea Cruises — the most innovative fleet and private destinations, and the best people. Together, we are dedicated to turning the vacation of a lifetime into a lifetime of vacations for our guests.

Royal Caribbean Group’s Analytics Team has an exciting career opportunity for a full time Senior Data Engineer reporting to the Senior Manager, Data Solutions Engineering .

Position Summary

The primary focus of this role will be to support internal organizations in implementing and delivering their strategy and results. The Senior Data Solutions Engineer is responsible for building, managing, and optimizing reusable enterprise data pipelines effectively and in a timely manner through the development lifecycle to be used my internal consumers, such as business/data analysts and data scientists. The engineer would use both technical and analytical skills to understand and solve business problems using available resources and current technology stack, while ensuring data governance and data security compliance. They will mentor junior engineers in finding optimal and efficient solutions for designing, preparing, and storing data for analytical and operational use cases.

Essential Duties and Responsibilities

• Create and maintain technical design documentation
• Participate in requirements gathering, data mapping and designing
• Create, build, and maintain data pipelines from disparate sources that meet functional / non-functional business requirements
• Create, maintain and reuse existing ETL processes, employing a variety of data integration and data preparation tools
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing pipelines for greater scalability, etc.
• Reverse engineering existing processes to improve and/or optimize.
• Work with stakeholders including Product, Data and Business teams to assist with data-related technical issues and support their data needs
• Create datasets for: (1) operational reports, key performance indicators/metrics, or other insights into current organizational activities, (2) analytics and data science to provide the ability to uncover the answers to major questions that help organizations make objective decisions and/or gain a competitive edge
• Write, debug and implement complex queries involving multiple tables or databases across platform(s)
• Collaborate with the Enterprise Architecture team to ensure alignment on data standards and processes
• Work with data and analytics experts to strive for greater functionality in data systems
• Position requires on-call and off-hours support

Qualifications, Knowledge, and Skills

• Bachelor of Science in Computer Science, Information Technology or equivalent
• 5+ years of experience in a data/cloud engineering role
• 5+ years of experience working and creating datasets for a data warehouse
• 3+ years of experience with Databricks preferred
• Clear understanding of data modeling patterns (relational and dimensional) and ability to create model recommendations with limited guidance from a modeler
• 5+ years of experience with a scripting language: Python, Java, Scala, etc.
• 5+ years of experience with ETL development tools, Informatica or Azure Data Factory (ADF) preferred
• 3+ years of cloud experience, Azure preferred
• Experienced in using best practices in designing, building and managing data pipelines that require data transformations as well as metadata and workload management
• Experienced in working with large, heterogeneous datasets in building and optimizing data pipelines, pipeline architectures and integrated datasets using traditional and new data integration technologies (such as ETL, ELT, data replication, change data captures, message-oriented data movement, API design, stream data integration and data virtualization)
• Experienced in performing root cause analysis on internal and external data and processes to identify issues and opportunities for improvement
• Expert level knowledge with programming languages including SQL, PL/SQL, T-SQL
• Expert level knowledge with relational SQL databases such as Oracle and SQL Server
• Experience with NoSQL databases are a plus
• Experience supporting and working with cross-functional teams in a dynamic environment
• Proven ability to collaborate with technical peers
• Capable of working independently as well as part of a team
• Strive to provide orientation and direction to junior engineers requiring their expertise
• Experienced with continuous integration and continuous deployment practices
• Ability to approach complex problems with creativity and display analytical and problem-solving skills
• Display curiosity in understanding the data for the specific area of responsibility
• Knowledge and experience working with agile methodologies and tools (such as Jira) a plus

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