Data Engineer (dbt) - Remote Work

BairesDev; Santander; Remote; COP 264,122,000 - 396,183,000; Full time

Benefits offered by this job

Remote work

USD payments

Home office setup

Flexible hours

Parental leave

Multicultural environment

Mentorship & growth

Job summary

BairesDev is seeking a Data Engineer (dbt) to design and optimize data transformation workflows in a 100% remote environment. You will build modular models using star and snowflake schemas and write high-performance SQL for cloud data warehouses.

You\'ll collaborate with global stakeholders, apply software engineering practices, and ensure data quality with automated tests, while enjoying flexible hours and international teamwork.

Qualifications

• 4+ years in Data/Analytics/Software Engineering
• Proven dbt (Core/Cloud) experience
• Advanced SQL for complex queries
• Experience with Snowflake, BigQuery or Redshift
• Data modeling using star/snowflake schemas
• Strong English communication

Responsibilities

• Design and maintain dbt data transformation workflows for large datasets
• Develop modular data models using star and snowflake schemas
• Write and tune advanced SQL queries for efficient processing
• Apply software engineering practices to analytics workflows with version control
• Collaborate with stakeholders to define data quality standards and tests
• Monitor pipeline performance for reliability and scalability

Skills

SQL

Data engineering

Cloud data warehouses

English

Tools

dbt (Core/Cloud)

Snowflake

BigQuery

Redshift

Job description

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.

Data Engineer (dbt) at BairesDev

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