In short
Six-month contract Data Engineer IV joining a five-person team to build and deploy SQL-based data quality rules and controls for a bank's Financial Crime Risk Management (Customer Risk Rating and Transaction Monitoring), including testing, reconciliation, and rollout into Collibra. Hybrid in Toronto, EST hours.
About the role
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.
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.