Remote SQL & Snowflake Engineer (dbt, ELT, Data Quality)

encora10; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

encora10 is seeking a Data Engineer to develop and maintain data transformations and Snowflake infrastructure that support engineering and reporting needs. This role combines advanced SQL, dbt modeling, platform configuration, and collaboration on data exploration and design.

You will build scalable ELT pipelines, map data schemas for downstream use, optimize queries, and manage Snowflake costs within an Agile team. Remote work with a Brazil base is offered.

Qualifications

• Experience with Snowflake architecture and cost management.
• Hands-on dbt across data modeling, transformations, testing, and lineage.
• Advanced SQL skills including CTEs, window functions, and stored procedures.
• Familiarity with ELT processes and data ingestion tools.
• Versioning database scripts with Git, Liquibase, dbt, or similar tools.
• Nice to have cloud experience (AWS/Azure/GCP), Terraform, Python, or scripting.
• Familiarity with JSON and Parquet formats.

Responsibilities

• Translate engineering requirements into complex SQL queries and dbt models.
• Build, test, and maintain scalable ELT pipelines with data quality checks.
• Configure Snowflake warehouses, access controls, resource monitors, and performance settings.
• Map data schemas to support application logic and downstream use.
• Improve query performance and manage Snowflake costs for large data workloads.
• Contribute to Agile planning, technical discussions, data exploration, and schema reviews.

Skills

Advanced SQL

dbt modeling

Agile collaboration

Data exploration

Tools

Snowflake

Git/Liquibase/dbt

Terraform

Python scripting

Job description

encora10 is seeking a Data Engineer to develop and maintain data transformations and Snowflake infrastructure that support engineering and reporting needs. This role combines advanced SQL, dbt modeling, platform configuration, and collaboration on data exploration and design.

You will build scalable ELT pipelines, map data schemas for downstream use, optimize queries, and manage Snowflake costs within an Agile team. Remote work with a Brazil base is offered.