Snowflake Architect/Administrator
Hire IT People
Charlotte, United States of America
1 month ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Charlotte, United States of America
Tech stack
Agile Methodologies
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Continuous Integration
Data Governance
Data Migration
Data Stores
Data Warehousing
Relational Databases
Github
JSON
NoSQL
XML
Parquet
Data Storage Technologies
Snowflake
Amazon Web Services (AWS)
Semi-structured Data
Functional Programming
Redshift
Requirements
- Must have at least 5+ years of experience working as a Snowflake Data Architect and 10+ years of experience in Data Warehouse, ETL, and BI projects area.
- Must have prior experience in end-to-end implementation of multi account Snowflake architecture, including deployment model.
- Data governance expertise in snowflake, including column-level data security, and dynamic data masking features.
- Expertise in design and development of secure access to objects in Snowflake with Role-Based Access Control (RBAC), including data access and functional roles.
- Expertise in deploying Snowflake features such as data sharing, zero copy cloning, streamlit, Snowpark, Stored procedures, materialized views etc.
- Expertise in recovery methods and agile development with Time Travel & Cloning.
- Experience in establishing CICD pipeline automation to deploy and manage snowflake code/objects using GitHub, Schema Change etc.
- Experience is setting up monitoring of snowflake accounts, including user activities, credits consumption, warehouses utilization, workloads etc.
- Experience in handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake.
- Experience in re-clustering of the data in Snowflake with good understanding of micro-Partitions.
- Experience in Data Migration from on premise RDBMS to Snowflake cloud data warehouse.
- Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling).
- Experience with AWS data storage and management technologies such as S3, EC2, Lambda, Redshift, RDS.
- Certified Snowflake Architect (Desirable).
- Should be able to troubleshoot problems across infrastructure, platform, and applications.
- Must have experience of Agile development methodologies.
- Strong verbal and written communication skills.
