Data Analyst/ Developer – Credit Risk recruitment
Department Overview
The Finance and Credit Risk team is responsible for the credit risk management of the global lending portfolio. Lending activity, together with the provision of financial trading facilities to clients, is a key platform behind the strategic growth objectives of the business
Purpose of role
The role requires an experienced data analyst (not a business analyst) with a developer skillset to join the Credit Risk Data Services team. The role holder is responsible for a range of business as usual data generation requests that provide the basis for regular management information reporting (note the reporting is undertaken by a separate team), reviewing the quality, accuracy and consistency of this data, challenging data inconsistencies and ensuring data is fit for purpose and in compliance with Group Risk Data Quality policy. In addition to business as usual data generation, the role holder will be required to contribute to various change initiatives, including the identification and production of data for risk management purposes (e.g. refer lists, deteriorating trend data, collateral concentration data) and also for maintenance of a defined and documented data governance structure. Specifically, the role holder will be required to:
- Produce, review and deliver high quality global credit risk data to the Analytics team meeting tight delivery times.
- Provide support to different business areas using data mining techniques.
- Maintain and enhance the Credit Risk Data Mart, including detailed documented procedures for its operation
- Provide support to initiatives to improve the quality of data available to Credit Risk.
Role requirements
Professional/technical experience
Required
- Significant data analysis experience
- Significant data mining experience
- Significant relational database experience, including Teradata and Oracle
- Developer skill set. Good Knowledge of SQL in a development environment
- Minimum Intermediate level SAS programming
- Minimum Intermediate level VBA programming
Preferred
- MS Access experience
- Batch processing and UNIX scripting
- MS Excel and MS SharePoint skills
- Logical and physical data modelling, identification of entities, their attributes and relationships
- Previous Banking experience
- Banking experience within a Credit Risk business unit
- Good understanding of different credit products
Core accountabilities
- Ensure that regular monthly credit risk data is delivered timely and accurately
- Development of Credit Risk Data Mart
- Process ad hoc data queries from credit risk and other parts of the bank
- Identify and understand data sources and reconcile them
- Identify and liaise with other data teams within the business to maximise own knowledge and knowledge sharing
- Provide support to other credit risk areas through data submission
- Database management and data intelligence applied to deliver facts for decision making processes
- Dynamic thinking and management of large volumes of data
- Manage expectation realistically to ensure all deliverables are met
- Always raise concerns to the right people and become an active contributor to the solutions
- Provide support through proactive thinking of alternatives