Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

S.I. Systems Ltd.

NewBe an early applicant

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

Posted

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.
Disclaimer:
AI may be used in evaluating candidates.
This posting is for an existing vacancy.

Skills

Apply

See also

Data Engineering jobs by country — openings, pay and top skills →