Senior ETL Developer

Description

Summary: This role is for a Senior ETL Developer with deep technical expertise in designing, developing, and optimizing enterprise-grade ETL solutions, ensuring data integrity across cloud and on-premises environments. Highlights: 1. Redefine ultra-luxury hospitality at sea with The Ritz-Carlton Yacht Collection 2. Architect, build, and maintain ETL pipelines using SSIS and Matillion 3. Empower and nurture talent with trust, honesty, respect, and integrity ***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*** **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 governance. * Experience with Python, Bash, or PowerShell for workflow automation. * In\-depth knowledge of dimensional modeling, SCD handling (Type 1/2\), CDC, and data vault concepts. * Experience with GitHub, Bitbucket, or Azure DevOps pipelines for ETL deployments, Python. * Experience with job orchestration tools such as Matillion Scheduler, SQL Agent, Airflow, or Control\-M. * Familiarity with BI tools such as Sigma, Tableau, Power BI, or Cognos. * Snowflake or Matillion certification. * Experience with cloud ETL frameworks (AWS Glue, Azure Data Factory). * Familiarity with data governance tools (Collibra, Microsoft Purview, Alation). * Prior experience in Travel, Cruise Line, or Hospitality industry. * Strong problem\-solving and analytical abilities. * Clear communication with both technical and non\-technical stakeholders. * Ability to manage multiple priorities in a fast\-paced environment. * Ownership mindset with attention to quality, performance, and scalability. * Ability to manage multiple priorities in a fast\-paced environment. * Implement continuous monitoring and alerting frameworks for early detection of failures or data discrepancies. *Join us in shaping unforgettable journeys for our guests where the world’s most luxurious yachts meet the legendary service of The Ritz\-Carlton Yacht Collection.* *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.* Job Types: Full\-time, Contract Language: * English (Required) Location: * Buenos Aires, Buenos Aires (Required) Work Location: Hybrid remote in Buenos Aires, Buenos Aires