Business Analyst – Counterparty Credit Risk, Regulatory Reporting & SQL
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.