Publié hier
SQL Data Quality Engineer
@ SPECTRAFORCE
Toronto, Ontario
Responsabilités :
- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
Résumé des exigences :
- •Develop and implement complex SQL-based Data Quality (DQ) rules supporting Customer Risk Rating (CRR) and Transaction Monitoring (TM) regulatory requirements.
- •Translate business and data quality requirements into efficient SQL logic, ensuring rules accurately reflect documented requirements and acceptance criteria.
- •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.
Outils et compétences
Source et dates
Type de source non vérifié · spectraforce-careers
- Date publiée par l’employeur
- 2026-11-15
- Première détection par notre source
- 2026-11-16
- Mise à jour du dossier source
- 2026-11-16
Ces dates décrivent le dossier source, pas une vérification en direct du recrutement. Consultez l’offre originale.
SPECTRAFORCE
| Champ | Valeur |
|---|---|
| Siège social | Raleigh |
| Offres sur Jobsy | 97 |
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.
Journal
Visible seulement par vous. Conservé sur cet appareil, et dans votre compte une fois connecté.