Important Information
Experience: +7 years
Job Mode: Full-time
Work Mode: Remote
ID: 140948595
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.
Top Skills
What We Do
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
