About the role
Position Description
CGI is the world's 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 Architect 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.
CGI is the world's 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 Architect 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 Microsoft Fabric. You will define and govern Bronze, Silver, and Gold data zones with Fabric Lakehouse, establish metadata and data quality standards, and design governance structures leveraging OneLake and Microsoft Purview to enable secure, scalable analytics and regulatory reporting.
You will work closely with Data Engineers, Analytics Engineers, Data Scientists, Cloud Architects, 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 Microsoft Fabric 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, streaming, and near real time data workloads.
- Design integration between Fabric Lakehouse, Fabric Warehouse, and Power BI semantic models for scalable analytics consumption.
Metadata, Governance & Data Management
- Design and implement governance models leveraging Microsoft Fabric, OneLake, and Microsoft Purview.
- Define metadata standards, data ownership models, and lineage practices to support auditability and regulatory compliance.
- Implement fine-grained access controls, workspace governance, and role-based access models 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 and Fabric Warehouses optimized for BI tools, regulatory submissions, and executive reporting.
- Design Power BI–ready semantic models to support consistent metrics and trusted 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 across Fabric pipelines.
Cloud & Platform Integration
- Design Microsoft Fabric architectures integrated with Azure services (E.g. Azure Data Lake Storage, Azure Key Vault, Azure Event Hubs, etc.)
- Define ingestion patterns using Fabric Data Factory pipelines, Dataflows Gen2, and Spark notebooks
- 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 Microsoft Fabric 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 Must-Have Technical Experience
- 8–12+ years of experience in data architecture, analytics platforms, or data engineering, including: Microsoft Fabric architecture Fabric Lakehouse, Warehouse, and OneLake Bronze / Silver / Gold data modeling patterns Data governance and lineage using Microsoft Purview
- Strong experience with Azure cloud data platforms.
- 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 semantic models and enterprise BI architecture.
- Familiarity with data quality frameworks and observability tools.
- Knowledge of DevOps / DataOps practices (CI/CD for data pipelines).
- Agile delivery experience.
Education & Certifications
- Bachelor's degree in Computer Science, Engineering, Data Science, or a related field.
- Azure Data Engineer Associate (DP-203) is a strong asset.
- Microsoft Azure architecture certifications 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 $85,000 to $165,000.
Together, as owners, let’s turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll 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. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll 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.
You’ll shape your career by joining a company built to grow and last. You’ll 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 team—one of the largest IT and business consulting services firms in the world.
About CGI
Insights you can act on to achieve trusted outcomes.
We are insights-driven and outcomes-focused to help accelerate returns on your investments. Across 21 industry sectors and 400 locations worldwide, we provide comprehensive, scalable and sustainable IT and business consulting services that are informed globally and delivered locally.
We value your opinions and welcome your comments and questions on our posts here on LinkedIn. Please keep a polite, professional and constructive tone. We remove comments containing objectionable language and derogatory views. We do not allow content that is unrelated to the subject, and we remove discriminatory and racist comments as well as spam and advertising.
Note that content on this page contains general information regarding CGI’s services and initiatives and should not be considered direct business advice. To engage in a discussion with one of our experts, please make a request through https://www.cgi.com/en/contact-us
Similar jobs you might like
About the role
Position Description
CGI is the world's 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 Architect 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.
CGI is the world's 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 Architect 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 Microsoft Fabric. You will define and govern Bronze, Silver, and Gold data zones with Fabric Lakehouse, establish metadata and data quality standards, and design governance structures leveraging OneLake and Microsoft Purview to enable secure, scalable analytics and regulatory reporting.
You will work closely with Data Engineers, Analytics Engineers, Data Scientists, Cloud Architects, 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 Microsoft Fabric 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, streaming, and near real time data workloads.
- Design integration between Fabric Lakehouse, Fabric Warehouse, and Power BI semantic models for scalable analytics consumption.
Metadata, Governance & Data Management
- Design and implement governance models leveraging Microsoft Fabric, OneLake, and Microsoft Purview.
- Define metadata standards, data ownership models, and lineage practices to support auditability and regulatory compliance.
- Implement fine-grained access controls, workspace governance, and role-based access models 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 and Fabric Warehouses optimized for BI tools, regulatory submissions, and executive reporting.
- Design Power BI–ready semantic models to support consistent metrics and trusted 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 across Fabric pipelines.
Cloud & Platform Integration
- Design Microsoft Fabric architectures integrated with Azure services (E.g. Azure Data Lake Storage, Azure Key Vault, Azure Event Hubs, etc.)
- Define ingestion patterns using Fabric Data Factory pipelines, Dataflows Gen2, and Spark notebooks
- 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 Microsoft Fabric 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 Must-Have Technical Experience
- 8–12+ years of experience in data architecture, analytics platforms, or data engineering, including: Microsoft Fabric architecture Fabric Lakehouse, Warehouse, and OneLake Bronze / Silver / Gold data modeling patterns Data governance and lineage using Microsoft Purview
- Strong experience with Azure cloud data platforms.
- 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 semantic models and enterprise BI architecture.
- Familiarity with data quality frameworks and observability tools.
- Knowledge of DevOps / DataOps practices (CI/CD for data pipelines).
- Agile delivery experience.
Education & Certifications
- Bachelor's degree in Computer Science, Engineering, Data Science, or a related field.
- Azure Data Engineer Associate (DP-203) is a strong asset.
- Microsoft Azure architecture certifications 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 $85,000 to $165,000.
Together, as owners, let’s turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll 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. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll 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.
You’ll shape your career by joining a company built to grow and last. You’ll 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 team—one of the largest IT and business consulting services firms in the world.
About CGI
Insights you can act on to achieve trusted outcomes.
We are insights-driven and outcomes-focused to help accelerate returns on your investments. Across 21 industry sectors and 400 locations worldwide, we provide comprehensive, scalable and sustainable IT and business consulting services that are informed globally and delivered locally.
We value your opinions and welcome your comments and questions on our posts here on LinkedIn. Please keep a polite, professional and constructive tone. We remove comments containing objectionable language and derogatory views. We do not allow content that is unrelated to the subject, and we remove discriminatory and racist comments as well as spam and advertising.
Note that content on this page contains general information regarding CGI’s services and initiatives and should not be considered direct business advice. To engage in a discussion with one of our experts, please make a request through https://www.cgi.com/en/contact-us