SQL & Snowflake Engineer

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

Role overview

Develop and maintain data transformations and Snowflake infrastructure that support engineering and reporting needs. The work combines advanced SQL, dbt modeling, platform configuration, and collaboration on data exploration and design.

Responsibilities

• Translate engineering requirements into complex SQL queries and dbt models.
• Build, test, and maintain scalable ELT pipelines, including model lineage and data quality checks.
• Configure Snowflake warehouses, access controls, resource monitors, and performance settings.
• Examine and 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.

Requirements

• Experience with Snowflake architecture, warehouse administration, role-based access, cost management, and data sharing.
• Hands-on dbt experience across data modeling, transformations, testing, and lineage.
• Advanced SQL skills, including common table expressions, window functions, and stored procedures.
• Familiarity with ELT processes and data ingestion tools.
• Experience versioning database scripts and pipeline changes with Git, Liquibase, dbt, or similar tools.

Nice to have

• Cloud data storage and identity/access knowledge in AWS, Azure, or Google Cloud.
• Infrastructure as Code experience, such as Terraform, and Python or scripting for automation.
• Familiarity with semi-structured formats such as JSON and Parquet.

Benefits and work setup

The position is listed as remote and based in Brazil.