Senior Data Architect

HRB; Toronto; On-site; CAD 120,000 - 160,000; Full time

Job summary

HRB is seeking a Data Architect with Snowflake expertise to design and oversee end-to-end data solutions for clients in a cloud-first environment.

You will optimize performance and costs, lead migration and integration projects with Snowpipe, and collaborate with analytics teams on AI/ML workloads using Snowpark and Python.

This role requires shaping enterprise data strategy, governance frameworks, and presenting clear guidance to both technical and non-technical stakeholders.

Qualifications

• 5+ years in data architecture or engineering with hands-on Snowflake experience.
• Experience with schema design, performance tuning, and cost optimization.
• Knowledge of Snowflake Secure Data Sharing and end-to-end deployment.
• Deep knowledge of cloud environments (AWS, Azure, or GCP).
• Strong SQL and Python skills.
• Experience with data modeling, integration, and governance.
• Familiarity with BI tools like MicroStrategy, Tableau, or Power BI.
• Excellent communication and stakeholder management.

Responsibilities

• Design and implement end-to-end data solutions from strategy to deployment.
• Shape enterprise data strategy and governance for clients.
• Lead data migration and integration projects using Snowpipe, Streams, and Tasks.
• Collaborate with analytics teams to support AI/ML workloads with Snowpark and Python.
• Build and optimize cloud data platforms on AWS, Azure, or GCP.
• Advise clients through workshops and data-architecture best practices.
• Drive performance optimization and cost efficiency across deployments.

Skills

Snowflake

Data architecture

Cloud platforms

SQL

Python

Governance

Stakeholder management

Job description

Role Summary

As a Data Architect, you will be providing our clients with your knowledge and experience in making sense of messy, unstructured data. The Data Architect will be responsible for designing, implementing, and overseeing end-to-end solutions that address designing scalable and efficient data solutions, complex business challenges, and unlocking the value of data for our clients. This role will require demonstrated expertise in Snowflake to optimize data architecture, performance, and cost efficiency in a cloud-based environment.

What You’ll Do

As a Data Architect with Snowflake expertise, you’ll bring structure to chaos and vision to architecture.

• Design and implement end-to-end data solutions, from strategy to deployment.


• Shape enterprise data strategy, architecture, and governance frameworks for our clients.


• Lead data migration and integration projects, using tools like Snowpipe, Streams, and Tasks.


• Collaborate with analytics teams to support AI/ML and advanced analytics workloads using Snowpark and Python.


• Build and optimize cloud data platforms on AWS, Azure, or GCP.


• Act as a trusted advisor to clients, facilitating workshops and bringing thought leadership on modern data architecture best practices.


• Drive performance optimization and cost efficiency across deployments.

What You Bring

• 5+ years in data architecture or engineering, with hands-on Snowflake experience, including schema design, performance tuning, Snowflake Secure Data Sharing, cost optimization strategies, and end-to-end deployment.


• Proven ability to troubleshoot and resolve performance issues in Snowflake, manage virtual warehouses, implement clustering keys, and apply best practices for scaling and resource management.


• Deep knowledge of cloud environments (AWS, Azure, or GCP).


• Strong skills in SQL, Python.


• Experience with data modeling, integration, and governance frameworks.


• Familiarity with BI tools like Microstrategy, Tableau, or Power BI.


• Excellent communication, presentation, and stakeholder management skills, with the ability to effectively communicate technical concepts to non-technical audiences.

Nice to Have

• SnowPro certification or other Snowflake credentials.


• Certifications in AWS, Azure, or GCP architecture.


• Passion for mentoring and helping clients make smart, data-driven decisions.


• Knowledge of emerging trends and technologies in data architecture, such as data mesh, event-driven architectures, and streaming analytics.