Principal Data Engineer: Data Pipelines & Snowflake Expert

Confiz; Región Centro; Presencial; MXN 900.000 - 1.500.000; Jornada completa

Descripción de la vacante

Confiz is seeking a Principal Data Engineer to drive the modern cloud data stack and deliver scalable data solutions. You will work in an agile environment, mentoring engineers and shaping technical standards in a fast-growing company.

The role centers on building pipelines with DBT, Databricks, Snowflake, and orchestrating workflows with Astronomer/Airflow, while applying Cosmos for DBT orchestration and delivering high-quality data products for a diverse customer base.

Formación

• Bachelor’s in Computer Science or a related discipline.
• Databricks & PySpark: Delta Lake, batch and streaming workloads, cluster and cost optimization.
• DBT (Core & Cloud): Advanced data modelling patterns, incremental strategies, custom tests, and CI/CD integration.
• Astronomer / Airflow: DAG authoring, Cosmos for DBT orchestration, and pipeline observability.
• Snowflake: Data modelling, query performance tuning, access control, and cost governance.
• Python and SQL: Strong programming skills with a focus on modular, maintainable, and testable code.
• Cloud platform: Hands-on experience with Azure or AWS.
• Agile & CI/CD: Comfortable working in agile teams with a CI/CD development mindset.

Responsabilidades

• Build and maintain scalable data pipelines using DBT and Astronomer/Airflow for batch and incremental data processing.
• Develop modular DBT transformation layers (staging → intermediate → mart) with robust testing, documentation, and incremental model strategies.
• Orchestrate end-to-end workflows on Astronomer / Airflow, using Cosmos to trigger and manage DBT models as native Airflow DAGs.
• Design and optimize Snowflake schemas, queries, and cost controls for analytical workloads.
• Enforce data quality standards through DBT tests and pipeline observability tooling.
• Write clean, well-tested Python and SQL code and actively participate in code reviews.
• Lead and mentor a team of data engineers; contribute to sprint planning, architectural decisions, and technical standards.

Conocimientos

Databricks

PySpark

DBT

Airflow

Astronomer

Snowflake

Python

SQL

Azure

AWS

Educación

Bachelors in CS

Herramientas

Databricks

Snowflake

Airflow

DBT

Cosmos

Python

SQL

Azure

AWS

Descripción del empleo

Confiz is seeking a Principal Data Engineer to drive the modern cloud data stack and deliver scalable data solutions. You will work in an agile environment, mentoring engineers and shaping technical standards in a fast-growing company.

The role centers on building pipelines with DBT, Databricks, Snowflake, and orchestrating workflows with Astronomer/Airflow, while applying Cosmos for DBT orchestration and delivering high-quality data products for a diverse customer base.