page_title

tags.new

About us

Appnovation is a global, full-service digital partner that combines Strategy, Experience & Design, Engineering and Managed Services. We build digital solutions that deliver real impact today and serve as foundations for future growth. Bold ambition. Practical action. Endless possibilities.

About the Role

As a Sr. Associate Snowflake Developer, you will be responsible for designing, building, and optimizing scalable data solutions on the Snowflake Data Cloud. You will play a key role across data development, performance optimization, and pipeline integration, working closely with Data Engineers, Analysts, and Architects to deliver high-quality, secure, and efficient data platforms.

On a day-to-day basis, you will contribute to the full data lifecycle — from ingestion and modeling to optimization and operational excellence — ensuring data solutions meet business, performance, and governance standards.

Key Responsibilities

Snowflake Development

Design, develop, and maintain Snowflake objects including warehouses, databases, schemas, tables, views, stages, file formats, tasks, and streams
Build and manage Snowflake pipelines, including Snowpipe, ingestion processes, and continuous data flows
Implement role-based access control (RBAC) and follow data security best practices

SQL Development & Performance Optimization

Write, optimize, and troubleshoot complex SQL queries
Improve query performance through clustering, caching, pruning, and warehouse optimization strategies
Tune ETL/ELT workloads and Snowflake compute resources for efficiency and scalability

Data Modeling & Validation

Design scalable conceptual, logical, and physical data models
Apply dimensional modeling techniques (Star and Snowflake schemas)
Ensure data quality through validation, profiling, reconciliation, and monitoring

Cloud ETL / ELT Integration

Use at least one cloud ETL/ELT platform (e.g., Informatica Cloud, Matillion, ADF, Talend, DBT, AWS Glue) to ingest and transform data from multiple sources
Manage automated workflows, pipelines, and scheduling processes

Architecture & Collaboration

Apply data architecture principles across data lakes, warehouses, ingestion patterns, and transformation frameworks
Contribute to architectural discussions and recommend Snowflake best practices and improvements
Collaborate closely with Data Engineers, Analysts, and Architects to deliver end-to-end data solutions

What We’re Looking For

Must-Have

Strong hands-on experience developing on Snowflake Data Cloud
Advanced SQL development and optimization skills
Proven experience with performance tuning and cost optimization
Solid background in data modeling and data validation
Experience working with one or more cloud ETL/ELT tools
Familiarity with Snowflake features such as Time Travel, Cloning, Streams, Tasks, Snowpipe, and Resource Monitors
Experience working in cloud environments (AWS, Azure, or GCP)

Nice-to-Have

Exposure to data architecture and design principles
Experience with DBT or similar transformation frameworks
Familiarity with DevOps practices (CI/CD pipelines, Git)
Experience with orchestration tools such as Airflow or ADF pipelines

What Appnovation Offers

Challenging and rewarding work with real impact
Direct access to cutting-edge AI and data platforms
A diverse, inclusive, and collaborative culture
Opportunities for continuous personal and professional growth
Exposure to exciting projects and high-profile clients
Supportive environment with access to company leaders
Flexible and remote-friendly work model

Benefits (Brazil – CLT)

Medical Plan (SulAmérica or Unimed)
Dental Plan (SulAmérica)
Meal Voucher (Flash)
Individual English Classes
SESC Credential
Life Insurance (MetLife)
Wellness Allowance
ME Days
Employee Assistance Program
Fertility and Menopause Leave

Thank you for your interest in a career with Appnovation Technologies! Please note that only those selected for an interview will be contacted.

At Appnovation, we recognize that diverse teams are the strongest teams. Diversity, Equity & Inclusion is not only something that we embrace - we celebrate it! We are proud to be an Equal Opportunity Employer and we encourage applicants from all backgrounds, lived experiences and industries to apply. Come join us at Appnovation, and learn more about how we stay true to our company values as we build better lives through better digital.

Accommodations are available upon request throughout the recruitment process.

Create a Job Alert

Interested in building your career at Appnovation Technologies? Get future opportunities sent straight to your email.