WHAT IS THE OPPORTUNITY?
The Lead Data Quality Engineer is responsible for creating and executing comprehensive data testing strategies and solutions, with focus on data validation, integrity testing, and quality assurance across data platforms and interfaces. This role ensures accurate test data delivery in a fast-paced environment while providing technical expertise and mentorship to team members. The position bridges data testing assurance with data engineering, architecture, and business teams to deliver robust, trustworthy data testing & test data solutions in a dynamic financial services environment.WHAT WILL YOU DO?
Develop and execute comprehensive data testing strategies and automated testing solutions for data validation across multiple platforms, interfaces, and ETL processesDesign and implement automated data testing scripts and frameworks to validate data accuracy, completeness, consistency, and conformance to business rulesCreate and maintain test management documentation;
define, track, and report on quality metricsReview and enhance data testing strategies for current and existing data initiatives;
Collaborate with cross-functional teams to translate business requirements into executable testing scenarios and validation rulesManage defect tracking workflows and coordinate resolution with development and business teamsWork closely with vendors to implement testing solutionsRecommend improvements to testing processes, technology, and interfaces that improve the effectiveness of testing teamsOwn test data management strategy and automation;
ensure test data is properly provisioned, maintained, and compliant with data governance policiesWHAT DO YOU NEED TO SUCCEED?
Must have:6+ years of hands on experience in data testing and validation across various data platforms, interfaces,
and data warehouses5+ years of experience working with and testing relational databases;
ability to write and test complex SQL queries and stored proceduresStrong proficiency with data testing and validation tools (DVO, QuerySurge, or similar frameworks) and data profiling tools (IDC/CDGC or equivalent)Strong understanding of data models, ER diagrams, and ability to analyze complex data mapping and business rule documentationExperience in ETL Tools like IICS, Informatica Power Center or similar and ETL scheduler toolsProven experience in test data management strategy, provisioning, and automation;
understanding of data governance and compliance requirementsProven ability mentoring team members (onshore & offshore) and providing technical directionProficiency with Git version control, branching strategies, and strong experience testing and working in continuous delivery (CICD) environment.Experience with test management tools (Azure Test Plans, Jira QMetry) and quality metrics reportingNice-to-have
Knowledge about data obfuscation routinesExperience using AI tools like Copilot for test design or test automationWHAT'S IN FOR YOU?
We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities,
and achieving success that is mutual.A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicableLeaders who support your development through coaching and managing opportunitiesAbility to make a difference and lasting impactWork in a dynamic, collaborative, progressive, and high-performing teamA world-class training program in financial servicesOpportunities to do challenging work#TECHPJ Skills
Application Testing, Decision Making, Detail-Oriented, Group Problem Solving, IT Quality Assurance, Long Term Planning, Predictive Analytics, Programming Languages, Software Product Testing, Test AutomationAdditional Job Details
Address
180 WELLINGTON ST W:TORONTOCity:
TorontoCountry
CanadaWork hours/week
37.5Employment Type:
Full timePlatform
TECHNOLOGY AND OPERATIONSJob Type
RegularPay Type
SalariedPosted Date
2026-05-21Application Deadline:
2026-09-14Note:
Applications will be accepted until 11:59 PM on the day prior to the application deadline date aboveOur Employment Opportunities
At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One RBC. We believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities.
RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.
📌 Lead Quality Engineer - Automation (Data) (Winnipeg)
🏢 RBC
📍 Winnipeg