Data Architect, Snowflake – Consulting

Project Limited; Toronto; On-site; CAD 150,000 - 200,000; Full time

Job summary

Project X Ltd. in Toronto, Ontario, is seeking a Solutions Architect to design and deliver scalable data solutions. You will apply Snowflake expertise to optimize data architecture, performance, and cost in a cloud environment, guiding clients from strategy to deployment.

The role requires strong SQL and Python skills, hands-on experience with data modeling, and the ability to lead data migration and governance initiatives while communicating complex concepts to non-technical stakeholders.

Qualifications

• 5+ years in data architecture or engineering, with hands-on Snowflake experience.
• Proven ability to troubleshoot and optimize Snowflake performance and costs.
• 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.

Responsibilities

• 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 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.

Skills

Snowflake

SQL

Python

Data architecture

Performance tuning

AWS

Azure

GCP

Data modeling

Stakeholder management

Communication

Tools

Snowpipe

Snowpark

Snowflake

Job description

Solutions Architect

Company: Project X Ltd.

Location: Toronto, Ontario

Employment Type: Full Time

Location: (Hybrid working model)

Total Compensation: $150,000-200,000

About Project X Ltd.

Project X Ltd. builds high-performing teams of talented, client-focused problem solvers who thrive on complex data challenges. Guided by our values of Care, Bravery, Excellence, and Innovation, we value people who take ownership of their work, step up when needed, and get things done.

Our team members are trusted advisors who collaborate closely, think creatively, and deliver practical, high-quality solutions for our clients. We look for individuals who are curious, accountable, eager to learn, and supportive of their teammates—because at Project X, our people are what make us great.

Role Summary

As a Solutions 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.

Key Responsibilities

• 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 We’re Looking For – Required Qualifications

• 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.

Use of Artificial Intelligence in Recruitment

Project X may use automated or AI-enabled tools as part of the recruitment and selection process. These tools may support activities such as resume screening, candidate matching, or application management. All hiring decisions involve human review and judgment.

Employment Equity, Accessibility & Accommodations

Project X is committed to fostering an inclusive, accessible workplace. Accommodations are available upon request in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code.

Privacy Notice

Personal information collected during the recruitment process will be used solely for recruitment purposes and handled in accordance with applicable privacy legislation.