Senior Data Analyst

Optim-G Sourcing; Stellenbosch; On-site; ZAR 700,000 - 1,000,000; Full time

Job summary

Optim-G Sourcing, a leading payment aggregator, is seeking a Senior Data Analyst to enable data-driven decision-making, improve data structures, and support business reporting across the organisation.

The role focuses on analysing the SQL Server data environment, translating reporting needs into data solutions, writing optimized SQL queries, and building Excel-based reports and dashboards for stakeholders.

Qualifications

• Degree in a quantitative field (Information Systems, CS, Engineering, Maths, Stats or Finance).
• 8-10 years’ experience in data analysis or a related role.
• Strong SQL skills and experience with data architectures or data dictionaries.
• Proven ability to build and maintain Excel-based reports and dashboards.
• Excellent English communication with technical and non-technical stakeholders.
• Own reliable transport.

Responsibilities

• Analyse and maintain understanding of the SQL Server data environment.
• Develop and maintain data documentation including data dictionaries.
• Translate business reporting requirements into data solutions.
• Write and optimise SQL queries for data extraction and analysis.
• Build and maintain Excel-based reports and dashboards.
• Perform ad hoc analysis to support decision-making.
• Identify and recommend data structure and performance improvements.
• Support testing, validation and data quality processes.
• Assist business users with data and reporting queries.

Skills

SQL Proficiency

Excel Dashboards

Data Analysis

English Communication

Education

Bachelor's degree in quantitative field

Tools

SQL Server

Power BI

Python

Job description

a leading payment aggregator and provider of secure payment solutions, is looking for a Senior Data Analyst to join their growing team. This role focuses on enabling data-driven decision-making, improving data structures, and supporting business reporting across the organisation. The ideal candidate is a proactive, self-directed individual with strong analytical ability, excellent attention to detail, and the ability to work both independently and collaboratively in a fast-paced environment.

Responsibilities include:

• Analyse and maintain an understanding of the SQL Server data environment, including data structures and flows.
• Develop and maintain data documentation, including data dictionaries.
• Translate business reporting requirements into data solutions.
• Write and optimise SQL queries for data extraction and analysis.
• Build and maintain Excel-based reports and dashboards.
• Perform ad hoc analysis to support business decision-making.
• Identify and recommend improvements to data structures and performance.
• Support testing, validation, and data quality processes.
• Assist business users with data and reporting queries.

Minimum requirements:

• Degree in a relevant quantitative field (Information Systems, Computer Science, Engineering, Mathematics, Statistics or Finance).
• 8-10 years’ experience in a similar data analysis role.
• Strong SQL skills.
• Experience documenting data architectures, data models, or data dictionaries.
• Demonstrated ability to build and maintain Excel-based reports and dashboards.
• Strong communication skills in English with the ability to work effectively with both technical teams and non-technical business stakeholders.
• Own reliable transport.

Advantageous:

• Experience with data modelling or database optimisation.
• Exposure to Power BI or similar tools.
• Python experience.
• Familiarity with Agile / Scrum delivery practices.
• Experience in fintech, payments or financial services.

Applications close 27 Aug 2026