SQL Data Quality Engineer

Toronto, Ontario
Date Posted:16-Nov-2026
Work Type:Hybrid
Job Number:506837

Job Description

Role: SQL Data Quality Engineer
Duration 6 Months
Location: Toronto, ON -3 days in office, 2 days work from home
 
Key Responsibilities
•Develop and implement complex SQL-based Data Quality (DQ) rules supporting Customer Risk Rating (CRR) and Transaction Monitoring (TM) regulatory requirements.
•Write, test, validate, and troubleshoot SQL queries across large datasets to identify data quality issues, exceptions, and control failures.
•Perform end-to-end validation of DQ rules, including source-to-target reconciliation, record-level analysis, expected-result validation, and investigation of failed records.
•Translate business and data quality requirements into efficient SQL logic, ensuring rules accurately reflect documented requirements and acceptance criteria.
•Troubleshoot data, rule-logic, and performance issues, perform root-cause analysis, and work with technical and business teams to resolve defects quickly.
•Support the implementation and deployment of DQ rules into Collibra, including testing and validation before production rollout.
•Work independently in a fast-paced regulatory environment with aggressive delivery timelines, managing multiple CRR and TM rules simultaneously.
•Maintain appropriate documentation and testing evidence to support governance, regulatory, and audit requirements.
 
Must-have hard skills:
1.) 8+ years of experience of Data Management experience
2.) 8+ years of experience using SQL including complex joins, CTEs, subqueries, aggregations, window functions, data profiling, reconciliation, and troubleshooting large datasets.
3.) 8+ years of data quality testing, data analysis, and SQL-based control/rule development
4.) Experience analyzing failed records and performing root-cause analysis across multiple data sources
 
Soft skills:
1.) Strong communication skills (written and verbal)
2.) Strong information gathering, reporting and documentation skills
3.) Strong collaboration skills, team player mindset
4.) Takes initiative
 
Nice-To-Have
1.) Banking or financial institution experience
2.) AML or FCRM experience
 
 
  

Applicant Notices & Disclaimers
  • For information on benefits, equal opportunity employment, and location-specific applicant notices, click here


At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. The pay rate for this position is C$70.00/hr.