Data Engineering Test Lead

Pbt-Group; Cape Town; On-site; ZAR 700,000 - 1,100,000; Full time

Job summary

PBT Group in Cape Town is seeking a Data QA Lead to oversee testing of data pipelines, ETL/ELT processes and BI reporting, blending hands-on data/SQL testing with test leadership and UAT coordination across business and technical teams.

Requirements: Bachelor’s degree/diploma in IT; 5–8 years in data/QA testing, 2+ in lead roles; advanced SQL, ETL/ELT testing and data warehousing concepts (Kimball/Data Vault). Nice-to-haves: Azure/AWS, Snowflake, Power BI or Qlik.

Qualifications

• Bachelor’s degree/diploma in Computer Science/Information Systems/Engineering or related field, or equivalent experience.
• 5–8 years in data/QA testing, with 2+ years in a lead/coordination role.
• Advanced SQL required; experience with ETL/ELT testing and data warehousing concepts (Kimball/Data Vault).

Responsibilities

• Define and own the test strategy across SIT, data validation, regression and UAT for data and BI solutions.
• Design and execute data reconciliation, validation and quality checks (source-to-target, row counts, transformation logic).
• Build repeatable test frameworks and automated data quality checks where possible.
• Manage defect logging, triage, root-cause analysis and resolution tracking.
• Lead and mentor a small team of testers / QA analysts; coordinate testing resources and priorities.
• Plan and coordinate UAT with business users and SMEs — scope, entry/exit criteria, scenarios, execution tracking and business sign-off.
• Manage testing risks, dependencies and readiness for go-live.
• Engage Business, Internal teams and SMEs in a structured, professional manner.

Skills

Advanced SQL

ETL/ELT testing

Data warehousing concepts

Education

Bachelor's degree/diploma in IT

Tools

Azure

AWS

Snowflake

Power BI

Qlik

Job description

Be part of our team of Data Specialists and embark on a career of the future!

To lead the quality assurance and testing of data pipelines, ETL/ELT processes and reporting solutions, ensuring data is accurate, reliable and fit for business use. The role blends hands-on data/SQL testing with test leadership, UAT coordination and structured stakeholder engagement across Business, SMEs and technical teams.

Key Responsibilities

1. Testing & Data Quality

Define and own the test strategy across SIT, data validation, regression and UAT for data and BI solutions.

Design and execute data reconciliation, validation and quality checks (source-to-target, row counts, transformation logic, business rules).

Build repeatable test frameworks and automated data quality checks where possible.

Manage defect logging, triage, root-cause analysis and resolution tracking.

Lead and mentor a small team of testers / QA analysts; coordinate testing resources and priorities.

Plan and coordinate UAT with business users and SMEs — scope, entry/exit criteria, scenarios, execution tracking and business sign-off.

Manage testing risks, dependencies and readiness for go-live.

3. Stakeholder Engagement

Engage Business, Internal teams and SMEs in a structured, professional manner.

Define test cases and communicate quality status clearly to non-technical stakeholders.

Build credibility and a “big picture” business acumen — not just query-writing.

Qualification: Bachelor’s degree/diploma in Computer Science, Information Systems, Engineering or related (or equivalent experience)

Experience: 5–8 years in data/QA testing, with 2+ years in a lead/coordination role

Core Technical: Advanced SQL (mandatory), ETL/ELT testing, data warehousing concepts (Kimball/Data Vault)

Testing:

Domain: Short-term insurance / financial services exposure highly advantageous

Cloud / Tooling: Exposure to Azure / AWS / Snowflake, Power BI / Qlik; test/automation tools an advantage

Advantageous / Nice-to-Have

Guidewire, TIA or similar insurance platform data structures

Python for test automation / data validation

Experience in cloud migration or Medallion architecture initiatives

ISTQB or similar testing certification

Key Strengths (Ideal Candidate)

Strong SQL and data-testing capability with a quality-first mindset

Proven test leadership and UAT coordination

Structured stakeholder engagement and business acumen — commands respect and sees the bigger picture

Analytical, methodical problem-solver who can bridge business and technology

* In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent

* If you have not received any feedback after 2 weeks, please consider you application as unsuccessful.

Skills

Data Warehousing Extract Transform Load (ETL) SQL System Integration Testing (SIT) Test Plans User Acceptance Testing (UAT)