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 Data Analytics and AI team has an exciting career opportunity for a full time Senior Data Engineer reporting to the Senior Manager Data Solutions Engineering

This position will work on-site in Miramar Florida

Position Summary:

The Senior Data Solutions Engineer is responsible for building managing and optimizing complex reusable enterprise data pipelines effectively and in a timely manner through the development lifecycle to be used by internal consumers such as business/data analysts and data scientists With the acquisition of Silversea into the Group this role will focus on the integration of Silversea data into the existing data landscape which includes the next-generation data platform that supports the enterprise as well as the Customer Data Platform (CDP) Engineering which is essential to our eCommerce initiatives The Senior 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

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:

• Engage with analysts throughout the organization to understand common data requests and key metrics
• Create and maintain technical design documentation
Lead requirements gathering
• data mapping and designing
Design full lifecycle of data from source to target including data profiling
• data mapping and data cataloguing
Create build
• and maintain complex data pipelines from disparate sources that meet functional / non-functional business requirements
Create maintain and reuse existing ETL/ELT processes
• employing a variety of data integration and data preparation tools
Mentor engineers in finding optimal and efficient solutions for designing preparing and storing data for analytical and operational use cases
Identify design and implement internal process improvements: automating manual processes optimizing data delivery re-designing pipelines for greater scalability
• etc
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:

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
• Clear understanding of data modeling patterns (relational and dimensional)
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)
Manages and develops data processing and assigns customers to marketing segments in the CDP; using demographic data behavioral data
• and intent signals and works with data scientists to incorporate machine learning outcomes into the overall customer segmentation model
Experience with streaming technologies (Kafka Pubsub Kinesis) and log-based architectures and experience writing batch and stream processing jobs (ie Apache Beam Google Cloud DataFlow Apache Spark
• Apache Storm)
• Experienced in performing root cause analysis on internal and external data and processes to identify issues and opportunities for improvement

Knowledge and Skills:

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
Experience with a scripting language: Python Java Scala etc
• 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
Technical capabilities in Erwin or similar
• a plus
Familiarity with reporting tools (Microsoft Power BI Hyperion Oracle OBIEE Tableau)
• a plus
• 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-CF1