Snowflake Data Engineer | dbt & Fivetran

Location: Remote

Salary: $80,000 MXN gross per month

We are looking for a Snowflake Data Engineer to design, develop, and optimize cloud data solutions. You will build ELT pipelines, develop data models, and support reliable analytics using Snowflake, dbt, and Fivetran.

Key Responsibilities

- Design and maintain scalable data models and ELT processes in Snowflake.
- Build end-to-end ingestion pipelines using Fivetran to load data from multiple sources, including external APIs.
- Develop and test data transformations using SQL and dbt, ensuring data accuracy and consistency.
- Optimize queries, data loads, and transformations using Snowflake micro-partitioning and clustering features.
- Create Streamlit applications to support business users and maintenance tasks.
- Implement data quality, governance, and security practices.
- Troubleshoot data warehouse and pipeline issues.
- Use GitHub for version control and automated deployment of Snowflake scripts, dbt models, and ELT pipelines across environments.
- Collaborate with data architects and business stakeholders to translate requirements into technical solutions.
- Maintain documentation for data models, pipelines, and operational processes.

Required Qualifications





- Proven hands-on experience developing Snowflake data warehousing solutions.
- Strong SQL skills, including complex queries, CTEs, query optimization, and JavaScript stored procedures in Snowflake.
- Solid experience with dbt for data modeling and transformations.
- Hands-on experience with Fivetran for data ingestion and pipeline development.
- Understanding of Snowflake architecture, micro-partitioning, clustering, and loading files from AWS S3.
- Knowledge of Python for data engineering and automation.
- Experience designing and maintaining ELT pipelines.
- Proficiency with GitHub for source control and deployment workflows.
- Excellent communication, collaboration, and problem-solving skills.

Preferred Qualifications

- Experience building Streamlit applications.
- Familiarity with SnapLogic.
- Experience with AWS services such as Lambda, SQS, and SNS.
- Knowledge of Terraform or AWS CloudFormation.
- Experience integrating legacy Microsoft SQL platforms with cloud data solutions.

Apply with your updated resume highlighting your experience with Snowflake, dbt, and Fivetran. Job Type: Full-time

Pay: $78,000.00 - $80,000.00 per month

Language

- English (Required)

Work Location: Remote

📌 Snowflake Data Engineer - REMOTE (México)
🏢 U-Hi
📍 México