Back to search

Data Engineer

Data Engineer responsible for developing and implementing complex SQL-based data quality rules to support regulatory requirements in a banking environment.

  • Toronto, Ontario, Canada
  • Hybrid
  • Posted Nov 16, 2026
INDUSTRYFinance & AccountingFinancial Planning & Analysis

Responsibilities

  • Develop and implement complex SQL-based Data Quality rules supporting Customer Risk Rating and Transaction Monitoring regulatory requirements.
  • Write, test, validate, and troubleshoot SQL queries across large datasets to identify data quality issues, exceptions, and control failures.
  • Perform end-to-end validation of DQ rules, including source-to-target reconciliation, record-level analysis, expected-result validation, and investigation of failed records.
  • Translate business and data quality requirements into efficient SQL logic, ensuring rules accurately reflect documented requirements and acceptance criteria.
  • Troubleshoot data, rule-logic, and performance issues, perform root-cause analysis, and work with technical and business teams to resolve defects quickly.
  • Support the implementation and deployment of DQ rules into Collibra, including testing and validation before production rollout.
  • Work independently in a fast-paced regulatory environment with aggressive delivery timelines, managing multiple CRR and TM rules simultaneously.
  • Maintain appropriate documentation and testing evidence to support governance, regulatory, and audit requirements.

Requirements

  • Experience in a Banking
  • Experience in a financial institution
  • Experience in a AML
  • Experience in a FCRM

Skills

SQLcomplex joinsCTEssubqueriesaggregationswindow functionsdata profilingreconciliationtroubleshooting large datasetsdata quality testingdata analysisrule developmentroot-cause analysisCollibraSQLCollibra

Benefits

  • Health Benefits
  • Referral Program
  • Excellent growth and advancement opportunities

Full description

Our client, a Banking company, is looking for a Data Engineer for their Toronto, ON/ Hybrid location. Responsibilities: Develop and implement complex SQL-based Data Quality (DQ) rules supporting Customer Risk Rating (CRR) and Transaction Monitoring (TM) regulatory requirements. Write, test, validate, and troubleshoot SQL queries across large datasets to identify data quality issues, exceptions, and control failures. Perform end-to-end validation of DQ rules, including source-to-target reconciliation, record-level analysis, expected-result validation, and investigation of failed records. Translate business and data quality requirements into efficient SQL logic, ensuring rules accurately reflect documented requirements and acceptance criteria. Troubleshoot data, rule-logic, and performance issues, perform root-cause analysis, and work with technical and business teams to resolve defects quickly. Support the implementation and deployment of DQ rules into Collibra, including testing and validation before production rollout. Work independently in a fast-paced regulatory environment with aggressive delivery timelines, managing multiple CRR and TM rules simultaneously. Maintain appropriate documentation and testing evidence to support governance, regulatory, and audit requirements. Requirements: 8+ years of experience of Data Management experience 8+ years of experience using SQL including complex joins, CTEs, subqueries, aggregations, window functions, data profiling, reconciliation, and troubleshooting large datasets. 8+ years of data quality testing, data analysis, and SQL-based control/rule development Experience analyzing failed records and performing root-cause analysis across multiple data sources Strong communication skills (written and verbal) Strong information gathering, reporting and documentation skills Strong collaboration skills, team player mindset Takes initiative Banking or financial institution experience AML or FCRM experience Why Should You Apply? Health Benefits Referral Program Excellent growth and advancement opportunities

Data Engineer at ICONMA, LLC | Referso Jobs