Data Engineer
ICONMA, LLC · Posted Nov 16, 2026
- Toronto, Ontario, Canada
- Hybrid
- Senior
- 8+ years
Data Engineer responsible for developing and implementing complex SQL-based data quality rules to support regulatory requirements in a banking environment.
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.