Senior ETL Architect - Snowflake, Matillion & SSIS

The Ritz-Carlton Yacht Collection; Argentina; Presencial; ARS 134.860.000 - 194.797.000; Jornada completa

Descripción de la vacante

The Ritz-Carlton Yacht Collection is seeking a Senior ETL Developer to design, develop, and optimize enterprise-grade ETL solutions. You will architect pipelines using SSIS and Matillion for Snowflake, build complex SQL, and ensure data integrity across cloud and on-premises environments.

Lead data modeling, orchestration, and governance while collaborating with data architects, BI teams, and analysts to translate requirements into scalable ETL solutions.

Responsabilidades

• 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.

Descripción del empleo

The Ritz-Carlton Yacht Collection is seeking a Senior ETL Developer to design, develop, and optimize enterprise-grade ETL solutions. You will architect pipelines using SSIS and Matillion for Snowflake, build complex SQL, and ensure data integrity across cloud and on-premises environments.

Lead data modeling, orchestration, and governance while collaborating with data architects, BI teams, and analysts to translate requirements into scalable ETL solutions.