Data Quality Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM 59033
Our banking client is seeking a Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM
Support data quality and controls for an FCRM capability, with SQL-based rules addressing Customer Risk Rating (CRR) and Transaction Monitoring (TM) regulatory requirements. Join a five-person team in a positive, collaborative work environment, with onboarding and FCRM data management training. This six-month contract offers potential extension or conversion based on business needs and performance.
Contract, Toronto, Hybrid, Working Hours: EST
Must Haves
- 8+ years in Data Management.
- 8+ years using SQL, including complex joins, CTEs, subqueries, aggregations, window functions, data profiling, reconciliation, and troubleshooting large datasets.
- 8+ years in data quality testing, data analysis, and SQL-based control/rule development.
- Root-cause analysis across multiple data sources, including analysis of failed records.
Nice to Have
- Banking or financial institution experience.
- AML or FCRM experience.
- Post-secondary education.
Responsibilities
- Develop complex SQL-based Data Quality (DQ) rules supporting CRR and TM regulatory requirements.
- Test SQL queries across large datasets to identify data quality issues, exceptions, and control failures.
- Validate DQ rules end to end through source-to-target reconciliation, record-level analysis, expected-result validation, and failed-record investigation.
- Translate business and data quality requirements into efficient SQL logic aligned with documented requirements and acceptance criteria.
- Troubleshoot data, rule-logic, and performance issues through root-cause analysis and defect resolution with technical and business teams.
- Support DQ rule implementation and deployment into Collibra, including testing and validation before production rollout.
- Maintain documentation and testing evidence supporting governance, regulatory, and audit requirements.
Our banking client is seeking a Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM
Support data quality and controls for an FCRM capability, with SQL-based rules addressing Customer Risk Rating (CRR) and Transaction Monitoring (TM) regulatory requirements. Join a five-person team in a positive, collaborative work environment, with onboarding and FCRM data management training. This six-month contract offers potential extension or conversion based on business needs and performance.
Contract, Toronto, Hybrid, Working Hours: EST
Must Haves
- 8+ years in Data Management.
- 8+ years using SQL, including complex joins, CTEs, subqueries, aggregations, window functions, data profiling, reconciliation, and troubleshooting large datasets.
- 8+ years in data quality testing, data analysis, and SQL-based control/rule development.
- Root-cause analysis across multiple data sources, including analysis of failed records.
Nice to Have
- Banking or financial institution experience.
- AML or FCRM experience.
- Post-secondary education.
Responsibilities
- Develop complex SQL-based Data Quality (DQ) rules supporting CRR and TM regulatory requirements.
- Test SQL queries across large datasets to identify data quality issues, exceptions, and control failures.
- Validate DQ rules end to end through source-to-target reconciliation, record-level analysis, expected-result validation, and failed-record investigation.
- Translate business and data quality requirements into efficient SQL logic aligned with documented requirements and acceptance criteria.
- Troubleshoot data, rule-logic, and performance issues through root-cause analysis and defect resolution with technical and business teams.
- Support DQ rule implementation and deployment into Collibra, including testing and validation before production rollout.
- Maintain documentation and testing evidence supporting governance, regulatory, and audit requirements.
Disclaimer:
AI may be used in evaluating candidates.
This posting is for an existing vacancy.