MI & Reporting Data Analyst

We are seeking a MI & Reporting Analyst to join our team based in Sandton, Onsite.

The MI Data & Reporting Analyst will play a key role in producing high-quality management information to support performance, operational decision-making, and strategic improvement within the Collections & Recoveries environment.

The role is responsible for:

Designing, delivering, and maintaining daily/weekly/monthly performance and operational reports.

Managing KPI packs for senior leadership with accurate, timely MI covering performance against key metrics.

Building interactive dashboards, modelling workflow performance, and integrating multiple data sources to support business strategies.

Supporting workflow, automation, and data flow initiatives using tools such as Camunda, front-end frameworks (Angular/React), and enterprise databases.

2. Key Responsibilities

2.1 MI Reporting & Data Analytics

Develop automated dashboards and MI reports using data from Debt Manager (C&R Software) and enterprise databases (Teradata, Oracle, Sybase, DB2, Postgres).

Produce daily/weekly/monthly reporting packs covering Collections performance metrics (roll rates, cures, rehabilitations, agent performance, recoveries).

Perform advanced analysis using SQL, SAS, and scripting languages to identify trends and insights.

Conduct root-cause analysis on variances, strategy performance, delinquency movements, and portfolio ageing.

2.2 Data Integration & Engineering Support

Extract, transform, and load data from:

Debt Manager

Teradata, Oracle, Sybase, DB2, Postgres

COBOL copybooks and mainframe file structures

Work with structured, semi-structured, and flat-file data, including file transfers (SFTP) and internal batch processes.

Collaborate with Technology and Data Engineering teams to ensure data quality, integrity, and efficient data pipelines.

2.3 Workflow, Automation & Process Modelling

Interpret and model Collections workflows using Camunda BPM, including BPMN diagrams and decision models.

Analyse workflow automation rules and propose optimisation opportunities.

Support integration between Collections systems, workflow engines, and the reporting/MI layer.

2.4 Application Support & Front-End Visualisation

Partner with Angular/React development teams to embed MI components into front-end applications.

Provide analysis enabling data-driven UI workflow components for operational teams.

Work with REST APIs and JSON data structures for dashboarding and data consumption.

2.5 Strategic Support & Performance Insights

Deliver insights to support segmentation, treatment paths, dialler strategies, payment arrangements, and recovery initiatives.

Support champion/challenger tests and A/B experiments to evaluate strategy effectiveness.

Engage senior stakeholders to interpret performance trends and recommend strategic improvements.

2.6 Governance, Compliance & Quality Assurance

Ensure regulatory compliance with NCR, POPIA, Basel standards, and internal risk frameworks.

Maintain thorough documentation of data flows, dependencies, and MI logic.

Assist Risk, Finance, and Audit teams with data queries and compliance reporting.

3. Required Technical Skills

Core MI & Data

Strong SQL skills across multiple database platforms (Postgres, Teradata, Oracle, Sybase, DB2).

Advantageous: understanding of COBOL copybooks, mainframe data formats, and batch/SFTP file ingestion.

Collections & Recoveries Systems

Preferred: experience with Debt Manager (C&R Software), including data structures, extracts, workflows.

Exposure to dialler data, payment arrangements, DCA processes, write-off and recovery flows.

Workflow & Automation

Experience with Camunda BPM, BPMN modelling, and automation rule interpretation.

Programming & Scripting

Java (helpful for API integration or backend logic understanding).

Scripting languages for MI automation (Python beneficial).

SAS for statistical analysis or model execution.

Front-End Visualisation

Experience (or collaborative understanding) of Angular/React for embedding MI.

Proficiency with BI tools such as Power BI, Tableau, or QlikView.

General Technology

ETL tools, data modelling, and pipeline management.

REST/JSON API consumption and integration.

4. Business & Analytical Skills

Strong knowledge of the Collections