Business Analyst – Counterparty Credit Risk, Regulatory Reporting & SQL

Business Analyst – Counter party Credit Risk, Regulatory Reporting & SQL

Toronto, ON - Hybrid (4 Days WFO)

The business analyst (BA) s responsibilities will include:

• Understanding the counter party credit exposure measurement for various products.
• Mapping source data to internal monitoring reporting, e.g. Counter party concentration Report; external regulatory reporting i.e. Large Exposure Frame (LEF) and Single Counter party Credit Limit (SCCL).
• Supporting production related items.

• Create mapping logic for counter party 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.

• 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.

• 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.

• 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.