Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM 59033
S.I. Systems Ltd. Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM 59033
Summary
Six-month contract (extendable) Data Engineer IV placed by staffing firm S.I. Systems at a banking client. Day to day: develop and test complex SQL-based data quality rules and controls for Financial Crime Risk Management (Customer Risk Rating and Transaction Monitoring), perform reconciliation and root-cause analysis, and deploy rules into Collibra. Hybrid in Toronto, EST hours.
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.
AI may be used in evaluating candidates.
This posting is for an existing vacancy.
Skills
Sign in to read and join the discussion.