Sr. Consultant, Data Architect (Snowflake)

Project Limited; Toronto; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading company in Toronto is seeking a Data Architect with expertise in Snowflake. The role involves designing scalable data solutions, optimizing performance, and collaborating with analytics teams. Ideal candidates will have strong skills in SQL and Python, along with a passion for innovative data architecture.

Qualifications

• 5+ years in data architecture or engineering with hands-on Snowflake experience.
• Proven ability to troubleshoot performance issues in Snowflake.

Responsibilities

• Design and implement end-to-end data solutions from strategy to deployment.
• Lead data migration and integration projects using Snowpipe and Streams.

Skills

SQL

Python

Communication

Presentation

Stakeholder Management

Education

SnowPro certification

AWS certification

Azure certification

GCP certification

Tools

Snowflake

Microstrategy

Tableau

Power BI

AWS

Azure

GCP

Job description

About Project X

Project X Ltd. drives success by focusing on building teams of incredibly talented and client-focused people, who love to problem solve and work on tough data problems. We reward hard work and forward-thinking with recognition and a supportive culture that celebrates success and wants to see you grow.

Our team members are trusted advisors to our clients and offer innovative solutions that solve complex data problems. Collaboration, creativity, data knowledge and experience run deep in our veins. We are passionate about building long-term relationships with our clients and staying true to our values. When adding new members to our team, we also look for people that are aligned to our values.

We are also passionate about our people. Hiring and developing people that seek challenges, like to jump in and learn new things, and are happy to lend a helping hand to a peer is what makes us successful.

We understand that it’s our people that make us great.

Role Summary

As a Data Architect atProject X Ltd., 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.

In our commitment to promote fair and equitable treatment of all employees and applicants, Project X Ltd. provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status or any other ground as described in the Ontario Human Rights Code. In addition, accommodation will be provided during the hiring process.

Project Xis an equal opportunity employer and welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.