Mi & Reporting Data Analyst

Datonomy Solutions; Gauteng; On-site; ZAR 550 000 - 750 000; Full time

Job summary

A leading analytics firm in South Africa is seeking a MI & Reporting Analyst to produce high-quality management information and support performance improvement initiatives. The ideal candidate will have strong SQL skills and experience with BI tools. You will be responsible for designing and delivering performance reports, building dashboards, and ensuring data quality. This role is based in Sandton and offers a collaborative work environment focused on data-driven decision-making.

Qualifications

• Strong SQL skills across multiple database platforms.
• Experience with automated dashboards and MI reports.
• Ability to collaborate with technology and data engineering teams.

Responsibilities

• Produce daily/weekly/monthly reporting packs for collections.
• Develop automated dashboards using Debt Manager data.
• Ensure regulatory compliance with NCR and POPIA standards.

Skills

Strong SQL skills

Experience with Camunda BPM

Proficiency with BI tools like Power BI

Scripting languages for MI automation

Understanding of COBOL copybooks

ETL tools and data modeling

Tools

Debt Manager

Teradata

Oracle

Sybase

DB2

Postgres

Job description

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