AWS Snowflake Architect (Hybrid, Markham, Ontario)

hr-pod-hiring-talent-globally; Markham; On-site; CAD 110,000 - 190,000; Full time

Job summary

hr-pod-hiring-talent-globally is seeking a senior Data Architect to design and implement scalable data architectures using Snowflake and AWS.

You will develop data ingestion, transformation, and consumption pipelines across enterprise systems, define data models and integration patterns, and optimize Snowflake environments for performance, security, and cost efficiency. Collaboration with engineering, analytics, and business teams is essential.

Qualifications

• 8+ years in data architecture, data engineering, or enterprise data platforms.
• Deep Snowflake architecture and data warehousing expertise.
• Hands-on AWS cloud solution design for scalable data platforms.
• Experience with AWS Glue, Apache Airflow, and dbt for integration.
• Strong data modeling and ETL/ELT architecture skills.
• Proficiency in SQL and Python for data processing and automation.
• Secure, scalable, high-performance data architectures.
• Insurance domain experience is preferred.

Responsibilities

• Design scalable enterprise data architectures using Snowflake and AWS.
• Develop ingestion, transformation, and consumption pipelines across systems.
• Build ETL/ELT pipelines with AWS Glue, Airflow, and dbt.
• Define data models, standards, and integration patterns.
• Optimize Snowflake for performance, security, and cost.
• Collaborate with engineering, analytics, and business teams.
• Provide technical leadership to data engineering teams.

Skills

Data architecture

Snowflake

AWS cloud

Airflow/dbt

ETL/ELT

SQL

Python

Security & governance

Tools

AWS Glue

Apache Airflow

dbt

Job description

Requirements:

• 8+ years of experience in Data Architecture, Data Engineering, or enterprise data platform development.
• Strong expertise in Snowflake architecture, data warehousing, and enterprise-scale data platforms.
• Hands-on experience with AWS cloud services and designing scalable, cloud-based data solutions.
• Strong experience with AWS Glue, Apache Airflow, and dbt for data integration and transformation.
• Expertise in data modeling, ETL/ELT architecture, data pipelines, and data integration patterns.
• Strong proficiency in SQL and Python for data processing and automation.
• Experience designing secure, scalable, and high-performance data architectures.
• Experience within the insurance domain is preferred.

Responsibilities:

• Design and implement scalable enterprise data architectures using Snowflake and AWS.
• Develop architectures for data ingestion, transformation, integration, and consumption across enterprise systems.
• Design and optimize ETL/ELT pipelines using AWS Glue, Apache Airflow, dbt, and related technologies.
• Define data models, architecture standards, integration patterns, and technical best practices.
• Optimize Snowflake environments for performance, scalability, security, and cost efficiency.
• Collaborate with engineering, analytics, and business teams to translate data requirements into effective technical solutions.
• Provide technical leadership and guidance to data engineering teams throughout the implementation process.
• Ensure data solutions meet enterprise standards for security, governance, reliability, and performance.