Data Engineer (Snowflake) - Remote Work

BairesDev; Colombia; Remote; COP 282,912,000 - 408,651,000; Full time

Benefits offered by this job

Remote work

Competitive USD pay

Home office setup

Flexible hours

Parental leave

Mentorship & growth

Diverse environment

Job summary

BairesDev is hiring a Data Engineer (Snowflake) to design and build scalable ELT pipelines and data models within the Snowflake Data Cloud. You will bridge raw data sources and actionable insights, ensuring transformed data is organized for high-performance analytics.

You will design, implement, and optimize ELT workflows with Snowflake and dbt, develop robust data models, and orchestrate pipelines with Airflow to ensure data freshness and reliability.

Qualifications

• 4+ years of Data Engineering experience with modern data stack.
• Proven expertise building and optimizing ELT pipelines and data models using Snowflake.
• Proficiency in dbt for data transformation and managing complex data models.
• Hands-on experience with Apache Airflow for workflow orchestration.
• Advanced SQL for data extraction and performance tuning.
• Advanced English proficiency.

Responsibilities

• Design, implement, and optimize ELT workflows using Snowflake and dbt.
• Develop and maintain modular data models with version control and tests.
• Orchestrate complex data pipelines with Apache Airflow for data freshness.
• Write high-performance SQL queries and transformations for Snowflake.
• Collaborate with stakeholders on data requirements and schemas.
• Monitor pipeline health and resolve bottlenecks to ensure reliability.

Skills

Data engineering

ELT pipelines

SQL queries

English proficiency

Tools

Snowflake

dbt

Apache Airflow

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 (Snowflake) at BairesDev

As a Data Engineer (Snowflake), you will design and build scalable ELT pipelines and data models within the Snowflake Data Cloud. You will act as a link between raw data sources and actionable business insights, ensuring that data is transformed and organized efficiently for high-performance analytics.

What You'll Do:

• Design, implement, and optimize robust ELT workflows using Snowflake and dbt to process large-scale datasets.
• Develop and maintain modular data models, applying software engineering best practices such as version control and automated testing.
• Orchestrate complex data pipeline dependencies and schedules using Apache Airflow to ensure data freshness and reliability.
• Write and tune high-performance SQL queries and transformations to leverage Snowflake's unique architectural capabilities.
• Collaborate with stakeholders to define data requirements, schema designs, and quality standards for the modern data stack.
• Monitor pipeline health and performance, identifying and resolving bottlenecks to ensure continuous data delivery.

What we are looking for:

• 4+ years of experience in Data Engineering with a focus on the modern data stack.
• Proven expertise in building and optimizing ELT pipelines and data models using Snowflake.
• Proficiency in using dbt for data transformation and managing complex data models.
• Hands-on experience with Apache Airflow for workflow orchestration and pipeline management.
• Advanced proficiency in writing and optimizing complex SQL queries for data extraction.
• 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.