Lead Data Quality Engineer: Testing & Automation Leader

ODAIA

Toronto

On-site

CAD 120,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Total Rewards Program including bonus/
Coaching & development opportunities
World-class training program in金融服务
Opportunities to do challenging work

Job summary

RBC is seeking a Lead Data Quality Engineer to create and execute comprehensive data testing strategies across platforms and ETL processes. You will mentor teams, validate data integrity, and drive governance-aligned test data solutions in a financial services setting.

You will collaborate with engineering, architecture, and business teams to translate requirements into testing scenarios, manage defects, and work with vendors to enhance testing tools and processes.

Qualifications

  • 6+ years of hands-on data testing and validation across platforms, interfaces, and data warehouses.
  • 5+ years testing relational databases; ability to write and test complex SQL queries and stored procedures.
  • Strong proficiency with data testing/validation tools (DVO, QuerySurge) and data profiling tools (IDC/CDGC).
  • Strong understanding of data models, ER diagrams, and data mapping/business rule documentation.
  • Experience with ETL tools like IICS, Informatica PowerCenter or similar and ETL schedulers.
  • Proven experience in test data management strategy, provisioning, and automation; data governance/compliance knowledge.

Responsibilities

  • Develop and execute comprehensive data testing strategies and automated testing solutions for data validation across multiple platforms and ETL processes.
  • Design and implement automated data testing scripts and frameworks to validate data quality against business rules.
  • Create and maintain test management documentation; track and report quality metrics.
  • Collaborate with cross-functional teams to translate requirements into executable testing scenarios and validation rules.
  • Manage defect tracking workflows and coordinate resolution with development and business teams.
  • Partner with vendors to implement testing solutions and recommend process improvements.

Skills

Data testing
SQL queries
Data modeling
Test data management
Mentoring
Git & CI/CD
Test management
Cross-functional collaboration

Tools

DVO
QuerySurge
IDC/CDGC
IICS
Informatica PowerCenter
ETL schedulers

Job description

RBC is seeking a Lead Data Quality Engineer to create and execute comprehensive data testing strategies across platforms and ETL processes. You will mentor teams, validate data integrity, and drive governance-aligned test data solutions in a financial services setting.

You will collaborate with engineering, architecture, and business teams to translate requirements into testing scenarios, manage defects, and work with vendors to enhance testing tools and processes.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Quality Engineer - Automation (Data)
Lead Quality Engineer - Automation (Data)

RBC • Toronto

On-site
CAD 120,000 - 180,000
Total Rewards Program including bonus/
Coaching & development opportunities
World-class training program in金融服务
+1
Quality Assurance Automation Lead
Quality Assurance Automation Lead

Comptech Associates • Toronto

On-site
CAD 100,000 - 130,000
Lead AI Test Engineer
Lead AI Test Engineer

LTM • Rankin

On-site
CAD 100,000 - 130,000
Senior Test Lead - Data Quality & ETL Expert (Hybrid)
Senior Test Lead - Data Quality & ETL Expert (Hybrid)

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
AML QA Portfolio Lead: Data Testing & Automation
AML QA Portfolio Lead: Data Testing & Automation

Scotiabank • Toronto

On-site
CAD 110,000 - 150,000
Performance bonus
Lead Data Engineer: Wealth Analytics on Google Cloud
Lead Data Engineer: Wealth Analytics on Google Cloud

Scotiabank • Toronto

On-site
CAD 120,000 - 160,000
Inclusive culture
Accessibility & accommodations
Upskilling opportunities
+3
Director, AI/ML Platform & MLOps Leadership
Director, AI/ML Platform & MLOps Leadership

RBC • Vancouver

On-site
CAD 150,000 - 190,000
RQ08114 - Test Lead Senior
RQ08114 - Test Lead Senior

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
QA Testing Manager — Lead Quality Assurance Teams
QA Testing Manager — Lead Quality Assurance Teams

The Toronto-Dominion Bank (Canada) • Toronto

On-site
CAD 97,000 - 137,000
Lead QA Engineer: Data Warehouse & ETL Testing
Lead QA Engineer: Data Warehouse & ETL Testing

Canadian Institute for Health Information (CIHI) • Toronto

On-site
CAD 80,000 - 100,000
Retirement Planning Program
Generous vacation days
Work-life balance
+2