Databricks Architecture Consultant

Position Description:

CGI is the worlds 5th largest independent IT and business consulting services firm operating across 40 countries and delivering more than 100 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 CGIs Data & AI Centers of Excellence.

Required qualifications to be successful in this role:

Qualifications
Must-Have Technical Experience

. 812 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.
. Experience producing architecture artifacts standards and reference designs.

Additional Assets

. Experience with Power BI or other BI tools consuming Databricks data.
. Familiarity with data quality frameworks and observability tools.
. Knowledge of DevOps / DataOps practices (CI/CD for data pipelines).
. Agile delivery experience.


Education & Certifications

. Bachelors degree in Computer Science Engineering Data Science or a related field.
. Databricks certifications (e.g. Databricks Data Architect Data Engineer) are a strong asset.
. Cloud certifications (Azure) are an asset.

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 $95000 - $185000.

#LI-AP1

Why CGI
At CGI you will help shape enterprise-scale data platforms that power decision-making and regulatory confidence for some of Canadas most complex organizations. You will work in an environment that values ownership collaboration and technical excellencewhile growing your career in one of the worlds 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:

• Apache Spark
• Data Analysis
• GIT
• GIT
• SQL

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer being able to perform your best during the recruitment process is important to us. If you require an accommodation please inform your recruiter.

To learn more about accessibility at CGI contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our teamone of the largest IT and business consulting services firms in the world.