Encora · posted · checked
SQL & Snowflake Engineer
AWSdbtPythonSnowflakeSQLOn-site · Brazil
Who can apply
On-site · Brazil
Location: Brazil
Job Title: SQL & Snowflake Engineer
Key Skills: Snowflake, SQL, Dbt, AWS, IaC, Python
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.
Show the full posting
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.