MI & Reporting Data Analyst at Datonomy Solutions
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.
Responsibilities
- Designing, delivering, and maintaining daily/weekly/monthly performance and operational reports.
- Managing KPI packs for senior leadership, ensuring accurate and 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.
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, PostgreSQL).
- 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.
Data Integration & Engineering Support
- Extract, transform, and load data from Debt Manager, Teradata, Oracle, Sybase, DB2, PostgreSQL, 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.
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.
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.
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.
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.
Core MI & Data Skills
- Strong SQL skills across multiple database platforms (PostgreSQL, 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.
- 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.
Qualifications & Experience
- Degree in Data Analytics, Information Systems, Computer Science, Statistics, or related field.
- 4–7+ years’ experience in banking MI or data analysis.
- Collections & Recoveries experience required.
- Experience with enterprise databases (Teradata/Oracle/DB2/Sybase/PostgreSQL).
- Preferred: Debt Manager experience.
- Exposure to Camunda and modern front‑end frameworks (Angular/React) beneficial.
Desired Skills