Snowflake Architect

 

Location: Chicago, IL

Contract

 

Mandatory Skills - 7 to 11 years of experience
Strong expertise in Snowflake Data Warehouse architecture and administration
Handson experience with Snowflake features such as Streams Tasks Snowpipe Dynamic Tables External Stages Cloning Time Travel and Multi- Cluster Warehouses
Strong SQL and Data Warehousing concepts
Data Modeling experience including Star Schema Snowflake Schema Facts Dimensions
Experience implementing SCD Type 1  Type 2 and surrogate key strategies
Handson experience with CDC ETLELT and largescale data migration projects
Experience with Snowflake performance tuning query optimization and cost optimization
Knowledge of semi structured data handling JSON XML VARIANT LATERAL FLATTEN
Experience integrating Snowflake with cloud platforms AWS Azure
Strong understanding of RBAC Data Governance Data Masking and Security best practices
Experience with Python and orchestration tools