SQL & Snowflake Engineer

Encora; United States; Remote; USD 32,000 - 53,000; Full time

Job summary

Coforge is hiring a SQL & Snowflake Engineer to design and optimize data solutions in a remote setup. You will work on complex SQL queries, dbt models and Snowflake infrastructure, including RBAC, warehouses, and cost controls. The role emphasizes performance tuning and data quality while aligning with Agile processes.

Ideal candidates bring deep Snowflake experience, dbt proficiency, and strong SQL skills, with cloud familiarity across AWS and IaC tooling.

Qualifications

• Solid experience with Snowflake architecture, RBAC, cost optimization and data sharing.
• Hands-on dbt for data modeling, lineage, testing and transformations.
• Strong Advanced SQL skills (CTEs, Window Functions, procedures).

Responsibilities

• Digest requirements from the team and specify complex SQL queries and dbt models.
• Build, test, and maintain scalable ELT pipelines using dbt.
• Manage Snowflake data infrastructure, warehouses, RBAC, cost controls and performance.
• Analyze and map Snowflake data schemas to support application logic.
• Optimize SQL performance and Snowflake costs for large data retrieval.
• Follow Agile processes and participate in data exploration.
• Participate in technical discussions, data quality reviews, and schema design.

Skills

Snowflake

SQL

Dbt

AWS

IaC

Python

Tools

Git

Liquibase

dbt

Job description

Job Title: SQL & Snowflake Engineer

Key Skills: Snowflake, SQL, Dbt, AWS, IaC, Python

Location: Brazil

Mode: Remote

We at Coforge are hiring SQL & Snowflake Engineer with the following skill set.

Key Responsibilities

• Digest requirements from the engineering team and specify the implementation of complex SQL queries and dbt models.
• Build, test, and maintain scalable ELT transformation pipelines using dbt.
• Manage and configure Snowflake data infrastructure (virtual warehouses, RBAC/access controls, resource monitors, and performance tuning).
• Analyze and map underlying data schemas within Snowflake to support application logic.
• Optimize SQL performance and Snowflake infrastructure costs for large-scale data retrieval and reporting.
• Follow Agile processes and participate actively in data exploration phases.
• Participate in technical discussions, data quality reviews, and schema design sessions.

Required Skills & Qualifications

• Solid experience with Snowflake architecture, infrastructure management (warehousing, RBAC, cost optimization), and data sharing.
• Hands-on experience with dbt (data modeling, lineage, testing, and transformations).
• Strong proficiency in Advanced SQL (CTEs, Window Functions, Stored Procedures).
• Familiarity with ELT processes and data ingestion tools.
• Solid experience with version control for database scripts and data pipelines (Git, Liquibase, or dbt).

Preferred Skills

• Cloud infrastructure knowledge (AWS/Azure/GCP) regarding data storage (S3/Blob) and IAM.
• Exposure to Infrastructure as Code (IaC) tools (e.g., Terraform) for provisioning cloud or Snowflake resources.
• Experience with Python or scripting for data manipulation and infrastructure automation.
• Familiarity with semi-structured data (JSON, Parquet) within Snowflake.

Posted On: 5-11-2026

At Coforge, we hire professionals based solely on their skills and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.