Data Analyst - Recons and Control

Nedbank

Johannesburg

On-site

ZAR 450,000 - 650,000

Full time

8 days ago

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Benefits offered by this job

Nedbank employee benefits

Job summary

Nedbank is seeking a Data Analyst - Recons and Control to develop automated data extraction and reconciliation processes, mitigate operational risks, and support reconciliation-related audits. The role requires strong SQL, data analysis, and stakeholder engagement skills in Nedbank's Loyalty, Rewards and Partnership area.

The analyst will transform manual reconciliations into automated controls across IT and business units.

Qualifications

3–5 years of SQL script writing experience.
1–3 years AWS experience would be advantageous.
System analysis background would be an advantage.
Ability to reconcile large data sets accurately.
Identify trends, anomalies and control weaknesses from data.
Root-cause analysis capability based on data.
Strong problem-solving skills.
SQL or scripting experience (SQL, Python).
Advanced Excel, Pivot Tables, XLOOKUP/VLOOKUP.
Data extraction and manipulation; reconciliation and exception reporting.
Understanding of databases and data structures.

Responsibilities

Create and maintain scripts to extract data from various sources.
Perform reconciliations between reports, systems and data sets.
Compare multiple reports and identify mismatches.
Notice patterns and anomalies quickly.
Produce exception and management reporting.
Maintain high levels of accuracy.
Investigate reconciliation breaks and conduct root-cause analysis.
Escalate risks before they become incidents.
Develop interim and permanent data-driven controls to mitigate operational risk.
Recommend permanent matching keys and system enhancements.
Identify opportunities for automation and process improvement.
Manage and coordinate annual internal audit requirements relating to reconciliations and controls.
Maintain audit evidence, control documentation, and reconciliation sign-offs.
Work with operational teams, IT and business units to resolve incidents.
Document risks and controls effectively.
Test and verify for QA environment; standby on technical deployments.
Manage production issues and logging of incidents.
Investigation and validation of data; approvals.
Conduct problem solving and detailed root cause analysis.
Seek opportunities to improve business processes and systems for Nedbank.

Skills

SQL Script writing

AWS experience

Data analysis

Excel (Advanced)

Pivot Tables

XLOOKUP / VLOOKUP

Data extraction

Reconciliation

Exception reporting

Python

Problem solving

Stakeholder management

Agile environment

Education

Matric/Grade 12/National Senior Certificate

Advanced Diploma/National 1st Degree

Related qualifications e.g. BCom/BA/BSc

Tools

CRM system

SQL

Excel

Job description

Title:Data Analyst - Recons and Control

Title: Data Analyst - Recons and Control
Requisition: 147516
Department: Loyalty, Rewards and Partnership
Division: Product Design and Innovation)
Closing Date: 08 September 2026
Recruiter: William Mtsweni

Job Family

Information Technology

IT Technical / Specialist

Job Purpose

Our Loyalty and Rewards Business Team is looking a Reconciliations and Risk Analyst to develop automated data extraction and reconciliation processes, proactively identify and mitigate operational risks through data-driven controls, and manage reconciliation-related audit activities. Our ideal candidate should have previous experience in configuration as well as a strong working knowledge in Structured Query Language (SQL) & Customer Relationship Management system (CRM). The successful candidate will possess strong technical, analytical, risk management, and stakeholder engagement skills, with the ability to transform manual reconciliation processes into automated control environments.

Job Responsibilities

Strong Attention to Detail

Create and maintain scripts to extract data from various sources.
Perform reconciliations between reports, systems, and data sets.
Able to compare multiple reports and identify mismatches.
Notices patterns and anomalies quickly.
Produce exception and management reporting
Maintains high levels of accuracy.

Analytical Thinking

Understands data relationships rather than simply matching figures.
Investigate reconciliation breaks and conduct root-cause analysis.
Uses logical reasoning to determine why reports do not align.
Thinks proactively about potential failures and control weaknesses.
Escalates risks before they become incidents.

Process Improvement Orientation

Develop interim and permanent data-driven controls to proactively mitigate operational risk.
Can recommend permanent matching keys and system enhancements
Identify opportunities for automation and process improvement.

Data Competency

Experience with reconciliations and exception reporting.
Ability to work with large data sets.

Stakeholder Management

Manage and coordinate annual internal audit requirements relating to reconciliations and controls.
Maintain audit evidence, control documentation, and reconciliation sign-offs.
Works with operational teams, IT, and business units to resolve incidents.
Can document risks and controls effectively.
Test and verify for QA environment
Standby on technical deployments
Manage Production Issues
Logging of incidents
Investigation analysis, validation, verification of data and approvals.
Conduct Problem solving and detailed root cause analysis
Seek opportunities to improve business processes and systems by identifying and recommending effective ways to operate and adding value to Nedbank.
Experience in Agile environments
Deliver work products according to the agreed timelines
Communicate new features to stakeholders through forums
Participate in research that will enable recommendations related to system software.

Essential Qualifications - NQF Level

Matric / Grade 12 / National Senior Certificate
Advanced Diplomas/National 1st Degrees

Preferred Qualification

Any of the following qualifications: BCom Information Systems, BSc Computer Science, BSc Data Science/Analytics, BCom Business Analytics, BCom Accounting / Finance or Any related qualification

Minimum Experience Level