Business Intelligence (BI) Architect

Position Description:

CGI is seeking an experienced BI Architect to join a strategic initiative to modernize the business intelligence systems of a government organization located in downtown Montreal. This major project aims to transform and optimize the BI infrastructure by adopting modern, scalable Microsoft solutions to support long‑term analytical and decision‑making needs.

Main Responsibilities

• Design and implement BI architecture in a Microsoft Azure environment, following industry best practices and standards.
• Collaborate with stakeholders to analyze business needs and define suitable technology solutions.
• Design and model data warehouses, data marts, and data flows, including relational, multidimensional, logical, and physical modeling.
• Develop and optimize ETL processes, particularly using SSIS and other integration tools.
• Apply classic BI approaches and techniques ...