- Someone who has banking background and knowledge in banking products (eg. loans, deposits, credit cards, credit risks, market risks etc.
- 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
- Someone who has risk background (bank) would be advantage
- Able to do user testing, write test cases and do testing for large volume of data
- Daily reconciliation / completeness checks and highlighting and following up on reconciliation break
- Apart from daily BAU, support to upstream projects which impacts data mart and support to downstream reporting queries and enhancements will be required.
- Perform daily and month end checks on data in Risk Data Mart including updates of reconciliation reports.
- Followup and resolve reconciliation breaks.
- Perform impact assessment and UAT on both upstream projects and downstream enhancement changes.
- Support end users queries of Risk Mart and Risk Mart projects related configuration changes.
- Write simple users specifications for Risk Mart.
- Work with Risk Mart BAU lead to perform and resolve daily and month end reconciliation checks and issues. Update reconciliation documents.
- Perform UAT and documentation, raise and resolve UAT issues independently.
- Provide support to end users queries and Risk Mart related projects configuration changes
- Assist in Risk Mart specifications write-up
- 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.