Senior ETL Developer en The Ritz-Carlton Yacht Collection

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 Employee Promise At The Ritz-Carlton, our Ladies & Gentlemen are the most important resource in our service commitment to each other and our guests. By applying the principles of trust, honesty, respect, integrity, and commitment, we empower and nurture talent to the benefit of each individual and the company. The Ritz-Carlton fosters a culture where all are 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. Must speak and write English Must submit resume in English Job Summary: Senior ETL Developer with deep technical expertise in designing, developing, and optimizing enterprise-grade ETL solutions. This role requires strong proficiency in SQL Server, SSIS, Matillion, and Snowflake, with the ability to engineer scalable, high-performance data pipelines and ensure data integrity across cloud and on-premises environments. Essential Functions: Architect, build, and maintain ETL pipelines using SSIS and Matillion for ingestion, transformation, and loading into Snowflake. Develop complex SQL queries, stored procedures, CTEs, and window functions to support data transformations. Convert legacy SSIS workflows into Matillion jobs and optimize for cloud-native execution. Design and implement dimensional data models (Star/Snowflake schemas), data marts, and curated datasets. Support near real-time and batch data processing pipelines. Tune SQL queries and ETL processes for maximum throughput and cost efficiency in Snowflake. Implement error handling, auditing, logging, and monitoring frameworks for ETL jobs. Work closely with data architects, BI developers, and business analysts to translate requirements into technical ETL solutions. Integrate data from multiple sources, including APIs, flat files, and cloud data lakes. Implement data profiling, validation rules, and reconciliation checks. Enforce data governance, metadata management, and lineage best practices. Develop solutions leveraging Snowflake features (e.g., streams, tasks, time travel, clustering, micro-partitioning). Orchestrate ETL workflows with scheduling tools (e.g., Matillion Scheduler, Control-M, Airflow). Proactively monitor data quality across all ETL pipelines to ensure data accuracy, completeness, and timeliness. Troubleshoot production ETL and data pipeline issues, perform root cause analysis, and implement corrective measures. Investigate data anomalies and inconsistencies by tracing through source systems and target databases. Collaborate with source system owners to resolve upstream data quality issues, ensuring clean and reliable data ingestion. Drive issue resolution end-to-end, whether problems originate in source systems, integration layers, or the target Snowflake database. Implement continuous monitoring and alerting frameworks for early detection of failures or data discrepancies. Competency Education: Bachelor’s degree in computer science, Engineering, or related field. Skills & Experience: Must speak and write English 8–10+ years of hands-on ETL development with SSIS and Matillion (Informatica/Talend experience a plus). Advanced proficiency in SQL Server and Snowflake SQL, with deep knowledge of query tuning and execution plans. Strong experience with Snowflake, including performance tuning, optimization, and cost

Capacitate

Senior ETL Developer