Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM 59033 (Toronto)

Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM 59033 (Toronto)

19 Nov
|
S.I. Systems
|
Toronto

19 Nov

S.I. Systems

Toronto

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, cooperative 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 effective 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. #J-18808-Ljbffr

📌 Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM 59033 (Toronto)
🏢 S.I. Systems
📍 Toronto

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data engineer iv (8+ years of experience) to develop data quality rules and controls using sql for fcrm 59033 (toronto) / toronto

Subscribe to this job alert:

Get the latest job offers by email for: data engineer iv (8+ years of experience) to develop data quality rules and controls using sql for fcrm 59033 (toronto) / toronto