Business Intelligence Tester

Findojobs South Africa; Gauteng; On-site; ZAR 600,000 - 800,000; Full time

Job summary

A leading BI solutions provider in Gauteng is looking for an experienced BI Tester. You will design and execute test plans for data integration workflows, validate data accuracy, and collaborate with BI teams. The ideal candidate should have a relevant degree and at least 8 years of experience in testing, with proficiency in T-SQL and SSIS. This role offers the opportunity for impactful work within an Agile environment.

Qualifications

• Minimum of 8 years' experience in a Tester role in a data and BI environment.
• 10 years’ experience in T-SQL for data validation and query development.
• 6 years’ experience testing SSIS and ETL processes.
• 4 years’ experience testing Power BI dashboards and reports.
• 4 years’ experience with Data Marts, schema validation, and data accuracy.

Responsibilities

• Design and execute test plans and test cases for ETL processes and data integration workflows.
• Conduct functional, integration, system, regression, and performance testing on BI solutions.
• Validate the correctness of business logic in BI reports and dashboards.

Skills

T-SQL

SSIS

Power BI

Data Marts

Agile methodologies

Education

Diploma or degree in Computer Science, Information Systems, Statistics or Mathematics

Business Intelligence certifications

Tools

Microsoft SQL Server

Query Development

Data Testing certifications

Job description

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.

Collaboration and Documentation

• 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.

Tools and Platforms - the BI Testers must be proficient in working with the following technologies and environments:

• 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.

Reporting and Communication

• 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.

Requirements:

• 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.