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.

#J-18808-Ljbffr

📌 Business Analyst – Counterparty Credit Risk, Regulatory Reporting & SQL (Ontario)
🏢 Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
📍 Ontario