Senior Technical Solution Architect

isgSearch; Greater Toronto Area; On-site; CAD 180,000 - 200,000; Full time

Job summary

A leading company is seeking a Senior Technical Solution Architect to design and deliver scalable Snowflake solutions, providing technical leadership and mentoring within the consulting practice. The role includes advising clients, optimizing implementations, and leading teams in data solutions across diverse platforms.

Qualifications

• Hands-on advanced technical knowledge in Snowflake, SQL, MySQL, Oracle, MongoDB.
• Strong consulting experience with expertise in designing and delivering data architectures.

Responsibilities

• Advise clients on selecting the right data platform, including Snowflake.
• Design implementation plans and provide detailed estimates for execution.
• Lead teams in delivering data solutions, including data engineering and data modeling.

Skills

Snowflake

Python

Data Modeling

Data Problem Solving

Education

Certified Data Architect

SnowPro Advanced Architect

SnowPro Advanced Data Engineer

AWS Solution Architect

Tools

SQL

MySQL

Oracle

MongoDB

Databricks

Redshift

Job description

Join to apply for the Senior Technical Solution Architect role at isgSearch.

Get AI-powered advice on this job and more exclusive features.

This range is provided by isgSearch. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$180,000.00/yr - CA$200,000.00/yr

Direct message the job poster from isgSearch

About the role

The Sr Solution Architect designs and delivers scalable Snowflake solutions that drive transformation. Acting as a lead problem solver, the Sr Solution Architect will interact with clients and provide technical leadership for pre-sales, project execution, and innovation, while mentoring and building technical expertise within the consulting practice.

Principal tasks and responsibilities include:

• Advise clients on selecting the right data platform, including Snowflake, based on their specific business needs.
• Translate business requirements into scalable, data-driven solutions across modern data platforms.
• Optimize data platform implementations.
• Leverage advanced platform features, such as Snowflake's Snowpark and Streams, to ensure robust data models and governance.
• Design implementation plans and provide detailed estimates for execution.
• Lead teams in delivering data solutions, including data engineering and data modeling, across diverse platforms.
• Develop data models and present them to clients with clear justifications for key design decisions.
• Create cutover plans and data parity frameworks to align with client needs.
• Propose long-term solutions for ongoing data operations.
• Provide guidance and unblock development teams with high-level decisions and code-level support as needed.

Qualifications and pre-requisites:

• Hands-on advanced technical knowledge in Snowflake, SQL, MySQL, Oracle, MongoDB, Databricks, Redshift, Python.
• Desirable Certifications: Certified Data Architect, including SnowPro Advanced Architect, SnowPro Advanced Data Engineer, and AWS Solution Architect certifications.
• Provide architectural and technical guidance and leadership, ensuring solutions are aligned with business objectives and scalability.
• Design and optimize structured and semi-structured data models, utilizing modern data platforms like Snowflake.
• Strong consulting experience with expertise in designing and delivering data architectures.
• Develop scalable and secure data architectures adhering to security, privacy, compliance, and governance standards.
• Apply industry-standard security principles, including system-defined roles and access controls.
• Implement advanced data-sharing solutions, such as Snowflake's Secure Data Sharing.
• Optimize data ingestion and transformation processes, using tools like Snowpipe.
• Troubleshoot and resolve performance issues across data architectures.
• Design, build, and improve data pipelines for real-time processing and integration, incorporating features such as Streams and Tasks on platforms like Snowflake.

Desired Skills and Experience:

• Snowflake
• Python
• Data Modeling
• Data Problem Solving