Data Engineer

ABOUT THE JOB: 
The aim of Global Banking Technology & Operations (GBTO) Canada is to deliver day-to-day services to Société Générale investment and corporate bank units and their clients to accelerate their transformation. GBTO differentiates itself from competitors with the pace of the agile transformation delivered, spreading the technology and data culture, shortening the decision-making process, and adopting a true industrial approach, leveraging on different teams either transversal or aligned to the different sub business units.

The Counterparty Credit Risk (CCR) team belongs to the XRM (Cross Risk Metrics) department that aims at supporting and developing tools primarily for the risk department (RISQ). You will join the CCR AMER feature team in charge of several applications including post-origination portfolio monitoring tools shared by 1LOD and 2LOD, used to digitize key forms & decisions, automate manual processes & permanent controls, create a clean audit trail, generate real-time reporting, and improve data quality.

We heavily rely on Agile framework (Scrum):

• To build a solid and trustful relationship with our functional partners thanks to a continuous and transparent communication. 
• To maintain a strong team dynamic that focuses on the delivery of value for the users and maintaining the application with a long-term view.

Autonomous on your developments, you will always have the support of the team to continuously improve functionally and technically. You will be encouraged to also share your point of view and approaches in software craftmanship. Continuous improvement is key for us!

• Create and maintain clean audit trails and generate real-time reporting.
• Improve data quality and reliability across applications.
• Work within an Agile Scrum framework to ensure continuous and transparent communication with functional partners.
• Contribute to a strong team dynamic focused on long-term value delivery and application sustainability.
•  
• Design, build, and maintain scalable and robust data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data.
• Participate in data remodeling initiatives supporting migration from on‑premises private cloud environments to Microsoft Azure.
• Develop, test, and maintain databases, large-scale processing systems, and data warehouses optimized for cloud deployment.
• Collaborate with risk analysts and other stakeholders to gather data requirements and deliver high-quality datasets for analytics and machine learning.
• Optimize data delivery by redesigning infrastructure for scalability, reliability, and efficiency.
• Implement and enforce data security, governance, and compliance standards in line with internal policies and regulatory requirements.
• Monitor and troubleshoot data systems to ensure data integrity, availability, and performance.
• Automate repetitive data tasks and workflows to improve operational efficiency.
• Stay up to date with industry trends, tools, and cloud technologies to continuously improve data engineering practices.
• Document data engineering processes, data flows, and system configurations.
• Manage release processes, including release notes, deployment scripts, contingency plans, and rollback procedures.
• Participate in L3 production support and incident management, including root cause analysis and resolution.
   

Requirements

• Bachelor’s degree in Computer Science or a related field.
• 3 to 5 years of professional experience as a Data Engineer or in a similar role.
• Strong proficiency with MS SQL Server 2022, including complex queries, stored procedures, and performance tuning.
• Experience with Azure Synapse Analytics for large-scale data warehousing.
• Expertise in designing, building, and maintaining ETL pipelines.
• Hands-on experience with Apache Spark and Databricks for big data processing and transformation.
• Solid knowledge of Microsoft Azure cloud services, including data services and infrastructure management.
• Proficiency in Python for data manipulation, automation, and scripting.
• Strong skills in Power BI and advanced Excel to build dashboards and reports.
• Proficiency with GitHub for source code management and collaborative development workflows.
• Comfort working in Unix/Linux environments.
• Ability to communicate effectively in English, both orally and in writing.
• Ability to work in a bilingual environment (French and English)

Nice to have

• Experience with containerization technologies such as Kubernetes and Docker.
• Familiarity with 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
• Strong understanding of capital market products, including secured financing transactions, derivatives, or corporate loans.
• Knowledge of US or international financial regulations.
• ITIL certification.
• Azure Cloud certification.

LANGUAGE: 

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.

Societe Generale is committed to offering an inclusive recruitment experience to all candidates. If you require any reasonable accommodations during the recruitment process, please do not hesitate to let our Recruiters know.

OUR CULTURE: 
At Societe Generale, we live by our 4 core values of commitment, responsibility, team spirit and innovation. We are engaged and demonstrate consideration for others. We act ethically and with courage. We focus our talent and energy on collective success. We experiment and propose new ideas. This way, we maximize our ability to serve client needs and anticipate market changes. Societe Generale is committed to strengthening bonds with colleagues, communities, and the world in which we live, because relationships are at the heart of how we operate. For more information about our Culture and Conduct initiatives, please visit this link (https://americas.societegenerale.com/en/careers/get-know-culture/)

D&I: 
Our Diversity & Inclusion Mission: Recruit, develop, advance, and retain a diverse workforce that is united in our efforts to enhance our competitive position and deliver innovative solutions to our clients.
Our Diversity & Inclusion Vision:

• Engaged workforce that is demographically diverse in a way that reflects the communities in which we operate
• Inclusive culture and workplace that recognizes employees' unique needs and utilizes their diverse talents
• Engage our community and marketplace, and position the organization to meet the needs of all its clients

For more information about our D&I initiatives, please visit this link (https://americas.societegenerale.com/en/careers/get-know-diversity/)