Sandton, South Africa

Data Analyst

 Job Description:

Key Responsibilities

  • Collect, clean, and analyse data from internal systems (CRM, claims systems, sales platforms, finance, etc.)
  • Store and load collected data into a marketing database
  • Load new data and perform data cleansing
  • Define and implement database rules
  • Manage leads and support lead flows into call centres
  • Prepare data for marketing campaigns by writing SQL scripts aligned with selection criteria
  • Automate lead flow processes
  • Create dashboards, reports, and data models to support performance tracking and decision-making
  • Support compliance and regulatory reporting (e.g., FAIS, TCF, POPIA) through data audits and extracts
  • Collaborate with stakeholders (Sales, Finance, HR, IT) to convert business needs into data solutions
  • Monitor data accuracy and help improve data capture processes
  • Recommend data-driven strategies to improve efficiency, retention, and profitability
  • Ensure data confidentiality and compliance with POPIA and internal data policies

Experience and Skills Required

  • Minimum of 4 years' experience in a data analysis role, preferably within the financial services or insurance sector
  • Experience with short-term insurance, motor warranties, or vehicle service plans is beneficial
  • Proficiency in writing SQL scripts and rules
  • Experience with process automation

Non-Technical Skills

  • Strong analytical and problem-solving skills
  • Creative thinker with the ability to derive insights from data
  • Detail-oriented and passionate about working with data
  • Eagerness to learn, explore technical boundaries, and discover new solutions
  • Ability to thrive in a fast-paced environment and prioritise tasks effectively
  • Capable of working independently and within a team
  • Maintains a positive and proactive attitude

Qualifications

  • B.Sc. / B.Comm in Information Systems or a relevant degree
  • Intermediate knowledge and experience in MS SQL
  • Experience with SSIS
  • Background in call centre marketing is advantageous
  Required Skills:

Compliance Analysis CRM Financial Services Load Information Systems Confidentiality Decision-Making Campaigns Insurance Automation Writing Data Analysis Finance SQL Marketing Business Sales