Lead, Data Solutions 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 Lead, Data Solutions Engineer reporting to the Senior Manager, Data Solutions Engineering.

This role will work in-person in Miramar, Florida.

Position Summary

The Lead Data Solutions Engineer is responsible for leading the delivery, managing and operationalizing data solutions pipelines in support of data and analytics use cases using appropriate methodologies, technologies including extract, transform and load of data. The Lead Data Solutions Engineer is also responsible for recommending innovative and modern tools, techniques and architectures to automate the most-common, repeatable and tedious data preparation and integration tasks in order to minimize manual and error-prone processes and improve productivity. The Lead Data Solutions Engineer develops and improves standards and procedures to support quality development, testing, and production support. The role is expected to drive/lead the delivery of one or more data solution components/products from project inception through its delivery in close collaboration with cross-team members, which includes functional and technical resources.

Essential Duties and Responsibilities

• Leads data engineering development projects which include the design of complex flexible, durable, reusable and scalable data pipelines and frameworks to automate the ingestion, processing and delivery of both structured and unstructured batch and real-time streaming data employing a variety of data integration and data preparation tools for on premises and cloud for different business scenarios.
• Collaborate team with other areas such as business stakeholders, data scientists to ensure that all solutions are complete, operable, conform to business processes, and meet the business needs with the agreed quality of service
• Lead technical decisions and ensure data quality and efficiency.
• Create and maintain technical design documentation.
• Ensure the end-to-end solution is fit for purpose, meet the needs of business, the agreed requirements, and are both pragmatic and supportive of the strategic architecture direction
• Evaluates ETL/ELT best practices within the industry to learn principles and applications and drive development adoption
• Lead and mentor teams, communicate technical concepts effectively, and collaborate with diverse teams.
• Evaluates the effectiveness of data integration tools and assist in platform discussions and decisions
• Leads data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
• Anticipates any obstacles and makes plans accordingly to ensure that stakeholder requirements are fully reflected in data architecture outcomes.
• Monitors data architecture design processes (e.g. interface to data), in accordance with existing processes and standards.

Qualifications, Knowledge, and Skills

• Bachelor or Master of Science in Engineering, Computer Science, Information Technology or equivalent
• 8+ years of experience in Data Warehouse design and data modeling patterns (relational and dimensional)
• 8+ years of experience with ETL tool development such as Informatica or Talend or ADF
• Must have strong analytical skills for effective problem solving
• Ability to work independently, handle multiple tasks simultaneously and adapt quickly to change with a variety of people and work styles.
• Must be capable of fully articulating concisely technical concepts to non-technical audiences.
• Experience cloud-based data warehousing and data lake solutions like Databricks, Redshift or Snowflake
• Strategic thinker able to provide recommendations utilizing traditional and modern architectural components based on business needs
• Extensive ability to design, build and manage data pipelines for data structures encompassing data transformation, data models, schemas, metadata and workload management.
• Expertise in data warehousing, ETL/ELT processes, data modeling, and programming languages like SQL, PL/SQL, Python, and Java.

• Experience with cloud platforms like Azure, AWS or GCP, and related services.
• Experience with data engineering tools like Kafka, Spark, DataBricks and Hadoop
• Extensive experience in one of the following tools:  Informatica, ADF or Talend
• Strong analytical abilities to identify and resolve data-related issues.
• Extensive experience with database technologies: Oracle, MSSQL, Hadoop and NoSQL
• Extensive experience with various Data Management architectures like Data Warehouse, Data Lake and the supporting processes like Data Integration, Governance, Metadata Management
• Extensive experience in working with large, heterogeneous datasets in building and optimizing data pipelines, pipeline architectures and integrated datasets using traditional data integration technologies. These should include [ETL/ELT, data replication/CDC, message-oriented data movement] and data ingestion and integration technologies such as stream data integration, and data virtualization.
• Extensive experience in working with and optimizing existing ETL processes and data integration and data preparation flows and helping to move them in production
• Extensive experience writing and optimizing advanced SQL queries in a business environment with large-scale, complex datasets
• Experience with one or more DevOps tools (git, Jenkins, CI/CD, Jira)
• Experience developing reference architecture, principles and standards
• Strong knowledge of relational and dimensional data modeling patterns.

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