About the position
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 & Recoveries lifecycle.
- Understanding of key C&R metrics (roll/cure rates, vintage analysis, NPL movements, ageing).
- Ability to translate complex analytical findings for non-technical stakeholders.
- Strong problem-solving, critical thinking, and prioritisation skills.
5. Qualifications & Experience
Qualifications
- Degree in Data Analytics, Information Systems, Computer Science, Statistics, or related field.
Experience
- 4–7+ years’ experience in banking MI or data analysis.
- Collections & Recoveries experience required.
- Experience with enterprise databases (Teradata/Oracle/DB2/Sybase/Postgres).
- Preferred: Debt Manager experience.
- Exposure to Camunda and modern front-end frameworks (Angular/React) beneficial.
6. Key Performance Indicators
- Accuracy and timeliness of MI outputs.
- Improvements in workflow automation reporting.
- Delivery of automated dashboards and MI enhancements.
- Quality and relevance of strategic insights delivered.
- Stakeholder satisfaction and adoption of MI solutions.
7. Additional Preferred Experience
- Working with cloud data platforms (AWS, Azure, GCP).
- Regulatory reporting knowledge (Basel, IFRS9).
- Understanding of dialler platforms (Avaya, Genesys).
- Experience with SAS for advanced analytics.
Desired Skills:
