Domain Architect (Snowflake)

TechDigital Group; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a seasoned data architect with extensive experience in Snowflake. This role involves planning, designing, and developing data architectures for integration, warehousing, and sharing projects. You'll leverage your expertise in Snowpark API using Scala, Java, and Python to create innovative data engineering solutions. The ideal candidate will also have a strong grasp of Snowflake's advanced features and be comfortable engaging with clients to drive discussions and present offerings. Join a dynamic team where your contributions will significantly impact data-driven strategies and solutions.

Qualifications

• 9+ years of experience in data architecture and engineering solutions.
• Expertise in Snowflake, including advanced features and data modelling.

Responsibilities

• Design and maintain data architecture for various Snowflake projects.
• Drive customer discussions and present practice offerings.

Skills

Data Architecture

Snowflake SQL

Data Engineering

Scala

Java

Python

Data Science

Presales Support

Customer Discussions

Education

Snowflake Advanced Architecture Certification

Certification in cloud technology (AWS, Azure, GCP)

Tools

DBT

Fivetran

Airflow

Job description

Experience

> 9 years

Snowflake Technical Skills

• Expertise in planning, designing, developing and maintaining the data architecture for various Data Integration, Data Warehouse and Data Sharing projects in Snowflake.
• Good experience in migration of data solutions from On-premise and Big Data platforms to Snowflake.
• Design and develop Data Engineering solutions using Snowpark API with Scala, Java, Python.
• Knowledge of Snowflake Data Science features.
• In-depth understanding of Snowflake new features like Unistore, Data Lake, Iceberg tables, etc.
• 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 understanding how to use these features.
• Good to have - Data Science/AI Client implementation experience.

Other Skills

• Drive end-to-end discussions with customers.
• Drive and present practice offerings.
• Writing POV, White Papers.
• Presales support.

Snowflake Ecosystem

• Certification in any cloud technology: AWS, Azure, GCP.
• Experience in DBT, Fivetran, Airflow.

Certification

Snowflake Advanced Architecture Certification