Senior Credit Data Analyst

Be among the first applicants.

DBSA

Midrand

ZAR 300 000 - 400 000

Be among the first applicants.

7 days ago

Job description

Job Description

To source, aggregate and collate credit and other data for credit modelling, reporting and analysis. The key
accountabilities, interfaces and measures of this role are elaborated below:

Key Responsibilities

1. Sourcing of Data

Mine Data from Data Warehouses / Data Lakes within the institution.
Acquire Data from public sources, other financial institutions, and service providers.
Extract Data from the operating Systems of the Bank (e.g. SAP).

2. Credit Lab Data Warehouse

Aggregate and organise Data from sources into usable formats for storage and usage in the development of Credit Risk models and Credit portfolio reporting.
Build a library of monthly snapshots of the relevant data sources.
Integrate the Data Warehouse with Credit Risk Model systems.

3. Credit Portfolio Reporting

Design, construct and maintain templates providing numeric and graphical output for credit portfolio reporting.
Provide accurate and timely updates of completed templates for divisional and consolidated portfolio reporting.
Provide data and numeric support to credit report composers to accurately complete portfolio reports.
Ensure the accuracy of credit measures and representations in credit portfolio reports.
Maintain checklists for the governance of credit portfolio report content.

4. Credit Risk Pricing

Provide support to the Credit Lab Manager for Credit Risk margin pricing and inputs to the Pricing Working Committee.
Source and confirm Risk inputs to the Pricing Model from Credit Risk Model systems. Ensure the accuracy of inputs to the pricing model.

5. Country Risk

Source country and Sovereign Risk ratings from independent service providers.
Maintain relationships with service providers.
Confirm country Risk inputs to the Pricing Model.
Calculate and maintain country Risk limits as per country Risk policy.
Maintain Country and Sovereign risk Policy for approval by the Board.

6. Ad-Hoc Reporting

Source, aggregate and analyse data for ad-hoc reporting requests.
Ensure the accuracy of ad-hoc reporting analysis and findings.

7. Key Measures

Performance against agreed targets.
Performance outputs as per the performance management system.
Quality and accuracy data.
Timely provision of data and analyses.
Management of relationships with key stakeholders.
Reporting effectiveness and efficiency measures.

Key Internal Liaison Relationships

1. Credit Lab Manager
2. Credit Systems Technician
3. Credit Model Technicians
4. Credit Risk Analysts
5. Contracts and Administrations Department
6. Investment Officers
7. Portfolio Management Officers

Key External Liaison Relationships

1. Service Providers
2. Other DFI’s
3. Other Financiers
4. DBSA stakeholders (as required)
5. Credit Risk Committees
6. Rating Agencies

Expertise & Technical Competencies

Minimum Requirements

BCom Computer Science, BSc Actuarial Science / Data Science or similar.
A minimum of 6-8 years’ experience in Credit Data Management in Financial services.
Experience within an Analytical team / Credit Lab.
Experience as the team lead for the provision of Data.
Experience in a Banking and/or financial sectors.
Experience in the development of Policies, Credit Models (PD, LGD, EAD and Scorecards)
Good knowledge of Data Management Systems (DBMS, RDMS), Analytical Tools like but not limited to Power BI, SAS, SSAS.
Experience in designing and drafting detailed Reports and Templates.

Desired Requirements

Experience in a Development Finance environment will be a distinct advantage.
Experience in Python and Microsoft R will be an advantage.
Experience in Microsoft SQL Server tools will be an advantage.

TECHNICAL
a) Problem Solving

Identifies complex problems based on a broad range of factors, many of which are ambiguous or difficult to define.
While remaining guided by organisational values, identifies optimal solutions, thinking first in terms of possible approaches and flexibilities in the system vs. blind adherence to rules or procedures.
Implements solutions to complex problems, then evaluates the effectiveness and efficiency of solutions and identifies needed changes.

b) Planning and Organising

Is relied on to helps other plan and organise their workload.
Uses effectively advance time management processes to deal with high workload and tight deadlines.
Organises, prioritises and schedules tasks so they can be performed within budget and with the efficient use of time and resources.
Achieves goals in a timely manner, despite obstacles encountered, by organising, reprioritising and re-planning.

c) Data Collection and Analysis

Skilled in the use of advanced/complex analytical techniques.
Ability to use judgement to decide upon the most appropriate analytical techniques according to the situation.
Recognises underlying principles, patterns, or themes in an array of related information, and determine whether additional information would be useful or necessary.
Through an in-depth understanding of the business environment, reviews outputs of analysis to identify anomalies and draws conclusions, relating these to operational circumstances.
Can model a range of scenarios covering all potential business circumstances and highlight potential risks/opportunities.

d) Reporting & Communication

Designs / customizes reports to meet user needs.
Prepares complex or tailored reports, gathers information from a variety of sources, analyses and includes in a report.
Keeps standard reports under review and proposes improvements to meet user needs.

e) Analytical Ability

Ability to propose solutions to support investment through analysis and solutioning.
Thorough and in-depth understanding of the business environment, reviews outputs of analysis to identify anomalies and draw conclusions, and able to relate these to operational circumstances.
High level of skill in the use of advanced/complex analytical techniques and able to use judgement to decide upon the most appropriate analytical techniques to solution according to the situation.
Proven ability to apply relevant estimating techniques, tools and models covering all potential business circumstances (such as cost benefit analysis) and highlight potential risks/opportunities.
Able to translate findings into reports and present findings to key stakeholders.

Required Personal Attributes

BEHAVIOURAL
1. Customer Service Orientation

Tries to understand the underlying needs of customers and matches these needs to available or customized products and services.
Adapts processes and procedures to meet on-going customer needs.
Utilises the feedback received by customers, in order to develop new and/or improve existing services/ products that relate to their on-going needs.
Thinks of new ways to align DBSA’s offerings with future customer needs.

2. Self-awareness and Self Control

Withholds effects of strong emotions in difficult situations.
Keeps functioning or responds constructively despite stress.
May apply special techniques or plan ahead of time to manage emotions or stress.

3. Strategic and Innovative Thinking

Experiments with new approaches, tests scenarios, questions assumptions and challenges conventional thinking.
Creates new concepts that are not obvious to others, leveraging internal and external sources of information, to build incremental revenue and growth opportunities.

4. Driving delivery of results

Sets challenging goals that will have a significant impact on the business or support the organisational strategy.
Commits significant resources and/or time to ensure that challenging goals are achieved, while also taking action.

5. Teamwork & Cooperation

Acts to promote a friendly climate and good morale, and resolves conflicts.
Creates opportunities for cross-functional working.
Encourages others to network outside of their own team/department and learn from their experience.