Key Facts

Remote From:

Brazil

Full time

English

Hard Skills

Other Skills

•
Discussion Facilitation
•
Communication
•
Collaboration

Roles & Responsibilities

Solid experience with Snowflake (architecture, warehousing, and data sharing)
Strong proficiency in Advanced SQL (CTEs, Window Functions, Stored Procedures)
Familiarity with ETL/ELT processes and data ingestion tools
Solid experience with version control for database scripts (Git, Liquibase, or dbt)

Requirements:

Digest requirements from the engineering team and specify the implementation of complex SQL queries
Analyze and map underlying data schemas within Snowflake to support application logic
Optimize SQL performance for large-scale data retrieval and reporting
Follow Agile processes and participate actively in data exploration phases

Encora Inc.

About Encora Inc.

Headquartered in Santa Clara, California, and backed by renowned private equity firms Advent International and Warburg Pincus, Encora is the preferred technology modernization and innovation partner to some of the world’s leading enterprise companies. It provides award-winning digital engineering services including Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering. Encora's deep cluster vertical capabilities extend across diverse industries, including HiTech, Healthcare & Life Sciences, Retail & CPG, Energy & Utilities, Banking Financial Services & Insurance, Travel, Hospitality & Logistics, Telecom & Media, Automotive, and other specialized industries. With over 9,000 associates in 47+ offices and delivery centers across the U.S., Canada, Latin America, Europe, India, and Southeast Asia, Encora delivers nearshore agility to clients anywhere in the world, coupled with expertise at scale in India. Encora’s Cloud-first, Data-first, AI-first approach enables clients to create differentiated enterprise value through technology.

Company type: XLarge

Founded: 2018

Company size: 5001 - 10000

Website LinkedIn See all jobs →

Job description

Important Information

Location: Brazil
Job Mode: Full-time
Work Mode: Work from home

Job Summary

As a SQL & Snowflake Engineer, you will play a key role in the full development lifecycle, translating complex data structures into actionable technical insights with a specific focus on Snowflake and SQL queries. You will be responsible for both querying and analyzing large datasets within the Data Lake to support feature development, ensuring seamless data availability from ingestion through to reporting within an Agile framework. Beyond technical execution, you will act as a key contributor in data modeling, actively participating in technical discussions to help the engineering team understand underlying data patterns and quality issues.

Responsibilities and Duties

Digest requirements from the engineering team and specify the implementation of complex SQL queries;
Analyze and map underlying data schemas within Snowflake to support application logic;
Optimize SQL performance 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.

Essential Skills

Solid Experience with Snowflake (architecture, warehousing, and data sharing);
Strong proficiency in Advanced SQL (CTEs, Window Functions, Stored Procedures);
Familiarity with ETL/ELT processes and data ingestion tools;
Solid experience with version control for database scripts (Git, Liquibase, or dbt).

Highly Desirable Skills

Cloud knowledge (AWS/Azure/GCP) regarding data storage (S3/Blob);
Experience with Python or scripting for data manipulation;
Familiarity with semi-structured data (JSON, Parquet) with Snowflake.

About Encora

Encora is the preferred digital engineering and modernization partner of some of the world’s leading enterprises and digital native companies. With over 9,000 experts in 47+ offices and innovation labs worldwide, Encora’s technology practices include Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering.

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