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 (i.e. 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