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 (1 LOD and 2 LOD).
• 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 Git Hub 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…