Collections Analyst

Sanlam -
Johannesburg, Gauteng

Apply Now

Job Details

Permanent
2 days ago

Full Job Description

Who are we?

Sanlam Developing Markets [SDM] (a wholly-owned subsidiary of Sanlam Life Limited) is one of the top financial services providers in the South African entry-level and emerging middle market. It aims to understand the unique requirements of clients and offers a wide range of simple and affordable financial solutions that cover needs such as funeral insurance, savings for education, life cover and personal accident plans. In terms of the Sanlam Group Governance Policy, SDM is managed by the SA Retail Mass cluster, which is part of the Sanlam Life and Savings cluster within the Sanlam Group. The cluster focusses on retail products, as well as group schemes.

Location responsibility: The position is based in Gauteng and will support activities at the Menlyn and Houghton office.

Purpose of role

We are looking for an individual with strong analytical capability and experience in using a variety of data tools and analysis methods to produce meaningful management information, reporting and insights for Premium Administration.

The successful candidate will support Premium Administration by analysing collection performance, payment outcomes, premium movements, and operational exceptions across debit order, DebiCheck and stop order collection channels. The role will work closely with business stakeholders to understand operational processes, define reporting and analytical requirements, investigate trends and exceptions, and deliver insights that support improved collection outcomes, stronger controls and better decision-making.

What will you do?

Data Preparation

Acquire data from various data sources and combine & transform data into interpretable datasets, reports or dashboards
Assess the effectiveness and accuracy of new data sources and data gathering techniques
Extend the company’s data with third party sources of information when required
Process, cleanse and verify the integrity of data used for analysis
Perform data profiling of data contained in source systems
Provide detailed analysis of all data implemented into the database
Provide the data mapping and associated transformation rules for each data item
Ensure that the business requirements and subsequent development activities are supported by accurate information.
Extract, cleanse and prepare data related to premium collections, payment outcomes, mandates, unpaid transactions and operational exceptions
Validate and reconcile data across source systems, reporting datasets and collection outputs to support accurate operational reporting

Analysis and Visualisation

Interpret data, analyse results using analytical techniques and provide reports and/or dashboards
Identify, analyse, and interpret trends or patterns in complex data sets
Use data to answer key questions about the business.
Support and maintain the project data models at multiple levels of detail and functionality (conceptual, logical, normalised, relational, dimensional, application level, subject-level, integrated, etc.)
Assist Data Modelers to draw up detailed data models.
Documenting processes
Analyse debit order, DebiCheck and stop order collection performance and identify trends, risks and opportunities
Produce dashboards and reports on collection success rates, unpaid reasons, mandate status, premium movement and lapse-related indicators
Perform root-cause analysis on collection failures, repeated unpaid premiums and operational exceptions
Identify data-driven opportunities to improve collection performance, reconciliation accuracy and operational efficiency

Stakeholder Engagement

Work directly with management and other business users to gather requirements, provide status updates, and build relationships
Present information using data visualisation techniques
Facilitate requirements gathering workshops with the business
Collaborate with internal and external stakeholders to analyse information needs, functional requirements and business processes
Engage with role-players within Retail Mass cluster
Coaching/Mentorship
Provides problem solving assistance to other team members
Work closely with Premium Administration, Finance, IT and other stakeholders to translate collection-related business problems into analytical and reporting solutions

Qualification and Experience

Diploma/Bachelor degree (Informatics/Computer science/engineering) or equivalent
Functional experience in analytics, data visualisation or reporting
4–5 years’ experience in data analytics
Strong experience with SSRS, SSAS, Power BI and SQL Server Management Studio (T-SQL)
Experience in financial services, insurance, premium administration or collections environments will be advantageous
Strong understanding of debit order, DebiCheck and stop order collection processes
Experience analysing premium collection data, payment outcomes, unpaid trends and operational exceptions
Understanding of reconciliation processes, payment return reasons, mandate-related data and operational control environments

Strong analytical-thinking and problem-solving abilities
Excellent written and verbal communication skills
Experience working with data in various data sources and databases
Strong analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy
Demonstrated experience in handling large data sets and relational databases.
Experience working in an agile environment
Excellent attention to detail

Knowledge and Skills

Ability to translate business requirements into non-technical terms
Ability to work within strict data governance and control frameworks
Experience with data profiling, data quality and reference data tools will be advantageous
Strong analytical-thinking and problem-solving skills
Ability to collect, organize, analyse, and disseminate significant amounts of information
Attention to detail and accuracy

Personal Attributes

Interpersonal savvy - Contributing independently

Decision quality - Contributing independently

Plans and aligns - Contributing independently

Optimises work processes - Contributing independently

Build a successful career with us

We’re all about building strong, lasting relationships with our employees. We know that you have hopes for your future – your career, your personal development and of achieving great things. We pride ourselves in helping our employees to realise their worth. Through its five business clusters – Sanlam Fintech, Sanlam Life and Savings, Sanlam Investment Group, Sanlam Allianz, Santam, as well as MiWay and the Group Office – the group provides many opportunities for growth and development.

Core Competencies

Cultivates innovation - Contributing independently

Customer focus - Contributing independently

Drives results - Contributing independently

Collaborates - Contributing independently

Being resilient - Contributing independently

Turnaround time

The shortlisting process will only start once the application due date has been reached. The time taken to complete this process will depend on how far you progress and the availability of managers.

Our commitment to transformation

The Sanlam Group is committed to achieving transformation and embraces diversity. This commitment is what drives us to achieve a diverse, inclusive and equitable workplace as we believe that these are key components to ensuring a thriving and sustainable business in South Africa. The Group's Employment Equity plan and targets will be considered as part of the selection process.

Apply Now

Job Seeker Tools

Employer Tools

Browse

Stay Connected