Business Analyst (Good in using SQL and have analytic skills)

Summary of the Requirements

1. Someone who has banking background and knowledge in banking products (eg. loans, deposits, credit cards, credit risks, market risks etc.)
2. Business Analyst from business background and not so much from technology background
3. Good in using SQL and have analytic skills - need to write SQL queries to pull out big data and to understand (analyse) the data which are pulled out – is a must
4. Someone who has risk background (bank) would be advantage
5. Able to do user testing, write test cases and do testing for large volume of data

More details of the Requirements

Role is a BA for data mart, able to perform BAU support for a risk data mart that is providing data to Basel III LCR reporting, Basel Credit Risk management reporting, Credit Risk management reporting.

Primary role is performed daily and month end checks on the risk data with the focus on:

1. Daily reconciliation / completeness checks and highlighting and following up on reconciliation break
2. Apart from daily BAU, support to upstream projects which impacts data mart and support to downstream reporting queries and enhancements will be required.

In some instances, Risk Analyst may be required to write simple users specifications.

1. Perform daily and month end checks on data in Risk Data Mart including updates of reconciliation reports.
2. Followup and resolve reconciliation breaks.
3. Perform impact assessment and UAT on both upstream projects and downstream enhancement changes.
4. Support end users queries of Risk Mart and Risk Mart projects related configuration changes.
5. Write simple users specifications for Risk Mart.
6. Work with Risk Mart BAU lead to perform and resolve daily and month end reconciliation checks and issues. Update reconciliation documents.
7. Perform UAT and documentation, raise and resolve UAT issues independently.
8. Provide support to end users queries and Risk Mart related projects configuration changes
9. Assist in Risk Mart specifications write-up

A MUST skills :-

1. Conduct extensively data analysis and testing, hence both Banking and SQL experiences are required. Good in using SQL and have analytic skills - need to write SQL queries to pull out big data and to understand (analyse) the data which are pulled out.
2. Someone who has banking background and have some knowledge in bank’s products