Senior ETL Architect

Join the Ritz-Carlton Yacht Collection:  Where Every Voyage is a Symphony of Luxury

Embark on an extraordinary journey with the Ritz-Carlton Yacht Collection, an exquisite extension of the renowned Ritz-Carlton brand, dedicated to redefining ultra-luxury hospitality at sea. As a "Lady or Gentleman" of our esteemed team, you'll be entrusted with the art of delivering the impeccable "Gold Standards" that have made the Ritz-Carlton an epitome of excellence across the globe.

The Essence of Excellence: The Gold Standards
The Gold Standards are the bedrock of the Ritz-Carlton experience, setting us apart in the industry and establishing a legacy of unparalleled service. These standards embody the values and culture that define our brand, and serve as the compass guiding our every endeavor.

The Employee Promise

At The Ritz-Carlton, our Ladies and Gentlemen are the most important resource in our service commitment to our guests.  By applying the principles of trust, honesty, respect, integrity and commitment, we nurture and maximize talent to the benefit of each individual and the company.  The Ritz-Carlton fosters a work environment where diversity is valued, quality of life is enhanced, individual aspirations are fulfilled, and the Ritz-Carlton Mystique is strengthened.

Join us on a journey where every day is a testament to the highest standard of luxury and service. Apply now and be part of an unparalleled legacy in hospitality.

Job Summary

The Senior ETL Architect will be responsible for architecting, designing, developing, maintaining, and performance tuning our data infrastructure, including data lake and data warehouse solutions, ETL processes, ETL mappings, ETL Jobs and Schedules, Data Profiling & Data Cleansing, under the purview of data governance practices. You'll work in a collaborative environment to ensure that data pipelines are efficient, scalable, and reliable while maintaining high delivery standards, and meeting expected SLAs. You will also play a key role in modernizing our data warehouse operations, migrating data from on-prem, on-shore, and on-board systems to Cloud Data Warehouse, aligning with industry best practices and emerging technologies.

Essential Functions

• Develop ETL Architecture and methodologies from Source Acquisition and Source Validation to Data Publishing into a Data Lake or Data Warehouse.
• Convert SSIS Stored procedures to Matillion Mappings and develop Job schedules and Job Audits.
• Provide Best Practices that include Data Standardization, Reusability of code and approach as data moves from the Service Layer to the Infrastructure Layer to the Metadata Layer.
• Develop and maintain ETL processes and mappings to extract, transform, and load data from various sources into the data lake and eventually curate data for data consumption to support reporting and analytics.
• Develop Error Handling approach, full and incremental data loads via SCDs and CDCs to maintain history and real time / right time data streaming.
• Optimize and tune data pipelines for performance, scalability, and data quality, baselining current and improvised metrics.
• Develop and implement data quality initiatives to ensure data integrity and accuracy.
• Implement and enforce data governance practices to ensure compliance with regulatory requirements and internal policies.
• Modernize data warehouse operations by adopting industry best practices and emerging technologies.
• Develop ETL Reporting for Balance and Control, Job Statistics, Job Monitoring and Communication on continuous improvement.
• Stay abreast with the latest technologies and trends in data engineering, data warehousing, ETL & ELT, data quality, data governance, and modern data warehouse operations.
• Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
• Perform data analysis, required to troubleshoot and assist in resolving data issues.​

Desired Skills and Experience

• Bachelor’s degree in computer science, Engineering, or related field
• 12-15 years of experience as an ETL Architect, Data Warehouse Engineer, ETL Developer, or similar role
• Must have managed Off-Shore & Near-Shore Teams besides working closely with Vendor Teams
• Experience with cloud-based data technologies (e.g., AWS, GCP, Microsoft Azure)
• Experience with data warehousing solutions (e.g., Redshift, Azure, Data Bricks, Snowflake)
• Experience with ETL and Data Ingestion tools such as Matillion, SSIS, Informatica, AWS Glue, Azure Data Factory, STRiiM, Stream Sets, Oracle’s ODI, Coalesce, or Talend
• Experience in Data Modeling Principles – E/R and Dimensional Modeling and Tools such as E/R Studio or ERWIN
• Proficiency with standard database tools, Microsoft SSMS, Oracle Developer, etc.
• Experience in programming languages such as ANSI-SQL, Python, Scala, and/or Java
• Cruise Line Industry experience is preferred
• Strong analytical and problem-solving skills
• Excellent communication and collaboration skills
• Ability to work effectively in a fast-paced, dynamic environment

The Ritz-Carlton Yacht Collection is an Equal opportunity, inclusive employer and will consider all applicants for employment with the Company on the basis of merit, competence and qualifications without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, or any other category protected by federal, state, or local law.