MI & Reporting Data Analyst

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

POSITION INFO:

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