Snowflake Data Consultant
About The Position
Overall 7+ years of experience in Data Engineering, Big Data, Data Warehousing, and Cloud Data Platforms, with strong expertise in Snowflake (4+ years). Partner with Product Owners, business stakeholders, and domain experts to gather requirements and translate them into scalable, high-quality solution designs aligned with industry best practices and architectural standards. Collaborate with Application Architects and cross-functional technical teams throughout the development lifecycle and resolve issues identified during System Integration Testing (SIT) and User Acceptance Testing (UAT). Design, develop, and maintain resilient and scalable ELT data pipelines for data ingestion, transformation, and consumption using Snowflake, Python, Snowpark, and orchestration frameworks. Develop and optimize complex SQL solutions, stored procedures, UDFs, Snowflake Tasks, Streams, and Snowpipe-based ingestion frameworks. Design logical and physical data models, database objects, schemas, views, and security frameworks, with a strong understanding of dimensional modeling and Data Vault methodologies. Implement Change Data Capture (CDC) and incremental data processing solutions leveraging Snowflake Streams and Tasks. Optimize Snowflake workloads through effective warehouse sizing, clustering strategies, partitioning approaches, and query performance tuning. Demonstrate advanced proficiency in SQL development, performance optimization, and troubleshooting. Hands-on experience with Snowflake capabilities including SnowSQL, Snowpipe, Tasks, Streams, Time Travel, Data Sharing, Stored Procedures, Secure Views, and External Tables. Actively participate in Agile ceremonies, including sprint planning, backlog grooming, code reviews, daily standups, and retrospectives. Follow test-first and test-driven development practices, performing comprehensive unit testing and peer reviews to ensure high-quality, maintainable, and performant code. Collaborate effectively with distributed teams, developers, architects, and business stakeholders to deliver enterprise-scale data solutions. Possess strong analytical, problem-solving, communication, and stakeholder management skills.
Requirements
- Overall 7+ years of experience in Data Engineering, Big Data, Data Warehousing, and Cloud Data Platforms
- Strong expertise in Snowflake (4+ years)
- Advanced proficiency in SQL development, performance optimization, and troubleshooting
- Hands-on experience with Snowflake capabilities including SnowSQL, Snowpipe, Tasks, Streams, Time Travel, Data Sharing, Stored Procedures, Secure Views, and External Tables
- Strong understanding of dimensional modeling and Data Vault methodologies
- Strong analytical, problem-solving, communication, and stakeholder management skills
Nice To Haves
- Experience with Python
- Experience with Snowpark
- Experience with orchestration frameworks
Responsibilities
- Partner with Product Owners, business stakeholders, and domain experts to gather requirements and translate them into scalable, high-quality solution designs aligned with industry best practices and architectural standards.
- Collaborate with Application Architects and cross-functional technical teams throughout the development lifecycle and resolve issues identified during System Integration Testing (SIT) and User Acceptance Testing (UAT).
- Design, develop, and maintain resilient and scalable ELT data pipelines for data ingestion, transformation, and consumption using Snowflake, Python, Snowpark, and orchestration frameworks.
- Develop and optimize complex SQL solutions, stored procedures, UDFs, Snowflake Tasks, Streams, and Snowpipe-based ingestion frameworks.
- Design logical and physical data models, database objects, schemas, views, and security frameworks, with a strong understanding of dimensional modeling and Data Vault methodologies.
- Implement Change Data Capture (CDC) and incremental data processing solutions leveraging Snowflake Streams and Tasks.
- Optimize Snowflake workloads through effective warehouse sizing, clustering strategies, partitioning approaches, and query performance tuning.
- Actively participate in Agile ceremonies, including sprint planning, backlog grooming, code reviews, daily standups, and retrospectives.
- Follow test-first and test-driven development practices, performing comprehensive unit testing and peer reviews to ensure high-quality, maintainable, and performant code.
- Collaborate effectively with distributed teams, developers, architects, and business stakeholders to deliver enterprise-scale data solutions.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
