Data Architect

Toronto, Ontario, Canada

Job Reference 1190773

Location Toronto, Ontario, Canada

Industry Other - IT

Function IT & Telecoms

Job Type Permanent

Date Added June 26, 2023

  • Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
  • Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
  • Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
  • Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
  • Should have good SQL scripting skills(TSQL or PLSQL).
  • 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
  • Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management
  • Proficiency in RDBMS, complex SQL, PL/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
  • Must have expertise in AWS or Azure Platform as a Service (PAAS).
  • 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
  • Strong written communication skills. Is effective and persuasive in both written and oral communication.
close

Don’t see a job for you? Register for our candidate portal

Sign in or register for Airswift Digital to stay updated with recommended jobs.

Visit our candidate portal