Offer summary

Qualifications:

Must be certified Snowflake Snowpro Core., 15+ years of experience in data management solutions., Expertise in Snowflake features like resource monitors, RBAC, and performance tuning., Experience with cloud technologies such as AWS, S3, Lambda, and Redshift..

Key responsibilities:

Design and implement Snowflake data solutions with security and access controls.

Develop and optimize data pipelines using Snowpipe, Python, and SnowSQL.

Lead end-to-end data integration projects involving structured and semi-structured data.

Collaborate on cloud-based enterprise data warehouse strategies and best practices.

Job description

Role: Snowflake Architect with SAP and AWS

Location : Remote

Build from Scratch

Certified Snowflake Snowpro Core (Must)

Certified Snowflake cloud data warehouse Architect (Desirable).

Required Knowledge and Level of Experience

· 15+ years of experience implementing data management solutions (Required).

· Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, zero copy clone, time travel and automating them.

· Experience in handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake.

· Experience in in re-clustering of the data in Snowflake with good understanding on Micro-Partitions.

· Experience in Migration processes to Snowflake from on-premises database environment.

· Experience in designing and building manual or auto ingestion data pipeline using Snowpipe.

· Experience in Cloud technologies such as AWS – S3, SQS, EC2, Lambda, Redshift, RDS

· Design and Develop automated monitoring processes on Snowflake using combination of Python, PySpark, Bash with SnowSQL.

· SnowSQL Experience in developing stored Procedures writing Queries to analyze and transform data.

Responsibilities

· Experience with data security and data access controls and design in Snowflake.

· Proficiency in complex SQL, Unix Shell/Python Scripting, performance tuning and database optimization techniques.

· Must have expertise in AWS Platform as a Service (PAAS) model and its integration with Snowflake to load/unload data.

· Implement cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake and NoSQL environment to build data movement strategy.

· Lead in Developing Project requirements for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.

· Make necessary on-going updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment.

· Act as Data domain expert for Snowflake in a collaborative environment to provide demonstrated understanding of data management best practices and patterns.

Required profile