Job Description

Snowflake DBT Lead

Location: Markham, ON, Onsite

Term: Long Term Contract

Working model Hybrid 3 days' Work from Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu Fri

Primary Skills

Extensive Experience 15 years of professional experience delivering over 10 high impact data projects from inception through warranty

5 years of Snowflake dbt CoreCloud and AWS Cloud Technologies

Handson experience with orchestration tools like Zena and AWS Managed Airflow

7 years of experience with coding in languages such as Python or Java etc

Skilled in tools such as Snowsight Streamlit

Deep expertise in relational databases SnowflakePostgreSQLAmazon Aurora

Experience in SQL with a strong focus on performance reusability and maintainability

Good to have experince in migration projects from Cloudera to Snowflake

Strong technical and business presentation skills able to identify and address gaps in data designs and processes with both internal and external stakeholders

Proven ability to thrive in fastpaced ambiguous and highpressure environments

A track record of mentoring Data Engineers at all levels fostering a culture of engineering excellence and continuous improvement

CustomerCentric Mindset Passion for solving realworld problems using datadriven insights to deliver impactful business outcomes

Collaborative Approach Strong interpersonal and communication skills with the ability to lead teams and influence crossfunctional stakeholders

Secondary Skills

SnowPRO Core

SnowPRO Advanced Data Engineer DEAC01 DEAC02

SnowPro Advanced Architect ARAC01

dbt Developer

AWS Cloud Practitioner

Domain Knowledge Familiarity with insurance industry processes and systems is a strong asset

AIML GenAI Exposure Experience in operationalizing AIML GenAI models is a plus

Qlik and SAP BusinessObjects

Shell and Terraform

Job Type: Seasonal
Contract length: 12 months