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
ICONMA, LLC
Company details are for members
Sign up for a free job alert to see ICONMA, LLC's profile, website and LinkedIn, and the same for every employer on Referso Jobs.