Collections Analyst

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

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

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