32 Data Analysis jobs in Pretoria

SUMMARY :

This role requires an experienced and highly skilled senior business intelligence specialist with expertise in Microsoft Stack, specifically with strong experience in data warehousing, data lake technologies, and Power BI.

POSITION INFO : JOB PURPOSE

This role requires an experienced and highly skilled senior business intelligence specialist with expertise in Microsoft Stack, specifically with strong experience in data warehousing, data lake technologies, and Power BI. The incumbent will serve as the technical expert responsible for designing, developing, and maintaining robust and scalable business intelligence solutions using Microsoft technologies such as SQL Server, Azure Data Warehouse, Azure Data Lake, and Power BI. Collaborate with cross functional teams to gather requirements, data warehouse and data lake solutions, create insightful reports and visualizations, and deliver actionable insights to meet stakeholder needs.

KEY PERFORMANCE AREAS

Strategic Function

• Contributes to the strategy, vision, and governance of the BI and Data Analytics capability.
• Drive best practices, iterative improvement, and innovation at the strategic deployment level.
• Provide strategic support and identify opportunities in existing business processes for building reports and dashboards.
• Function as an integrator between the business and technology to create business solutions.
• Support the implementation of the centre Balance Score Card (BSC) project and initiatives.
• Support define and manage best practices for our Data Warehouse. This may include payload design of source data, logical data modeling, implementation, metadata, and testing standards.
• Support to set standards and ways of working with data across the company and Auditees, through collaboratively way.

Product Management

Stakeholder Management

People Management

Financial management and Operational Management

Other responsibilities (Applicable to All JD’s

BEHAVIOURAL COMPETENCIES

TECHNICAL COMPETENCIES

GENERAL REQUIREMENTS

Formal Education

Experience / Requirements

• Design and execute test plans and test cases for ETL processes, data integration workflows, data marts, and reporting platforms (e.g., Power BI).
• Perform data validation and reconciliation between source systems and target BI systems.
• Conduct functional, integration, system, regression, and performance testing on BI
• solutions and data pipelines.
• Identify data quality issues and inconsistencies, log defects, and track them through to resolution.
• Validate the correctness of business logic applied in BI reports, dashboards, and analytics solutions.

• Collaborate with BI developers, data engineers, business analysts, and stakeholders to understand requirements and expected outcomes.
• Participate in Agile/Scrum ceremonies (e.g., sprint planning, reviews, and retrospectives) where applicable.
• Maintain comprehensive testing documentation, including test cases, test results, defect logs, and sign-off reports.
• Assist with user acceptance testing (UAT) and provide support for end-user validation where required.

• Microsoft SQL Server T-SQL for querying and test script development.
• SSIS (SQL Server Integration Services) for testing ETL workflows and data transformation logic.
• Power BI for verifying visuals, data accuracy, and report logic.
• Data Marts for schema validation and data consistency testing.

• Provide regular testing status updates, risk assessments, and defect summaries to the company BI project team.
• Participate in progress meetings, testing reviews, and provide input into project timelines and delivery readiness.

• Must have a computer science/ information systems/ statistics or mathematics diploma or degree and Business Intelligence or Data Testing related certifications (i.e. Azure Data Engineer Associate, Data Analyst Associate (Power BI), SQL Server Database Development, Administration ETL, Certified Agile Tester (CAT)) as well as a minimum of eight years experience in a Tester role in a data and BI environment, with experience as follows:
• A minimum of ten years experience in T-SQL (Transact-SQL) for data validation, query development, and test scripting.
• A minimum of six years experience testing SSIS (SQL Server Integration Services) and
• ETL processes, including validating data pipelines and transformation logic.
• A minimum of four years experience testing and verifying Power BI dashboards and reports.
• A minimum of four years experience working with and testing Data Marts, including schema validation and data accuracy.

We are recruiting for a Business Intelligence Tester.

Key Responsibilities:
BI Testing and Quality Assurance

• Design and execute test plans and test cases for ETL processes, data integration workflows, data marts, and reporting platforms (e.g., Power BI).
• Perform data validation and reconciliation between source systems and target BI systems.
• Conduct functional, integration, system, regression, and performance testing on BI
• solutions and data pipelines.
• Identify data quality issues and inconsistencies, log defects, and track them through to resolution.
• Validate the correctness of business logic applied in BI reports, dashboards, and analytics solutions.

• Collaborate with BI developers, data engineers, business analysts, and stakeholders to understand requirements and expected outcomes.
• Participate in Agile/Scrum ceremonies (e.g., sprint planning, reviews, and retrospectives) where applicable.
• Maintain comprehensive testing documentation, including test cases, test results, defect logs, and sign-off reports.
• Assist with user acceptance testing (UAT) and provide support for end-user validation where required.

• Microsoft SQL Server – T-SQL for querying and test script development.
• SSIS (SQL Server Integration Services) – for testing ETL workflows and data transformation logic.
• Power BI – for verifying visuals, data accuracy, and report logic.
• Data Marts – for schema validation and data consistency testing.

• Provide regular testing status updates, risk assessments, and defect summaries to the company BI project team.
• Participate in progress meetings, testing reviews, and provide input into project timelines and delivery readiness.

• Must have a computer science/ information systems/ statistics or mathematics diploma or degree and Business Intelligence or Data Testing related certifications (i.e. Azure Data Engineer Associate, Data Analyst Associate (Power BI), SQL Server Database Development, Administration ETL, Certified Agile Tester (CAT)) as well as a minimum of eight years’ experience in a Tester role in a data and BI environment, with experience as follows:
• A minimum of ten years’ experience in T-SQL (Transact-SQL) for data validation, query development, and test scripting.
• A minimum of six years’ experience testing SSIS (SQL Server Integration Services) and
• ETL processes, including validating data pipelines and transformation logic.
• A minimum of four years’ experience testing and verifying Power BI dashboards and reports.
• A minimum of four years’ experience working with and testing Data Marts, including schema validation and data accuracy.

Senior Business Intelligence Analyst

Role Purpose

The Senior Business Intelligence (BI) Analyst plays a crucial role in translating business needs into actionable insights. This role involves gathering, analyzing, and interpreting data to provide recommendations that drive strategic decision-making. The Senior BI Analyst possesses a strong understanding of data warehousing, ETL processes, data visualization, and reporting techniques. They are comfortable working with various data sources and BI tools and can effectively communicate complex information to both technical and non-technical audiences.

Responsibilities and work outputs:

1. Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements.
2. Data Collection & Preparation: Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity.
3. Data Modeling & Warehousing: Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability.
4. ETL Processes: Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse.
5. Data Analysis & Interpretation: Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions.
6. Report & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively.
7. Performance Monitoring: Monitor the performance of BI solutions and identify areas for improvement.
8. Documentation: Create and maintain documentation for data sources, ETL processes, reports, and dashboards.
9. Collaboration & Communication: Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences.
10. Continuous Learning: Stay up-to-date with the latest BI trends, tools, and techniques.
11. Mentorship: Mentor junior analysts and provide guidance on best practices.

Key Skills:

• Data Warehousing
• Communication (Written & Verbal)
• Critical Thinking

Experience and Qualifications:

• Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.
• 5-8 years of experience in business intelligence or data analysis.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.
• Proficiency in SQL and experience working with relational databases.
• Experience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker).
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences.
• Ability to work independently and as part of a team.
• Experience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus.
• Experience with scripting languages (e.g., Python, R) is a plus.
• Knowledge of statistical methods and techniques is a plus.

Location: The above-mentioned position is currently available at our office in Centurion.

All positions will be filled in accordance with our Employment Equity plan. We also encourage people with disabilities to apply.

Mid-Senior level

Full-time

Information Technology, General Business, and Analyst

Financial Services, Insurance, and Data Infrastructure and Analytics

Job no.: 1143

Job title: Manager (Applications – Business Intelligence)

Organisation: Solutions Delivery ‒ Business Intelligence and Collaboration Division

Department: Business Solutions and Technology Department

Brief description

The main purpose of this position is to manage and coordinate resources in support of current operations and the delivery of new information technology (IT) solutions for the business intelligence and analytics area within the Business Solutions and Technology Department (BSTD).

Detailed description

The successful candidate will be responsible for the following key performance areas:

• Manage operational planning by developing short-term work plans in line with the BSTD strategy and business plans and communicate section activities.
• Manage and improve workflow and the application of processes, procedures and systems.
• Make suggestions for refining policies, processes and systems, and improve alignment with related divisional processes and systems.
• Manage and facilitate the delivery of section-specific outputs, including the timely delivery of projects and readiness of solutions to transition into operations.
• Optimise section resource use, allocate work and manage the accountability of resources, and provide input into cost management.
• Manage stakeholder relationships to ensure the timely delivery of quality IT solutions in accordance with business requirement specifications.
• Identify gaps and inefficiencies (including governance, management of risks and audit findings) in the work of the section and take specific actions for the implementation of improvements.
• Manage, monitor, evaluate and report on the quality, turnaround and impact of section deliverables.
• Encourage a performance culture in the section, define performance expectations and conduct effective performance management of direct reports.
• Drive priority development of employees by promoting and supporting the career management and development of direct reports.
• Drive innovation and bring on necessary changes to improve application processes and systems to align with global best practices.
• Execute the IT strategy within the section.
• Drive and grow the business intelligence and analytics capability in the South African Reserve Bank (SARB).

Job requirements

To be considered for this position, candidates must be in possession of:

• Honours degree in Computer Science or an equivalent (NQF8) qualification;
• 8 to10 years’ experience in an IT environment, with two years experience in management; and
• three years experience in managing Business Intelligence and Analytics platforms.

Additional requirements include:

Knowledge and skill in:

• industry, organisational and business awareness;
• IT enablement reporting;
• continuous learning and/or professional development;
• quality assurance;
• continuous improvement;
• business continuity planning;
• IT enablement strategy;
• IT enablement legislation, governance, risk and compliance;
• IT transformation and innovation;
• IT enablement project management;
• application design, development, maintenance and support;
• infrastructure design and development;
• systems integration;
• database management;
• asset and inventory management;
• business intelligence; and
• capacity and performance management.

How to apply

Internal applicants MUST apply through the HCM Cloud Solution.

Follow these links:

• Click on Me .
• Click on Show More .
• Under Current Jobs , click on Search Jobs , then select the job you want to apply for.
• Click on Apply now .

External applicants MUST apply online, via

All available vacancies will be visible.

Follow these links:

• Click on WORK @ SARB (Career opportunities ).
• Under Latest vacancies , scroll to ‘For more vacancies click here’ and click on here .
• Click on All jobs .
• Select the job you want to apply for.
• Click on Apply now .
• Login/register
• Is this your first visit to our Job Site? > Register today (Ensure that you include all your skills and qualifications during the registration process.); or
• Already registered on our Job Site? > Already registered? > Login here.

Do not enclose copies of your identity document or qualifications with your application.

Shortlisted applicants will be subjected to a psychometric assessment, an appropriate reference check and a security clearance as part of the selection process.

The closing date for applications is 12 August 2025. Late applications will not be considered.

In line with the SARB’s commitment to diversifying its workforce, preference will be given to suitable candidates from designated groups. People with disabilities are welcome to apply.

The SARB offers remuneration and benefits commensurate with the level of the position and in line with the market. The level at which the successful applicant will be appointed will depend on his/her competence and experience.

Human Resources Department

Join a dynamic and forward-thinking organization in the heart of Centurion, Pretoria, operating within the vibrant financial sector. Our client is a leader in providing innovative financial solutions, dedicated to delivering excellence in service and driving sustainable growth in the industry. As part of our commitment to staying ahead in a rapidly evolving market, we are seeking a talented and motivated individual to join our team as a Business Intelligence & Reporting Engineer.

Requirements:

1. Bachelor's degree in Computer Science, Statistics, Mathematics, or a related field.
2. Proven experience in data analysis, data modeling, and visualization techniques.
3. Strong proficiency in SQL is a must and proficiency in one or more programming languages (e.g., Python, R) for data manipulation and analysis is preferred.
4. Experience with Power BI, or similar data visualization tools.
5. Solid understanding of software testing methodologies, techniques, and tools.
6. Experience with testing data reporting, and BI applications is preferred.

Join a dynamic and forward-thinking organization in the heart of Centurion, Pretoria, operating within the vibrant financial sector. Our client is a leader in providing innovative financial solutions, dedicated to delivering excellence in service and driving sustainable growth in the industry. As part of our commitment to staying ahead in a rapidly evolving market, we are seeking a talented and motivated individual to join our team as a Business Intelligence & Reporting Engineer.

Requirements:

1. Bachelor's degree in Computer Science, Statistics, Mathematics, or a related field.
2. Proven experience in data analysis, data modeling, and visualization techniques.
3. Strong proficiency in SQL is a must and proficiency in one or more programming languages (e.g., Python, R) for data manipulation and analysis is preferred.
4. Experience with Power BI, or similar data visualization tools.
5. Solid understanding of software testing methodologies, techniques, and tools.
6. Experience with testing data reporting and BI applications is preferred.

Reference: JHB002478-TR-1

We are recruiting for a Business Intelligence Developer.

Minimum Requirements:

1. 5 years of proven and practical experience in developing BI solutions using the Microsoft Technology Stack.

Minimum Skills:

1. Microsoft SSRS
2. Microsoft SSAS
3. Microsoft SSIS
4. Microsoft PowerBI
5. ETL procedures

Minimum Qualifications:

1. Certification in Microsoft SQL Reporting Services, Integration Services, Analysis Services, Data Warehousing, and PowerBI.

Advantageous:

1. NQF 6 or above within the related field.