Overview
Remote
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
Snowflake Architect
Job Details
Required Knowledge and Level of Experience
- 15+ years of experience implementing data management solutions (Required).
- Management consulting experience (Highly Desired).
- 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.
- Certified Snowflake cloud data warehouse Architect (Desirable).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.