Remote Data Engineer (Snowflake) - ELT and Data Modeling

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

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.