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 ResponsibilitiesSnowflake 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
- 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)
- 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
- 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
- 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
Accommodations are available upon request throughout the recruitment process.
Top Skills
What We Do
Inspiring Possibility
Appnovation is a full service digital consultancy with experience and capacity to meet the needs of even the largest most complex of organizations in the world. Our services portfolio enables us to offer clients the best of experiences when working with our teams so as to make sure we keep the focus on their needs, customers and delivering tangible value to the business. End to end services; endless ideas.
