Business Analyst – Counterparty Credit Risk, Regulatory Reporting & SQL

Toronto, ON - Hybrid (4 Days WFO)

Role Descriptions: What is the chance?

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.

📌 Business Analyst – Counterparty Credit Risk, Regulatory Reporting & SQL (Toronto)
🏢 Astra North Infoteck
📍 Toronto