Senior Consultant, Data Architect

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

Job summary

A leading company in data solutions is seeking a Data Architect to oversee and optimize complex data architectures. You will design, implement, and manage end-to-end data solutions, enhancing business value through data. We are looking for someone with strong expertise in Snowflake and cloud environments, coupled with the ability to collaborate and communicate effectively with various stakeholders.

Qualifications

• 5+ years in data architecture or engineering with hands-on Snowflake experience.
• Proven ability to troubleshoot Snowflake performance issues.
• Deep knowledge of cloud platforms (AWS, Azure, GCP).

Responsibilities

• Design and implement comprehensive data solutions from strategy through deployment.
• Lead data migration and integration projects using tools like Snowpipe.
• Act as a trusted advisor, facilitating workshops and providing thought leadership.

Skills

Data Architecture

Snowflake

SQL

Python

Cloud Platforms

Data Modeling

Stakeholder Management

Tools

AWS

Azure

GCP

Microstrategy

Tableau

Power BI

Job description

Project X Ltd. drives success by focusing on building teams of 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 growth.

Our team members are trusted advisors to our clients, offering innovative solutions to complex data problems. Collaboration, creativity, data knowledge, and experience are core to our culture. We value building long-term relationships with our clients and aligning new team members with our values.

We are passionate about our people. Hiring and developing individuals who seek challenges, enjoy learning new skills, and are willing to help peers contribute to our success.

Role Summary

As a Data Architect at Project X Ltd., you will leverage your knowledge and experience to make sense of messy, unstructured data. You will design, implement, and oversee end-to-end data solutions that address complex business challenges and unlock data value for our clients. Expertise in Snowflake is essential to optimize data architecture, performance, and cost efficiency in a cloud environment.

What You’ll Do

• Design and implement comprehensive data solutions from strategy through deployment.
• Shape enterprise data strategies, architecture, and governance frameworks.
• 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, facilitating workshops and providing 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, data sharing, cost strategies, and deployment.
• Proven ability to troubleshoot Snowflake performance issues, manage virtual warehouses, and implement best practices for scaling.
• Deep knowledge of cloud platforms (AWS, Azure, GCP).
• Strong skills in SQL and Python.
• Experience with data modeling, integration, and governance frameworks.
• Familiarity with BI tools like Microstrategy, Tableau, or Power BI.
• Excellent communication and stakeholder management skills, capable of translating technical concepts for non-technical audiences.

Nice to Have

• SnowPro certification or other Snowflake credentials.
• Certifications in AWS, Azure, or GCP architecture.
• Passion for mentoring and enabling data-driven decisions.
• Knowledge of emerging trends like data mesh, event-driven architectures, and streaming analytics.

We are committed to fair and equitable treatment of all employees and applicants. Project X Ltd. provides equal employment opportunities regardless of age, sex, disability, race, ethnicity, citizenship, creed, sexual orientation, marital status, or other grounds as per the Ontario Human Rights Code. Accommodations are available during the hiring process.

Project X Ltd. is an equal opportunity employer and welcomes applications from people with disabilities. Accommodations are available upon request for all stages of the hiring process.