Remote dbt Data Engineer — Scalable Pipelines

BairesDev; México; A distancia; MXN 1.525.000 - 2.542.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

100% remote work

USD or local currency compensation

Hardware provided

Flexible hours

Parental leave

Growth opportunities

Descripción de la vacante

BairesDev is seeking a Data Engineer specializing in dbt to design and build scalable transformation pipelines in the modern data stack. You will join a global, 100% remote team delivering high-performance datasets for analytics and BI.

The role emphasizes data modeling, SQL optimization, and collaboration with stakeholders to ensure data quality and reliability across cloud warehouses. English proficiency is required.

Formación

• 4+ years in Data Engineering, Analytics Engineering, or Software Engineering.
• Proven expertise in building and optimizing data transformations using dbt (Core or Cloud).
• Advanced proficiency in SQL for complex query development and performance tuning.
• Strong experience with cloud data warehouses such as Snowflake, BigQuery, or Redshift.
• Solid understanding of data modeling principles, including star and snowflake schemas.
• Advanced proficiency in English.

Responsabilidades

• Design, implement, and maintain robust data transformation workflows using dbt to process large-scale datasets.
• Develop and optimize modular data models using star and snowflake schemas to support complex analytical requirements.
• Write and tune advanced SQL queries to ensure efficient data processing and leverage cloud data warehouse capabilities.
• Apply software engineering best practices to the analytics workflow, including version control and documentation.
• Collaborate with stakeholders to define data quality standards and implement automated tests within the transformation layer.
• Monitor and optimize pipeline performance to ensure data reliability, freshness, and scalability across the organization.

Conocimientos

dbt

SQL

Data modeling

English (Advanced)

Herramientas

Snowflake

BigQuery

Redshift

Descripción del empleo

BairesDev is seeking a Data Engineer specializing in dbt to design and build scalable transformation pipelines in the modern data stack. You will join a global, 100% remote team delivering high-performance datasets for analytics and BI.

The role emphasizes data modeling, SQL optimization, and collaboration with stakeholders to ensure data quality and reliability across cloud warehouses. English proficiency is required.