Job Description
We are seeking a skilled and detail-oriented Business Analyst with a strong banking background, particularly in risk management and banking products such as loans, deposits, credit cards, credit risks, and market risks. The ideal candidate will possess robust SQL and analytical skills, enabling them to write queries, extract large data sets, and perform comprehensive data analysis. This role involves supporting a Risk Data Mart, ensuring data integrity, and contributing to both daily operations and strategic projects.
Key Responsibilities:
Daily Operations & Data Integrity:
Perform daily and month-end checks on risk data within the Risk Data Mart.
Conduct daily reconciliation and completeness checks, identifying and following up on reconciliation breaks.
Update and maintain reconciliation reports and documents.
Data Analysis & SQL Querying:
Write SQL queries to extract and analyse large data sets, ensuring data accuracy and relevance
Analyse and interpret data to support Basel III LCR reporting, Basel Credit Risk management reporting, and other related risk management activities.
Project Support:
Support upstream projects affecting the Risk Data Mart and downstream reporting queries and enhancements.
Perform impact assessments and User Acceptance Testing (UAT) on both upstream and downstream changes.
Assist in the configuration changes related to Risk Mart projects.
User Support & Documentation:
Respond to end-user queries related to Risk Mart and provide timely support.
Write simple user specifications and assist in documenting requirements and processes.
Collaborate with the Risk Mart BAU lead to resolve daily and month-end reconciliation issues.
Testing & UAT:
Write and execute test cases for large volumes of data, ensuring comprehensive coverage and accuracy.
Independently raise and resolve UAT issues, documenting the outcomes and lessons learned.
Required Skills & Qualifications:
Banking Knowledge:
Strong understanding of banking products (e.g., loans, deposits, credit cards) and familiarity with credit risks, market risks, and overall risk management in a banking environment.
SQL Proficiency:
Demonstrated ability to write complex SQL queries and perform data extraction, manipulation, and analysis.
Analytical Skills:
Strong analytical mindset with experience in interpreting and analysing large data sets.
Risk Management:
Background in risk analysis, preferably within a banking context, with experience in Basel III LCR and Credit Risk reporting.
User Testing:
Ability to conduct user testing, write test cases, and handle testing for large data volumes.
Communication:
Strong written and verbal communication skills, with the ability to write clear user specifications and documentation.
BAU Support:
Experience in providing Business as Usual (BAU) support, particularly for data mart environments.
Preferred Qualifications:
Experience in supporting Risk Data Marts or similar data-intensive environments.
Prior experience with Basel III LCR reporting or Credit Risk management reporting.