Seeking a skilled Snowflake Data Consultant to drive successful implementation, management, and optimization of data warehousing solutions. This role focuses on designing robust data architectures, streamlining data pipelines, and ensuring peak performance of Snowflake environments to meet diverse client needs.

Ideal candidates possess 3-5 years of hands-on experience with Snowflake cloud data warehousing, encompassing data modeling, pipeline development, and comprehensive environment management.

Key responsibilities include designing, deploying, and managing Snowflake resources like databases and warehouses. You will develop and optimize complex SQL queries, stored procedures, and Snowpark functions for superior performance. Configuring and maintaining data ingestion pipelines using ETL/ELT tools from various sources is crucial.

Further duties involve optimizing Snowflake performance through effective clustering and partitioning, and implementing robust data security measures including Role-Based Access Control. Leverage Snowflake's advanced features such as Time Travel and Zero-copy Cloning to enhance operational efficiency. You'll also support project delivery, oversee daily data operations, troubleshoot issues, and drive continuous improvements in data quality and architecture.

This position requires strong analytical, communication, and problem-solving skills, fostering collaborative work with data engineers, architects, and business analysts. Flexibility to meet critical project deadlines and provide support for production environments is essential.

Experience working within an ITIL or Agile framework is expected. A solid understanding of data modernization and migration principles is beneficial. You should possess the ability to effectively communicate technical status and data insights to both clients and internal stakeholders.