Enter a job title or keyword
Business Analyst – Counterparty Credit Risk, Regulatory Reporting & SQL
Job Location:
Monthly Salary:
Experience Required:
Posted:
12 August 2026 (26 days ago)
Posted:
Application Deadline:
9 November 2026
Application Deadline:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Business Analyst Counterparty Credit Risk Regulatory Reporting & SQL
Toronto ON - Hybrid (4 Days WFO)
Role Descriptions: What is the opportunity
The business analyst (BA)s responsibilities will include:
Understanding the counterparty credit exposure measurement for various products.
Mapping source data to internal monitoring reporting e.g. Counterparty concentration Report; external regulatory reporting i.e. Large Exposure Frame (LEF) and Single Counterparty Credit Limit (SCCL).
Supporting production related items.
Primarily the BA will:
Create mapping logic for counterparty credit exposure reporting or create requirement document and liaise with IT developers to communicate those requirements.
Plan/coordinate all user testing coordinate implementation/migration as necessary and communicate (written and verbally) to project leadership team and or senior management on project status throughout the project lifecycle.
What will you do
Understanding various product attributes from upstream e.g. Lending product Facility Security Security Finance Transaction(SFT) and Derivative etc.
Picking up new concept and applying it quickly e.g. LEF Risk Shifting for Credit Default Swap (CDS) SFT Derivative Guarantees and LC Fronting etc.
Performing data gap analysis systems processes and procedures as required for the project.
Create reporting mapping logic or requirement document.
Communicating requirement to development and QA performing testing coordinating UAT testing and assisting production implementation.
Contributing to the process re-engineering and process improvement where applicable.
Supporting users training and documentation as needed.
Report the BA team working status and raise concerns or issues that may hinder the project progress as planned to management and PMs.
What do you need to succeed
Must-have
Experience in systems implementation process improvements or systems re-engineering projects with a banking organization or consulting company.
Undergraduate degree or higher preferable in Mathematics Computer Science Engineering or Finance.
Knowledge of SDLC lifecycle Agile others.
Experience in SQL through HIVE MS SQL server Teradata HUE Dremio etc.
Advance MSWord MS Project MS PowerPoint and MS Excel Visio MS Access.
Nice-to-have
Understanding of Credit Risk reporting.
Experience in data sourcing and mappings to cover major Capital Market and Retail financial instruments for both on and off balance sheet.
Tableau.
Required Skills:
Sailpoint
