Data Analyst

Yazoo Recruitment; Johannesburg; On-site; ZAR 400,000 - 600,000; Full time

Job summary

A leading recruitment agency is seeking a Data Analyst in Bryanston, Johannesburg. The role involves implementing and maintaining consumer data solutions, with a strong emphasis on data sourcing, transformation, and quality control, requiring a qualified candidate with at least four years of experience in the financial services sector and proficiency in SQL and SSIS.

Qualifications

• Minimum 4 years’ data analysis experience required.
• Intermediate MS SQL knowledge and experience required.
• SSIS experience and knowledge required.

Responsibilities

• Implement and maintain consumer data solutions.
• Collect, clean and analyse data from internal systems.
• Prepare data for ongoing marketing campaigns.

Skills

Data analysis

SQL

SSIS

Data cleaning

Automation of processes

Education

B.Sc / B.Comm information degree

Job description

Data Analyst positionn available in Bryanston, Johannesburg.

Data Analyst with relevant Degree and minimum 4 years’ data analysis experience, preferably in the Financial Services Industry, with knowledge and experience in MS SQL and SSIS, required to implement and maintain consumer data solutions, including data sourcing, transformation and quality control.

Minimum requirements:

• B.Sc / B.Comm information degree or relevant degree essential
• Minimum 4 years’ data analysis experience required, preferably in the Financial Services Industry
• Intermediate MS SQL knowledge and experience required
• SSIS experience and knowledge required
• Must be able to write SQL scripts and rules
• Automation of processes experience required
• Experience working with short term insurance, warranties or service plans advantageous

Responsibilities:

• Implement and maintain consumer data solutions, including data sourcing, transformation and quality control
• Collect, clean and analyse data from internal systems
• Store and load collected data into marketing database
• Load and clean data
• Determine database rules and implement rules on marketing database
• Lead management
• Prepare data for ongoing marketing campaigns
• Write SQL scripts to prepare data
• Write scripts for automation of lead flows into the call centre
• Create dashboards, reports and data models
• Support compliance and regulatory reporting
• Stakeholder engagement
• Monitor data accuracy and assist with improving data capture processes
• Recommend data driven strategies to increase efficiency, retention and profitability
• Data confidentiality and compliance

If you are a SA citizen & your CV meets the above criteria, please send your CV.