Engineer, Data Solutions

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 Solutions Engineering Team has an exciting career opportunity for a full time Data Engineer reporting to the Senior Manager, Data Solutions Engineering.

This role is located in Miramar, CA.

Position Summary

The primary focus of this role will be to support internal organizations in implementing and delivering their strategy and results. The 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 by 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.

Essential Duties and Responsibilities

• 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.
• Work with stakeholders including Product, Data and Business teams to assist with data-related technical issues and support their data needs
• Create datasets for operational reports, key performance indicators/metrics, or other insights into current organizational activities
• Create datasets for 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 moderately complex queries involving multiple tables or databases across platform(s)
• Create and maintain technical design documentation
• Participate in requirements gathering
• Collaborate with the Enterprise Architecture team to ensure alignment on data standards and processes
• Highly analytical and interested in data visualization
• 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
• 3+ years of experience in a data/cloud engineering role
• 3+ years of experience working and creating datasets for a data warehouse
• Clear understanding of data modeling patterns (relational and dimensional)
• 3+ years of experience with ETL development tools, Informatica, Databricks or Azure Data Factory (ADF) preferred
• 3+ years of cloud experience, Azure preferred
• Working knowledge and experience in using best practices in designing, building, and managing data pipelines that require data transformation as well as metadata and workload management
• Working knowledge and experience 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)
• Working knowledge and experience in performing root cause analysis on internal and external data and processes to identify issues and opportunities for improvement
• Experience supporting and working with cross-functional teams in a dynamic environment
• Demonstrate a certain degree of creativity with analytical and problem-solving skills
• Display curiosity in understanding the data for the specific area of responsibility

Knowledge and Skills

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

• Ability to read and write SQL, PL/SQL, and/or T-SQL
• 2+ years of experience with scripting languages, such as Python, R, Java, Scala, etc.
• Knowledge of data storage concepts, such as databases, data warehouses, and data lakes
  • Relational SQL databases, such as Oracle and SQL Server
  • NoSQL databases are a plus
• Proven ability to collaborate with technical peers
• Capable of working independently and as part of a team
• Experience with and understanding of continuous integration and continuous deployment practices
• Agile

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