itjobs.ca Logo

About the role

About the Company As the founding entity of RAINBOW PARTNERS, Quanteam is a consulting firm specializing in Banking, Finance, and Financial Services. Guided by our core values of closeness, teamwork, diversity, and excellence, our team of 1,000 expert consultants, representing 35 different nationalities, collaborates across 10 international offices: Paris, Lyon, New York, Montreal, London, Brussels, Geneva, Lisbon, Porto and Casablanca.

We are looking for a Credit Risk Reporting — Database Developer / Integrator to join one of our clients, a major corporate investment bank, within the Finance & Risk Systems (F&RS) Risk IT team. The role is part of a strategic initiative to replace an existing RWA calculation and reporting tool (Moody’s) with a new in-house solution

. Position Overvi ewThe Database Developer / Integrator is a hands-on technical role embedded within the F&RS Risk IT team. The resource will contribute to the design, development, and delivery of a new in-house RWA (Risk-Weighted Asset) calculation and reporting platform, as part of a study and replacement initiative targeting the existing Moody’s tooling. The role covers the full data lifecycle — from connecting to upstream banking data sources to building calculation engines, regulatory report mappings, and management dashboards — with a strong emphasis on Oracle database development and PL/SQL expertise. The resource must be capable of working autonomously and delivering independently within the Risk IT tea

m. Key Responsibilit iesRequirements Translation & Data Integrat ionCollaborate with Business Analysts to transform business rules and regulatory requirements into precise technical specificati onsConnect to multiple banking data sources (Oracle DB, external feeds, CSV files) and design the required data pipeli nesImplement integration logic to map granular source data to MDRMs (Minimum Data Reporting Metrics — regulatory report line ite ms)Database Design & Administrat ionCreate and optimize Oracle schemas, tables, indexes, and materialized/canned vi ewsManage database users, roles, and security in line with internal governance standa rdsPerform performance profiling and tuning of SQL and PL/SQL code, implementing indexing and partitioning strategies to meet latency targ etsRecommend hardware or cloud resource adjustments to support performance requireme ntsPL/SQL Development & Calculation Eng ineWrite stored procedures, functions, and packages to perform data extraction, transformation, and RWA calculati onsBuild credit risk calculation logic (RWA — Risk-Weighted Assets) ensuring full traceability to regulatory formulas (Basel framework) and internal paramet ersDesign and implement cursors and SQL stored procedures as part of the core calculation proc essReporting & Dashboa rdsBuild canned regulatory reports and management dashboards using BI and data discovery to olsImplement MDRM mapping logic to align granular data with regulatory reporting line it emsContribute to front-end UI design and build as needed (Java, Angular, Oracle APEX, or equivale nt)Testing, Documentation & Knowledge Trans ferDesign and execute unit test suites; perform back-testing against existing RWA reports and document all discrepanc iesProduce technical design documents, data dictionaries, and user gui desConduct handover sessions and knowledge transfer to internal team memb

ers Qualifications & Technical Sk illsRequired Sk illsExpert-level Oracle database design: schemas, tables, indexes, views, partitioning, and performance tu ningStrong PL/SQL and SQL proficiency, including stored procedures, functions, packages, and cur sorsExpert-level application and data integration, including multi-source data pipel inesSolid experience with ETL tools and ETL best pract icesStrong version control skills, particularly GitHub or equiva lentStrong written and verbal English communication sk illsAbility to work autonomously and deliver independently within a technical teamNice-to-Have Sk illsWritten and verbal communication skills in Fr enchFamiliarity with the banking sector, particularly Risk and Finance dom ainsKnowledge of Basel regulation pillars (credit risk, market risk, RWA calculati ons)UI development experience: Java, Angular, Oracle APEX, or equiva lentFamiliarity with Python for data processing or performance tuning t asksBehavioral Competen ciesAutonomy — Comfortable taking ownership of technical deliverables end-to-end with minimal supervi sionRigour — Applies high standards to database design, code quality, and documenta tionAnalytical Mindset — Able to translate complex regulatory rules into robust technical implementat ionsCollaborative — Works effectively with Business Analysts, Risk stakeholders, and other develo persClear Communication — Able to document and explain technical decisions to both technical and non-technical audie ncesPreferred Certificat ionsOracle Database SQL / PL/SQL Certified Professional or equiva lentAny relevant data engineering or ETL certification is a

plus Exper ience5+ years of hands-on Oracle database development experience in a production environment, with strong PL/SQL expe rtiseDemonstrated experience delivering data integration and ETL pipelines connecting heterogeneous banking data so urcesPrior experience building calculation engines or processing pipelines in a financial or regulated enviro nmentExposure to risk or finance reporting systems (RWA, Basel regulatory reporting, or equivalent) is a strong assetExperience working within Agile or iterative delivery teams in a financial instit utionPrior work on tool replacement or greenfield platform build projects in a banking context is highly v

alued

About QUANTEAM - North America (RAINBOW PARTNERS Group)

IT Services and IT Consulting