Data Engineer (dbt) - Remote Work | REF#308602

BairesDev; Sucre; Remoto; COP 292.047.000 - 454.295.000; Tempo pieno

Vantaggi offerti da questo lavoro

100% remote

USD or local currency pay

Hardware provided

Flexible hours

Paid parental leave

Global team environment

Descrizione del lavoro

BairesDev is seeking a Data Engineer specializing in dbt to design and maintain scalable transformation pipelines within the modern data stack. You will bridge raw data ingestion with business analytics, ensuring precise, high-performance datasets for downstream analytics.

Join a 100% remote, global team. You’ll implement dbt models, optimize SQL, collaborate with stakeholders, and uphold data quality with automated tests, while benefiting from flexible hours, mentorship, and competitive USD

Competenze

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

Mansioni

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

Conoscenze

Strong SQL skills

Analytical mindset

English proficiency

Strumenti

dbt

Snowflake

BigQuery

Redshift

Python

Descrizione del lavoro

At BairesDev®, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innovative startups in Silicon Valley.

Our diverse 4,000+ team, composed of the world's Top 1% of tech talent, works remotely on roles that drive significant impact worldwide.

When you apply for this position, you're taking the first step in a process that goes beyond the ordinary. We aim to align your passions and skills with our vacancies, setting you on a path to exceptional career development and success.

As a Data Engineer specializing in dbt, you will design and build scalable transformation pipelines within the modern data stack. You will serve as the connection between raw data ingestion and actionable business intelligence, ensuring that datasets are modeled with precision, consistency, and high performance for downstream analytics.

What You'll Do

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

What We Are Looking For

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

How we do make your work (and your life) easier:

• 100% remote work (from anywhere).
• Excellent compensation in USD or your local currency if preferred
• Hardware and software setup for you to work from home.
• Flexible hours: create your own schedule.
• Paid parental leaves, vacations, and national holidays.
• Innovative and multicultural work environment: collaborate and learn from the global Top 1% of talent.
• Supportive environment with mentorship, promotions, skill development, and diverse growth opportunities.

Join a global team where your unique talents can truly thrive and make a significant impact!

#BD-PRIO-2026