Qlikview Consultant - Credit Risk - Retail Banking - London - Up to £5

Role: Qlikview consultant

Skills: Qlikview consultant - Credit Risk - Retail Banking - London - Up to £520 per day

Overview:
Our client, a major UK retail bank, requires the services of a Qlikview consultant, who has previous experience with using Qlikview to develop risk reports within Retail Banking. The role purpose is to develop wholesale credit risk reports related to Regulatory Capital calculation and reporting, design and implement best practice for using Qlikview across Group Risk and to build other smaller ad hoc reports required by Risk functions.

Core duties of the role:
The role holder will be responsible for using Qlikview to develop a set of Risk reports and Risk analysis tools from end to end ie from linking several data sources (mainly SAS and excel basis) to deliver final dashboards, presentations, data visualisation tools and MI related to regulatory capital data (RWA inputs incl. PDs, LGDs, EADs, models dataset, customer/industry/geographic views). Main focus of the three month contract would be on wholesale credit risk data.
End product delivered as part of the contract is to be used as a proof of concept to support a broader use of Qlikview across Group risk. To support this wider objective the role holder is also expected to write user guidance material and to ensure best practices are implemented by Qlikview users. Role holder would also be requested to provide training and coaching to staff for them to be able to use Qlikview as part of BAU.
There would be other smaller risk related projects to deliver specific risk dashboards that would be requested as part of the contract. One specific requirement would be to support the transition of the Global Operational Metrics dashboard from project to BAU from a Qlikview perspective, ahead of the departure of the consultants who are building it.
Contract would be initially for a 3 month period but it is the expectation that if senior management buy in is obtained the contract would be extended for a longer period to support the implementation and further embedding of Qlikview across the bank's risk.

Purpose of the role:

Develop wholesale credit risk reports related to Regulatory Capital calculation and reporting (60%)

- Liaise with wholesale credit risk data owners across Business Units (IB, RBB, Africa, Wealth, Risk Centre) to obtain regulatory capital and modelling data. This includes obtaining inputs used for AIRB capital calculation and information related to sector, asset class, geography, business unit, legal entity, etc.
- Obtain list of PD, LGD, EAD models including model status, validation information, MI packs, and information about performance.
- Ensure data obtained is sufficiently granular (facility/counterparty level and single model level) and accurate. Set up and implement work around to improve data quality (this including liaising with risk data owners for improvements to be made in source data submissions)
- Load required data in Qlikview and construct risk reports showing relationship between models and actual capital calculations (eg RWAs by PD, LGD, EAD model)
- Work with Analytics in designing and delivering required risk reports.
- Run reports (standardised and/or ad-hoc) for at least to end of month data points to understand moves in exposure, capital and risk profile.
- Build tools (incl. building and enhancing existing MI) that would help the team to understand key risk drivers across businesses and portfolios for Regulatory Capital, identify trends and support risk management decision making.
- Set up proof of concept presentation and dashboards and present final results to senior management.

Design and implement best practice for using Qlikview across Group Risk (20%)

- Including helping to manage and maintain the team's data analysis tools.
- Writing a guidance on best practice for using Qlickview.
- Train/coach Qlikview users to ensure best practice is applied as BAU

Build other smaller ad hoc reports required by Risk functions (20%)

- One specific requirement under this task would be to support the transition of the Global Operational Metrics dashboard from project to BAU from a Qlikview perspective, ahead of the departure of the consultants who are building it.
- Implement Qlikview related changes/enhancements to the dashboard as required, eg when operational metrics are added/amended or when enhancements to the visualisation of the dashboard are required
- To coach and support regarding the development of their Qlikview skills.

Essential Skills

- Qlikview certified and proficient in using tool for end to end analysis.
- Familiarity with other programming languages (SAS would be preferred)
- Strong data manipulation skills to enable thorough review and analysis of figures and trends.
- Good analytical skills.
- Good stakeholder management skills and ability to build relationships at all levels in the organisation
- General understanding of wholesale banking from a product and asset class perspective.
- Risk and/or Finance experience. Analysis and reporting (Basel II and/or Basel III)

Preferred

- General understanding of the principles behind Regulatory modelling, particularly wholesale credit risk portfolio.
- Previous work experience in banking in a risk or finance function is desirable.
- Relevant experience in risk management or capital management roles

Please note that, due to the high level of applications we receive, we are not able to provide individual responses. If you have not heard from us within 5 working days, please assume that you have not been successful on this occasion.  

Services advertised by Campion Willcocks & Associates Ltd are those of an agency and/or employment business.