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

. Design and implement Unity Catalog architectures, including catalogs, schemas, tables, views, and access controls.
. Define metadata standards, data ownership models, and lineage practices to support auditability and regulatory compliance.
. Implement fine-grained access controls aligned with enterprise security, privacy, and compliance requirements.
. Partner with governance and risk teams to ensure compliance with regulatory frameworks and internal data policies.

Analytics & Regulatory Reporting Enablement

. Architect Gold-layer datasets optimized for BI tools, regulatory submissions, and executive reporting.
. Ensure data structures support reproducibility, traceability, and explainability of metrics.
. Collaborate with analytics and reporting teams to align data models with business definitions and regulatory rules.
. Support data quality monitoring, validation frameworks, and exception handling.

Cloud & Platform Integration

. Design Databricks architectures integrated with cloud-native services (e.g., Azure Data Lake Storage, Azure Synapse, Azure Key Vault).
. Define ingestion patterns using tools such as Auto Loader, Delta Live Tables, and structured streaming.
. Ensure platform designs meet enterprise requirements for scalability, resilience, cost optimization, and operational monitoring.

Client Advisory & Delivery Leadership

. Act as a trusted advisor to client stakeholders on Lakehouse architecture, data strategy, and analytics modernization.
. Lead architecture workshops, define target-state architectures, and produce high-quality solution design documentation.
. Provide technical leadership across delivery teams, guiding best practices and architectural decision-making.
. Mentor data engineers and analytics teams, contributing to CGI's Data & AI Centers of Excellence.

Required qualifications to be successful in this role:

Qualifications
Must-Have Technical Experience

. 8–12+ years of experience in data architecture, analytics platforms, or data engineering, including:
Databricks Lakehouse architecture Delta Lake (tables, optimization, versioning) Bronze / Silver / Gold data modeling patterns Unity Catalog design and governance
. Strong experience with cloud data platforms (Azure preferred).
. Proven experience designing data solutions that support analytics, BI, and regulatory reporting.
. Deep understanding of data governance, metadata management, and security controls.

Industry & Regulatory Experience

. Experience delivering data platforms in regulated industries such as Energy, Utilities, Financial Services, or Government.
. Familiarity with regulatory reporting, audit requirements, and data traceability concepts..

Leadership & Consulting Experience

. Demonstrated ability to lead architecture initiatives and guide cross-functional technical teams.
. Strong stakeholder communication and requirements translation skills.
.…