Remote Data Engineer (dbt) — Build Scalable Data Pipelines

BairesDev; Antioquia; Remote; COP 194,194,000 - 291,290,000; Full time

Benefits offered by this job

100% remote

USD compensation

Hardware provided

Flexible hours

Paid parental leave

Mentorship

Global team

Job summary

BairesDev is hiring a Data Engineer (dbt) to design and build scalable transformation pipelines within the modern data stack. You will connect raw data ingestion to actionable business intelligence, ensuring precise, high-performance data models for downstream analytics.

Key duties include crafting dbt workflows, optimizing star/snowflake schemas, and tuning SQL for large-scale datasets while applying engineering best practices and collaborating with stakeholders to ensure data quality and

Qualifications

• 4+ years in Data/Analytics Engineering or related field.
• Proven expertise in building data transformations with dbt (Core or Cloud).
• Advanced SQL for complex queries and performance tuning.
• Experience with Snowflake, BigQuery, or Redshift.
• Strong understanding of star and snowflake schemas.

Responsibilities

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

Skills

dbt

SQL

Cloud data warehouse

Data modeling

English

Job description

BairesDev is hiring a Data Engineer (dbt) to design and build scalable transformation pipelines within the modern data stack. You will connect raw data ingestion to actionable business intelligence, ensuring precise, high-performance data models for downstream analytics.

Key duties include crafting dbt workflows, optimizing star/snowflake schemas, and tuning SQL for large-scale datasets while applying engineering best practices and collaborating with stakeholders to ensure data quality and