Databricks Architecture Consultant

Position Description :

CGI is the world's 5th largest independent IT and business consulting services firm, operating across 40 countries and delivering more than IP-based solutions to clients in Financial Services, Government, Healthcare, Manufacturing, Utilities, Oil & Gas, and more. We are recognized globally for our on-time, on-budget delivery and our role as a trusted advisor to leading organizations.

As organizations accelerate their data and analytics modernization, CGI is expanding its Data & AI consulting practice. We are seeking a Data Architecture Consultant with deep expertise in Lakehouse architecture, data modeling, governance, and regulatory reporting, ideally with experience in highly regulated industries such as Energy, Utilities, Financial Services or Government.

Join our team and help design and implement enterprise-scale analytics platforms that enable trusted insights, advanced analytics, and regulatory compliance.

Your future duties and responsibilities :

As a Data Architect, you will be responsible for the end-to-end architecture and design of enterprise Lakehouse platforms built on Databricks. You will define and govern Bronze, Silver, and Gold data zones, establish metadata and data quality standards, and design Unity Catalog structures that enable secure, scalable analytics and regulatory reporting.

You will work closely with Data Engineers, Analytics Engineering Consultants, Data Scientists, Cloud Architecture Consultants, and Business Stakeholders to ensure data platforms are well-governed, performant, auditable, and aligned to business and regulatory requirements.

Key Responsibilities

Lakehouse Architecture & Data Modeling

• . Architect and design Databricks Lakehouse solutions using Bronze, Silver, and Gold layers, ensuring clear separation of ingestion, refinement, and consumption.
• . Define enterprise data models optimized for analytics, BI, and regulatory reporting.
• . Establish data design standards for schemas, naming conventions, partitioning, and performance optimization.
• . Ensure Lakehouse designs support both batch and streaming data workloads.

Metadata, Governance & Unity Catalog

Analytics & Regulatory Reporting Enablement

Cloud & Platform Integration

Client Advisory & Delivery Leadership

Required qualifications to be successful in this role :

Qualifications

Must-Have Technical Experience

Industry & Regulatory Experience

Leadership & Consulting Experience

Additional Assets

Education & Certifications

"CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes various factors including but not limited to skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $95, - $,."

#LI-AP1

Why CGI?

At CGI, you will help shape enterprise-scale data platforms that power decision-making and regulatory confidence for some of Canada's most complex organizations. You will work in an environment that values ownership, collaboration, and technical excellence—while growing your career in one of the world's largest independent consulting firms.

Learn more .

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 :