Find similar career opportunities

Solution Architect (Databricks)

Category: Software Development/ Engineering

Main location: Canada, Ontario, Toronto

Position ID:J0926-1485

Employment Type: Full Time

Position Description:

This role is Hybrid and requires you to be in our Toronto, ON (minimum) 2 time per week.

We are seeking an experienced Solution Architect - Databricks to lead and facilitate the architecture, design, and delivery of enterprise-scale Databricks solutions.

The ideal candidate will bring deep expertise in Databricks, data architecture, ETL/data engineering, data modeling, Medallion Architecture, Unity Catalog, and DevOps/CI/CD practices. This is a senior, client-facing role requiring strong technical leadership as well as the ability to establish standards, guide engineering teams, facilitate architectural decisions, and ensure successful delivery.

The Solution Architect will work closely with architecture, engineering, data, delivery, and business stakeholders to ensure solutions are scalable, maintainable, aligned with enterprise architecture standards, and delivered within agreed timelines.

Your future duties and responsibilities:

Databricks-based data solutions.
Own or facilitate the overall development strategy, engineering standards, tooling, and delivery approach.
Define and govern common ingestion patterns across APIs, SFTP, streaming, and other enterprise data sources.
Establish and promote Medallion Architecture implementation standards.
Define and guide Data Vault 2.0 and Kimball data modeling patterns.
Establish standards for Unity Catalog, data governance, and reusable data architecture.
Design and govern audit and reconciliation frameworks, including data validation and traceability.
Establish robust error handling, recovery, and restartability patterns for data pipelines.
Define CI/CD standards, coding conventions, reusable templates, and accelerators.
Lead architecture and design reviews and maintain technical decision logs.
Facilitate technical decision-making across architecture, development, data, and client stakeholder groups.
Review requirements, specifications, and solution designs and provide development estimates.
Lead release and sprint planning, validating estimates, resource requirements, dependencies, and required skill sets.
Monitor delivery against agreed scope, effort, quality, and schedule commitments.
Identify technical and delivery risks and drive appropriate resolution or escalation.
Act as a key client-facing technical contact for Databricks and data engineering delivery.
Provide technical coaching and mentorship to engineers and senior engineers.
Encourage innovation, knowledge sharing, engineering excellence, and continuous improvement across the team.

Required qualifications to be successful in this role:

The successful candidate should be capable of owning or facilitating:

Databricks Solution Architecture & Design
Databricks Lakehouse Architecture
Medallion Architecture
Unity Catalog
API, SFTP & Streaming Ingestion Patterns
ETL / Data Engineering
Data Vault 2.0
Kimball Dimensional Modeling
Data Modeling & Solution Design
Audit & Reconciliation Frameworks
Error Handling & Restartability
DevOps Engineering
CI/CD Standards & Automation
Coding Standards & Conventions
Design & Architecture Reviews
Technical Decision Logs
Reusable Templates & Accelerators
Technical Coaching & Engineering Governance
Key Competencies
Strong hands-on knowledge of Databricks architecture and enterprise data platforms.
Ability to define and own an overall technical and development strategy.
Strong solution architecture and solution design capabilities.
Deep understanding of data modeling, ETL, and modern data engineering practices.
Experience estimating and costing complex development efforts.
Strong understanding of the software development lifecycle (SDLC) and engineering quality practices.
Experience leading technical teams or multiple engineering workstreams.
Strong client-facing and stakeholder management skills.
Ability to assess technical risks, resolve complex problems, and facilitate architectural decisions.
Strong communication, leadership, mentoring, and technical coaching capabilities.
Ability to collaborate effectively across architecture, engineering, delivery, and business teams.
Preferred Certifications

Relevant certifications are considered an asset, including:

Azure or AWS Cloud Certification - Associate level or higher
Professional-level Cloud Certification
Other relevant architecture, cloud, Agile, or security certifications

"CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $115,000-$165,000. This role is an existing vacancy."

#LI-AV1

Use of the term 'architect' in this job posting refers to the technical sense related to Information Technology (IT) and does not imply that the individual practices architecture or possesses the requisite license as prescribed by the applicable provincial or territorial architect regulator. We are seeking individuals with expertise in IT architect-related functions, but licensure from an architect regulator is not a prerequisite for this position. Architecture is a regulated profession in Canada which is restricted in terms of use of titles and designation.

Skills:

• Data Modeling
• Databricks
• ETL
• Financial Services
• Leadership
• Solution Design
• Solutions Architecture