Data Analyst

PayTech Nexus Ltd; Johannesburg; On-site; ZAR 300,000 - 400,000; Full time

Job summary

A leading financial services provider in Johannesburg is seeking a Data Analyst. The role involves optimizing data extraction processes, ensuring data accuracy, and collaborating with various departments. Candidates must have 5-7 years of experience in the financial industry, with strong skills in SQL and data extraction. This position offers the chance to work with large datasets and contribute to improving reporting accuracy.

Qualifications

• 5-7 years of relevant experience.
• Experience with large datasets and SQL-based data extraction.
• Strong analytical skills and attention to detail.

Responsibilities

• Optimize and automate the data extraction process.
• Ensure data integrity and accuracy through quality checks.
• Collaborate with teams for timely data submissions.

Skills

Payment Processing

Data Extraction

Segment Modelling

SQL

Scripting Languages

Education

Bachelor's degree in computer science or related field

Tools

Oracle

Microsoft SQL Server

Job description

Overview

Job Title: Data Analyst

Term: 12 months

Location: Johannesburg, South Africa

Division: Services

Reports to: Head of Cards/ CEO

Relevant experience: 5-7 years

Mandatory requirements:

• Payment Processing
• Data Extraction
• Segment Modelling
• Lead Creation

PURPOSE OF JOB

The Data Analyst will be responsible for reviewing, maintaining, and enhancing system scripts and processes to extract, validate, and prepare and extract data and build segmentation model. The analyst will ensure that the data required for the project is accurate, compliant, and submitted in a timely manner.

TASKS

Core Responsibilities and Accountabilities

• Review and analyze system scripts responsible for extracting data from various internal systems.
• Ensure that scripts and queries are correctly pulling the required customer data.
• Work closely with IT and operations teams to optimize and automate the data extraction process.
• Prepare and structure data to meet required formats and reporting standards.
• Validate data integrity and accuracy by conducting reconciliations and quality checks before submission.
• Develop new or enhance existing system scripts, SQL queries, and automation processes for efficient data extraction.
• Troubleshoot and resolve any issues related to scripts, ensuring data is pulled accurately and timely.
• Document all data extraction procedures and ensure scripts are version controlled.
• Ensure data submissions comply with companys reporting guidelines.
• Monitor and address any discrepancies or errors in data submissions as identified.
• Collaborate with reporting teams to ensure timely and accurate data submissions.
• Analyze trends and patterns in extracted data to identify areas of improvement or concern.
• Generate internal reports to provide customer segment insights for the relevant data.
• Assist in compiling feedback for senior management regarding performance and compliance with companys guidelines.
• Work closely with payment operations, compliance, IT, and finance teams where necessary to ensure alignment on data reporting requirements.
• Coordinate with vendors and service providers, if necessary, to integrate or adjust data feeds and ensure smooth data flow.
• Stay updated on companys evolving reporting standards, ensuring internal systems adapt accordingly.
• Identify opportunities for process improvements, automation, and enhanced reporting accuracy.

Knowledge and Experience

• Previous experience working in financial or payment industry.
• Experience in working with large datasets and SQL-based data extraction.
• Proficiency in SQL, scripting languages (e.g., Python, Shell), and data querying techniques.
• Familiarity with payment systems, card processing, and clearing/settlement processes (especially with Mastercard networks).
• Experience with financial reporting systems and databases, such as Oracle, Microsoft SQL Server, or similar platforms.
• Strong analytical and problem-solving skills, with a keen eye for detail in reviewing system outputs and ensuring data accuracy.
• Ability to translate complex system and transaction data into clear, actionable reports.
• Strong verbal and written communication skills to interact with technical and non-technical stakeholders.
• Ability to present data findings to management and recommend corrective actions when needed.
• Bachelors degree in computer science, Information Systems, Data Analytics, or a related field