BI Test Analyst

We are recruiting a BI Test Analyst to join our dynamic team in Cape Town.

Qualification Required:

• Grade 12

Preferred Qualifications:                              

• Bachelorâ??s Degree in Computer Science or equivalent qualifications
• ISTQB Certification (advantageous)

Experience Required:

• At least 7+ yearsâ?? experience as a BI Test Analyst.
• Minimum 5 years of solid business intelligence testing experience.
• All manual testing activities during all phases of the SDLC from analyzing business requirements to designing and executing test cases in different environments.
• Creating and updating test cases to meet the business functional requirements using HPALM/QC.
• Verifying the accuracy and credibility of data from ETL Process, staging tables, BI reports and dashboards.
• Perform back-end (database) testing using complex SQL queries on Oracle and SQL Server databases.
• API Testing: SOAP UI OR POSTMAN.
• Experience working with JIRA, Confluence, and other collaborative tools advantageous.
• Very Strong in SQL scripting, data issues root cause analysis skills and Data Warehousing concepts.
• Proven testing experience with Business Intelligence (BI) reports like Microsoft Power BI or Tableau.
• Strong Data warehouse end to end and data completeness testing experience.
• Experience in complex ETL mappings, mapplets and complex transformations testing.
• Exposure to end-to-end data validation for ETL and BI systems
• Exposure to DB tools like Toad/PL SQL developer/SQL Plus/SQL server management studio.
• Experience in Business Intelligence testing in various reports.
• Basic understanding of automation.
• Ability to work within team following different development methodologies/ hybrid.

Duties/Responsibilities:

• The BI Tester will be responsible for:
  • All manual testing activities during all phases of the SDLC from analyzing business requirements to designing and executing test cases in different environments.
  • Creating and updating test cases to meet the business functional requirements using Verifying the accuracy and credibility of data from ETL Process, staging tables, BI reports and Dashboards.
  • Performing manual execution of the test cases within all test cycles (Unit, System Integration, UAT, Regression, Smoke).
  • Performing manual execution to verify dashboard customization requirements.
  • Performing load and performance test to ensure that data flows and mapping are not corrupted.
  • Performing manual execution to verify that reports generated are accurate.
  • Perform back-end (database) testing using complex SQL queries on Oracle and SQL Capturing and demonstrating test execution business end users for approval.
  • Making use of defect tracking tools such as JIRA to log, manage, resolve and report on bugs/defects.
  • Providing progress feedback in daily stand-up meetings.

Behavioral Competencies

• Ability to handle multiple tasks simultaneously
• Ability to work in a fast-paced environment with minimal supervision
• Sense of ownership and pride in your performance and its impact on companyâ??s success
• Critical thinking, problem-solving and prioritization skills
• Attention to detail
• Team player
• Demonstrated problem analysis and problem-solving skills in a technical environment.
• Excellent written and oral communication skills are required
• Good time-management skills
• Great interpersonal and communication skills
• Results Driven
• Flexible (able to adapt to change)

Work Environment:

• Hybrid Work Model - until December. From January you might go back to the office Full-Time.