Johannesburg: Bunisess Intelligence Pecialist

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, report developers, 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 degree or diploma with a minimum of five (5) years experience in a BI Tester role and Business Intelligence or Data Testing related Certifications Microsoft Certified: Azure Data Engineer Associate, Data Analyst Associate (Power BI), SQL Server Database Development or administration ETL development or Data Integration Certified Agile Tester Data Quality and Validation A minimum of three years experience in T-SQL (Transact-SQL) for data validation, query development, and test scripting. A minimum of three 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 A minimum of two years experience working with and testing Data Marts, including schema validation and data accuracy.