Remote Data Engineer (dbt) — Build Scalable Data Transformations

BairesDev; Valle del Cauca; Remote; COP 291,300,000 - 404,583,000; Full time

Benefits offered by this job

100% remote work

Competitive USD or local currency pay

Hardware & software setup for WFH

Flexible hours

Parental leave and holidays

Mentorship and growth opportunities

Job summary

BairesDev is recruiting a Data Engineer (dbt) to design and maintain scalable data pipelines in the modern data stack. You will link raw data ingestion to actionable insights, ensuring precise, consistent, and high-performance datasets for analytics.

The role requires 4+ years in data or analytics engineering, dbt expertise, SQL mastery, and experience with Snowflake/BigQuery/Redshift. Remote, global teams, and competitive compensation offered.

Qualifications

• 4+ years of experience in Data Engineering or related field.
• Proven expertise in dbt (Core or Cloud).
• Advanced SQL for complex queries and performance tuning.
• Experience with Snowflake, BigQuery, or Redshift.
• Strong data modeling knowledge (star and snowflake).
• Advanced English proficiency.

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

English (advanced)

Tools

dbt

Snowflake

BigQuery

Redshift

Job description

BairesDev is recruiting a Data Engineer (dbt) to design and maintain scalable data pipelines in the modern data stack. You will link raw data ingestion to actionable insights, ensuring precise, consistent, and high-performance datasets for analytics.

The role requires 4+ years in data or analytics engineering, dbt expertise, SQL mastery, and experience with Snowflake/BigQuery/Redshift. Remote, global teams, and competitive compensation offered.