Senior ETL Architect | Snowflake & Matillion

The Ritz-Carlton Yacht Collection; Buenos Aires; Presencial; ARS 179.641.000 - 269.461.000; Jornada completa

Descripción de la vacante

The Ritz-Carlton Yacht Collection is seeking a Senior ETL Developer to design and optimize enterprise-grade ETL solutions. You will work with SQL Server, SSIS, Matillion, and Snowflake to engineer scalable data pipelines across cloud and on-prem environments.

Ideal candidates will have deep experience in dimensional modeling, data governance, and orchestration tools, delivering high-quality data with reliability and performance at scale.

Formación

• 8-10+ years of hands-on ETL development with SSIS and Matillion.
• Advanced proficiency in SQL Server and Snowflake SQL, with strong query tuning.
• Experience with Python, Bash, or PowerShell for workflow automation.
• Familiarity with dimensional modeling, SCD handling, CDC, and data vault concepts.

Responsabilidades

• Architect, build, and maintain ETL pipelines using SSIS and Matillion for ingestion, transformation, and loading into Snowflake.
• Develop complex SQL queries, stored procedures, and data transformations.
• Convert legacy SSIS workflows into Matillion jobs and optimize for cloud-native execution.
• Collaborate with data architects and BI developers to translate requirements into ETL solutions.

Conocimientos

SSIS

Matillion

Snowflake SQL

Python

SQL Server

GitHub

Airflow

Dimensional modeling

Data governance concepts

Educación

Bachelor's degree in Computer Science or related

Herramientas

Matillion Scheduler

SQL Agent

Airflow

Control-M

Descripción del empleo

The Ritz-Carlton Yacht Collection is seeking a Senior ETL Developer to design and optimize enterprise-grade ETL solutions. You will work with SQL Server, SSIS, Matillion, and Snowflake to engineer scalable data pipelines across cloud and on-prem environments.

Ideal candidates will have deep experience in dimensional modeling, data governance, and orchestration tools, delivering high-quality data with reliability and performance at scale.