Job Title

Join to apply for the Architecte en intelligence daffaires (BI) role at CGI 1 day ago Be among the first 25 applicants Join to apply for the Architecte en intelligence daffaires (BI) role at CGI Get AI-powered advice on this job and more exclusive features. 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 (Inmon, Kimball, dimensional modeling, Data Lake, ODS, DW, DM). Oversee the integration and use of Power BI, Azure Data Factory, Azure Synapse Analytics, Analysis Services, and Azure Data Lake Storage. Act as a subject-matter expert and advisor to the client, ensuring the quality of deliverables and the consistency of the overall architecture. Actively participate in design, development, and deployment phases while providing guidance to the BI team. Requirements Bachelors degree in Information Technology (Computer Science, Software Engineering, or Computer Engineering). At least 10 years of IT experience, including a minimum of 8 years as a BI Architect or Data Architect. At least 4 years of experience in database architecture, ETL design, SSIS integration, and relational, multidimensional, logical, and physical modeling. At least 4 years of experience in modeling data flows, data warehouses, and data marts. At least 4 years of experience in BI projects using Inmon and/or Kimball approaches, as well as classic BI techniques (dimensional modeling, Data Lake, ODS, DW, DM). At least 2 years of experience with Power BI. At least 2 years of experience with Microsoft BI solutions on Azure (Azure Data Factory, Azure Synapse Analytics, Analysis Services, Azure Data Lake Storage). Proven experience as a BI advisor on a large-scale project (2000 person-days) with at least 200 person-days of personal contribution, in a Microsoft Azure environment using the solutions listed above. Desired Profile Strong ability to translate complex business needs into robust, scalable technology solutions. Experience working in government or highly regulated environments. Excellent communication skills and ability to collaborate with diverse stakeholders. Results-oriented with a strong focus on quality. Your future duties and responsibilities Required Qualifications To Be Successful In This Role 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. Architecte en intelligence daffaires (BI) Job Description CGI est la recherche dun(e) Architecte BI expriment(e) pour se joindre une initiative stratgique de modernisation des systmes dintelligence daffaires dun organisme gouvernemental situ au centre-ville de Montral. Ce projet majeur vise transformer et optimiser linfrastructure BI en adoptant des solutions Microsoft modernes et volutives, afin de soutenir les besoins analytiques et dcisionnels long terme. Responsabilits principales Concevoir et mettre en uvre larchitecture BI dans un environnement Microsoft Azure, en respectant les meilleures pratiques et les normes de lindustrie. Collaborer avec les parties prenantes pour analyser les besoins daffaires et dfinir les solutions technologiques adaptes. Concevoir et modliser des entrepts de donnes, comptoirs de donnes et flux dintgration, incluant la modlisation relationnelle, multidimensionnelle, logique et physique. laborer et optimiser les processus ETL, notamment avec SSIS et dautres outils dintgration. Appliquer les approches et techniques BI classiques (Inmon, Kimball, modlisation dimensionnelle, Data Lake, ODS, DW, DM). Superviser lintgration et lutilisation des outils Power BI, Azure Data Factory, Azure Synapse Analytics, Analysis Services et Azure Data Lake Storage. Agir en tant que conseiller expert auprs du client, en assurant la qualit des livrables et la cohrence de larchitecture globale. Participer activement aux phases de conception, de dveloppement et de dploiement, tout en encadrant lquipe BI. Exigences Diplme universitaire de premier cycle (baccalaurat) en technologies de linformation (informatique, gnie logiciel ou gnie informatique). Minimum de 10 ans dexprience en TI, dont au moins 8 ans comme architecte BI ou architecte de donnes. Minimum de 4 ans dexprience en architecture de bases de donnes, conception ETL, intgration SSIS, modlisation relationnelle, multidimensionnelle, logique et physique. Minimum de 4 ans dexprience en modlisation de flux de donnes, entrepts de donnes et comptoirs de donnes. Minimum de 4 ans dexprience en projets BI utilisant les approches Inmon et/ou Kimball, ainsi que les techniques BI classiques (modlisation dimensionnelle, Data Lake, ODS, DW, DM). Minimum de 2 ans dexprience avec Power BI. Minimum de 2 ans dexprience avec les solutions Microsoft BI sur Azure (Azure Data Factory, Azure Synapse Analytics, Analysis Services, Azure Data Lake Storage). Exprience confirme comme conseiller BI dans un mandat denvergure (2000 j-p) avec au moins 200 j-p de contribution personnelle, dans un environnement Microsoft Azure intgrant les solutions mentionnes ci-dessus. Profil recherch Excellente capacit traduire des besoins daffaires complexes en solutions technologiques robustes et volutives. Capacit travailler dans des environnements gouvernementaux ou hautement rglements. Fortes comptences en communication et aptitude collaborer avec divers intervenants. Orientation rsultats et souci de la qualit. Your future duties and responsibilities Required Qualifications To Be Successful In This Role Ensemble, en tant que propritaires, mettons notre savoir-faire luvre. La vie chez CGI est ancre dans lactionnariat, le travail dquipe, le respect et un sentiment dappartenance. Chez nous, vous pourrez exploiter votre plein potentiel parce que Nous vous invitons devenir propritaire ds le jour 1 alors que nous travaillons ensemble faire de notre rve une ralit. Cest pourquoi nous nous dsignons comme associs de CGI, plutt que comme employs. Nous tirons profit des retombes de notre succs collectif et contribuons activement lorientation et la stratgie de notre entreprise. Votre travail cre de la valeur. Vous laborerez des solutions novatrices et dvelopperez des relations durables avec vos collgues et clients, tout en ayant accs des capacits mondiales pour concrtiser vos ides, saisir de nouvelles opportunits, et bnficier dune expertise sectorielle et technologique de pointe. Vous ferez voluer votre carrire en vous joignant une entreprise btie pour crotre et durer. Vous serez soutenus par des leaders qui ont votre sant et bien-tre cur et qui vous permettront de saisir des occasions afin de parfaire vos comptences et largir les horizons. Chez CGI, nous valorisons la richesse que la diversit apporte et nous nous engageons favoriser un environnement de travail o chacun spanouit. Nous collaborons avec nos clients pour btir des communauts plus inclusives et permettre tous les associs de CGI de russir. En tant quemployeur prnant lgalit des chances, il est important pour nous que vous puissiez donner le meilleur de vous-mme durant le processus de recrutement. Si vous avez besoin dun accommodement particulier, veuillez en informer votre recruteur. Pour en savoir plus sur l'accessibilit chez CGI, contactez-nous par courriel. Veuillez noter que ce courriel est strictement rserv aux demandes d'accessibilit et ne peut tre utilis pour vrifier l'tat dune candidature. Joignez-vous nous, lune des plus importantes entreprises de conseil en technologie de linformation (TI) et en management au monde. Seniority level Seniority level Mid-Senior level Employment type Employment type Full-time Job function Job function Design, Art/Creative, and Information Technology Industries IT Services and IT Consulting Referrals increase your chances of interviewing at CGI by 2x Sign in to set job alerts for Architect roles. Experience Design Architect, Canada, East Coast (Remote) Architect - Healthcare Projects - Western Canada Solutions Architect (Insurance) - Fully Remote Principal Advisor Enterprise Architecture Application Architect - Policy Administration Platform Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr