This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
This is a senior-level individual contributor role responsible for the design, development, and maintenance of our database systems. The primary objective is to ensure the performance, integrity, and security of our data by developing robust and efficient database solutions. This individual will act as a subject matter expert on SQL Server and will be responsible for creating and optimizing complex stored procedures and database queries.
Job Responsibility
Design, develop, and maintain high-performance, scalable database solutions using SQL Server
Write, optimize, and maintain complex stored procedures, triggers, and user-defined functions to support business applications
Monitor and optimize database performance, identifying and resolving bottlenecks and performance issues
Design and implement logical and physical data models to meet business requirements
Ensure data integrity and consistency through the implementation of constraints, data validation rules, and other best practices
Develop and maintain ETL processes to load and transform data from various sources into the database
Work closely with application developers, business analysts, and other stakeholders to understand requirements and provide database solutions
Requirements
8+ years of experience as a database developer, with a strong focus on SQL Server as an individual contributor in a major bank, working within Risk or Marketing teams with a focus on the mortgage and/or retail/commercial banking industry
Expertise in SQL Server, including T-SQL, stored procedures, triggers, and performance tuning
Strong understanding of data modeling concepts and experience with data modeling tools
Experience with ETL tools and processes (e.g., SSIS) is a plus
Experience with PowerShell, Pyspark is a plus
Strong analytical and problem-solving skills, with the ability to analyze complex data and business requirements
Meticulous attention to detail and a commitment to data quality and accuracy
Ability to work independently with limited supervision and take ownership of projects
Master's degree in Computer Science or Statistics is required
Nice to have
Experience with ETL tools and processes (e.g., SSIS) is a plus