データパイプラインの設計・構築およびオンプレミス環境からMicrosoft Azureへのアプリケーション移行を担当します。コンピュータサイエンス関連の学士号が必須であり、MS SQL Server 2022、Azure Synapse、ETL、Apache Spark、Databricks、Pythonのスキルが求められます。米国パートナーとの連携のため、英語での円滑なコミュニケーション能力が必要です。米国連邦証券法に基づき、指紋採取を含む厳格な身元調査が行われる場合があります。
ResponsibilitiesABOUT 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!YOUR MISSIONDesign, build, and maintain scalable and robust data pipelines to ingest, process, and transform large volumes of structured and unstructured data from multiple sources.Participate actively in data remodeling initiatives to support the migration of applications from on-premises private cloud environments to Microsoft Azure.Develop, construct, test, and maintain architecture such as databases, large-scale processing systems, and data warehouses optimized for cloud deployment.Collaborate with risk analysts, and other stakeholders to understand data requirements and deliver high-quality datasets for analytics and machine learning.Optimize data delivery, re-designing infrastructure for greater scalability, and ensuring the reliability and efficiency of data systems.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 updated with the latest industry trends, tools, and cloud technologies to continuously improve data engineering processes.Document data engineering processes, data flows, and system configurations to facilitate knowledge sharing and maintenance.Manage release processes, including drafting release notes, developing release scripts, and leading deployments with contingency and rollback plans.Production: Participate in L3 support and incident management, including root cause analysis and resolution. TECHNICAL STACK | Oracle DB| ETL | Power BI | Excel |Python |Spark | Azure Synapse ||Azure Services | Kubernetes | Docker | Terraform | OAuth 2.0| Github |Unix/Linux|| Java | REST API |Github Actions|Profile requiredLANGUAGE: 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.Due to US Federal Securities law that may apply to this position, candidates who will apply for this position may be required to submit to an enhanced background screening, including the collection of their fingerprints by a third-party vendor selected by the Financial Industry Regulatory Authority ("FINRA").SKILLS AND QUALIFICATIONS:Must Have:Bachelor’s degree in computer science or related field. Strong proficiency with MS SQL Server 2022, including writing 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. Proficient in Python for data manipulation, automation, and scripting. Skilled in Power BI and advanced Excel techniques to create insightful dashboards and reportsProficient with GitHub for source code management and collaborative development workflows.Comfortable working in Unix/Linux environments for development and deployment tasks.Nice to Have:Experience with containerization technologies such as Kubernetes and Docker. Familiarity with infrastructure as code tools like Terraform.Experience with Java development.Experience with Angular 14+ and Bootstrap 5 for building responsive and user-friendly web interfaces.Experience with concepts and literature related to Credit and Counterparty RiskHigh level understanding of capital market products (secured financing transactions; derivatives) or corporate loansKnowledge of US or international financial regulationsITIL CertificationAzure Cloud certificationLanguages: French, EnglishAbility 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.Experience: 3 to 5 years minimumWhy join usBusiness insightSociete 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 operateInclusive culture and workplace that recognizes employees' unique needs and utilizes their diverse talentsEngage our community and marketplace, and position the organization to meet the needs of all its clientsFor more information about our D&I initiatives, please visit this link (https://americas.societegenerale.com/en/careers/get-know-diversity/)
