Feeny
Encora

SQL & Snowflake Engineer at Encora (Brazil)

Encora· Brazil·

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.

Why work at Encora

  • Culture & Recognition: Certified “Great Place to Work” in multiple regions; recognized by Comparably for Career Growth, Best Engineering Team, Best Company for Diversity, and Company Happiness.
  • Remote/Hybrid Policy: Flexible work-from-home scheme; remote workers in Mexico receive a monthly allowance of MXN 700 for internet/electricity, plus desk and chair after 3 months. No dress code, pet-friendly environment.
  • Perks & Benefits (varies by location):
    • Top-of-the-line MacBook Pro
    • Unlimited book budget and training/certification support
    • Private health insurance (including family) with dental and life insurance
    • 12 days paid vacation from day one (Mexico), 5 days PTO, 30 days aguinaldo (mandatory annual bonus)
    • Psychotherapy support (12 sessions covered fully)
    • Savings fund, grocery vouchers, and snack stations in select offices
  • Considerations: Compensation inconsistency across geographies and accounts; project-dependent stability; change fatigue from post-acquisition integration. Candidates should confirm review cycles, salary bands, and account assignment during interviews.

Application questions