Senior Snowflake Consultant

Overview

We are looking for an experienced data warehouse developer to design, build, and optimize data warehouse solutions. You will work closely with business and technical teams to deliver effective data solutions using Snowflake and other technologies. This role involves developing SQL queries, scripts, and tools to support data processing and ensure smooth project delivery.

Key Responsibilities

• Design and deliver end-to-end data warehouse solutions based on business requirements.
• Write SQL queries and stored procedures in Snowflake to meet functional needs.
• Optimize solution performance using innovative techniques.
• Develop low to medium complexity Unix shell scripts.
• Build minor applications or tools related to ETL processing as needed.
• Collaborate with Operations, Support, and Business teams to ensure smooth delivery.
• Share workload and adapt to working with other technologies when required.
• Follow established processes for project delivery and ongoing support.

Requirements

• 8+ years of data warehouse development experience with strong ANSI SQL skills.
• At least 2 years of hands-on experience with Snowflake, including writing procedures and SnowSQL scripts.
• Solid understanding of data warehouse concepts, data modeling, and design principles.
• Proficiency in Unix shell scripting and at least one programming language such as Python, Scala, or Java.
• Strong analytical skills to interpret and work with data.
• Experience with the full software development lifecycle (SDLC) for data warehouse projects.

Nice to Have

• Experience with CLIQ CDC processes and Kafka.