Data Analyst

Level-Up; Sandton; On-site; ZAR 300,000 - 400,000; Full time

Job summary

A leading company in the financial services sector is seeking a Data Analyst with a strong background in data management and analysis. The successful candidate will be responsible for data collection, cleansing, and preparation for marketing initiatives, while collaborating with multiple stakeholders to deliver impactful data-driven strategies. The role requires a B.Sc. in Information Systems or a related field, along with significant experience in SQL and data automation.

Qualifications

• Minimum of 4 years of experience in a data analysis role.
• Proficiency in writing SQL scripts.
• Experience with process automation is beneficial.

Responsibilities

• Collect, clean, and analyze data from various systems.
• Prepare data for marketing campaigns by writing SQL scripts.
• Create dashboards and reports for decision-making.

Skills

Analytical skills

Problem-solving skills

Attention to detail

Creative thinking

Collaboration

Education

B.Sc. / B.Comm in Information Systems

Tools

MS SQL

SSIS

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