Snowflake Architect: WA

Role : Snowflake Architect

Location : WA (for now remote, later need to relocate)

Duration: Long-term

Client: Sonata/Symetra

Skills and Experience

• Must have total 14+ yrs. in IT and 3+ years' experience working as a snowflake Data Architect and 8+ years in Data warehouse, ETL, BI projects.

• 5+ years' experience working of Data Architecture supporting large enterprise initiatives.

• 5+ years of Data engineering experience in cloud computing. Hands-on experience in implementation and performance tuning databases (Snowflake, Redshift, EMR)

• Experience in AWS services AWS Glue, Athena, S3 data lakes, Dynamo DB, EMR and Redshift etc. is a plus.

• Prior experience in migrating data from traditional/cloud sources to Snowflake is required

• Must have experience at least two end to end implementation of Snowflake cloud data warehouse and 3 end to end data warehouse implementations on-premise preferably on SQL Server.

• Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts

• Exposer to Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel, private exchange, tag based masking policy and understand how to use these features

• Exposer in deploying Snowflake features such as data sharing, events and lake-house patterns

• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe

• Experience in Data Migration from 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 data security and data access controls and design

• Build processes supporting data transformation, data structures, metadata, dependency and workload management

• Proficiency in RDBMS, complex SQL, Unix Shell Scripting, performance tuning and troubleshoot

• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface

• Certified Snowflake cloud data warehouse Architect (Desirable).

• Should be able to troubleshoot problems across infrastructure, platform and application domains.

• Must have experience of Agile development methodologies

BDM