Business Intelligence (BI) Architect
Business Intelligence (BI) Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 (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.
#LI-NO1
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:
- French
- Data Architecture
- Data flow analysis
- ETL
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.
Employment Type
Full-Time
