Remote Senior Data Warehouse Architect — Snowflake Expert

Confie; Tijuana; Presencial; MXN 900.000 - 1.300.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Private Health Insurance

Life Insurance

Saving Funds and Voluntary Savings

Descripción de la vacante

Confie is seeking a Senior Data Warehouse Architect to lead the design, development, and optimization of enterprise data warehouse solutions. The role requires deep expertise in cloud data platforms and scalable architectures for analytics across the organization.

The successful candidate will architect patterns, optimize ETL/ELT pipelines, and drive performance improvements while collaborating with Retail Operations and Supporting Operations teams to translate requirements into robust data

Formación

• 8+ years in data warehousing with at least 3 years in architectural roles.
• Experience with data migration and platform modernization initiatives.
• Familiarity with additional data integration tools and technologies.
• University or college education.
• Master's degree preferred.

Responsabilidades

• Lead data warehouse architecture including dimensional models and data vaults.
• Design and optimize ETL/ELT pipelines and transformations.
• Improve query performance and implement data clustering and tuning.
• Oversee data integration across source systems and platforms.
• Lead platform migrations and modernization initiatives.
• Provide technical leadership and mentorship to the BI&A team.

Conocimientos

Advanced SQL

Recursive CTEs

Window functions

Performance tuning

Data modeling

Data governance

Python

CI/CD for data pipelines

Cloud data platforms

Educación

Bachelor's degree

Master's degree

Herramientas

Snowflake

Redshift

BigQuery

Databricks

Tableau

Sigma

Power BI

Python

CI/CD tooling

Descripción del empleo

Confie is seeking a Senior Data Warehouse Architect to lead the design, development, and optimization of enterprise data warehouse solutions. The role requires deep expertise in cloud data platforms and scalable architectures for analytics across the organization.

The successful candidate will architect patterns, optimize ETL/ELT pipelines, and drive performance improvements while collaborating with Retail Operations and Supporting Operations teams to translate requirements into robust data