Remote Data Engineer (dbt) - Scale Data Pipelines

BairesDev; Atlántico; Remote; COP 323,656,000 - 485,484,000; Full time

Benefits offered by this job

100% remote work

Competitive compensation (USD or local

Hardware and software setup

Flexible hours

Paid parental leave & vacations

Mentorship and growth opportunities

Job summary

BairesDev is seeking an experienced Data Engineer (dbt) to design and build scalable transformation pipelines within the modern data stack. You will bridge raw data ingestion and BI, ensuring datasets are modeled with precision and high performance for downstream analytics.

Join a 100% remote team of top-tier technologists, collaborating with global stakeholders to define data quality and drive impactful analytics, while applying best practices in software engineering and documentation.

Qualifications

• 4+ years of experience 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.

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

Snowflake

BigQuery

Redshift

Data modeling

English

Job description

BairesDev is seeking an experienced Data Engineer (dbt) to design and build scalable transformation pipelines within the modern data stack. You will bridge raw data ingestion and BI, ensuring datasets are modeled with precision and high performance for downstream analytics.

Join a 100% remote team of top-tier technologists, collaborating with global stakeholders to define data quality and drive impactful analytics, while applying best practices in software engineering and documentation.