Data Engineer Intermediate

Position Description:

CGI is looking for an Intermediate Data Engineer to join a strategic team supporting Investment and Corporate Banking activities within Global Banking Technology & Operations (GBTO) in Canada.

You will be part of the XRM – Cross Risk Metrics department, within the Counterparty Credit Risk (CCR) team, delivering critical data-driven solutions supporting Risk functions.
In this role, you will actively contribute to an accelerated agile transformation while designing, building, and maintaining robust, secure, and scalable data solutions within a Microsoft Azure cloud environment.

Work Mode: On-site
Location: Montreal

Why Join CGI?
• Work on high-value projects in the financial services and banking sector.
• Be part of a modern, innovative, and agile technology environment.
• Join a collaborative team focused on long-term value and solution sustainability.
• Access continuous learning, professional development, and career advancement opportunities within a global organization.

Your future duties and responsibilities:

• Provide day-to-day support to Investment and Corporate Banking units and their clients.
• Contribute to agile transformation by promoting a strong technology and data-driven culture.
• Develop and maintain post-origination portfolio monitoring applications used by Risk teams (1LOD and 2LOD).
• Digitize key forms and decision workflows to automate manual processes and permanent controls.
• Create and maintain reliable audit trails and deliver real-time reporting.
• Improve data quality, consistency, and reliability across applications.
• Work within an Agile Scrum framework to ensure continuous and transparent communication with business stakeholders.
• Design, build, and maintain scalable data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data.
• Participate in data remodelling initiatives supporting migration from on-premises environments to Microsoft Azure.
• Develop, test, and maintain cloud-optimized databases, large-scale processing systems, and data warehouses.
• Collaborate closely with risk analysts and stakeholders to gather data requirements and deliver high-quality datasets for analytics and machine learning.
• Optimize data platforms and infrastructure for scalability, reliability, and performance.
• Implement and enforce data security, governance, and compliance standards in line with regulatory requirements.
• Monitor and troubleshoot data systems to ensure integrity, availability, and performance.
• Automate repetitive data tasks and workflows to improve operational efficiency.
• Document data engineering processes, data flows, and technical configurations.
• Manage release processes, including deployment scripts, release notes, contingency plans, and rollback procedures.
• Participate in Level 3 production support (L3), including incident management, root cause analysis, and resolution.

Required qualifications to be successful in this role:

• Bachelor’s degree in Computer Science or a related field.
• 3 to 5 years of experience as a Data Engineer or in a similar role.
• Strong expertise with MS SQL Server (complex queries, stored procedures, performance tuning).
• Experience with Azure Synapse Analytics and large-scale data warehousing.
• Proven experience designing, building, and maintaining ETL pipelines.
• Hands-on experience with Apache Spark and Databricks.
• Solid knowledge of Microsoft Azure cloud services and data platforms.
• Proficiency in Python for data processing, scripting, and automation.
• Strong skills in Power BI and advanced Excel for reporting and dashboards.
• Experience using GitHub for source code management and collaboration.
• Comfortable working in Unix/Linux environments.
• Strong communication skills in English (oral and written).
• Ability to work in a bilingual environment (English and French)*.

Nice to Have
• Experience with Docker and Kubernetes.
• Knowledge of Infrastructure as Code tools such as Terraform.
• Experience with .NET technologies (.NET 7 / .NET 8) and Entity Framework.
• Experience with Angular 14+ and Bootstrap 5.
• Knowledge of Credit and Counterparty Risk concepts.
• Understanding of capital market products (derivatives, secured financing, corporate loans).
• Knowledge of US or international financial regulations.
• ITIL and/or Azure Cloud certifications.

*Ability to communicate in English, both orally and in writing, is a requirement as the person in this position will need to collaborate regularly with colleagues and partners in the United States and in Europe.


CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $70,–$,. This role is an existing vacancy.

#LI-AR1

Bilingualism (French and English) is required for this position due to the nature of the role requiring interaction with national and global clients.

Use of the term ‘engineering’ in this job posting refers to the technical sense related to Information Technology (IT) and does not imply that the individual practices engineering or possesses the requisite license as prescribed by the applicable provincial or territorial engineering regulator. We are seeking individuals with expertise in IT engineering-related functions, but licensure from an engineering regulator is not a prerequisite for this position. Engineering is a regulated profession in Canada which is restricted in terms of use of titles and designation.

Skills:

• English
• French
• ETL
• Python