Data Engineer Intermediate

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 2022 (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,000–$135,000. 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

What you can expect from us: