Data Engineer (Snowflake) - Remote Work

BairesDev; United States; Remote; MXN 1,676,000 - 2,421,000; Full time

Benefits offered by this job

Remote work

USD or local currency pay

Home office setup

Flexible hours

Parental leave

Mentorship & growth

Job summary

BairesDev is seeking 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 insights, ensuring transformed data is organized for high-performance analytics.

Responsibilities include building robust ELT workflows with Snowflake and dbt, developing modular data models, and orchestrating pipelines with Airflow to ensure data freshness. Strong SQL and English skills are required.

Qualifications

• 4+ years of experience in Data Engineering.
• Expertise building and optimizing ELT pipelines with Snowflake.
• Proficient with dbt for transformations and data modeling.
• Experience with Apache Airflow for orchestration.
• Strong SQL skills for complex data queries.
• Advanced English proficiency.

Responsibilities

• Design, implement, and optimize ELT workflows using Snowflake and dbt.
• Develop modular data models with modern software practices.
• Orchestrate complex data pipelines with Apache Airflow for reliability.
• Write and tune high-performance SQL queries for data extraction.
• Collaborate with stakeholders to define data requirements and schemas.
• Monitor pipelines and resolve bottlenecks to ensure data delivery.

Skills

English proficiency

Tools

Snowflake

dbt

Apache Airflow

SQL

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.