IT - Data Engineer IV
Community
·Today
- Salary
- C$80 – C$90/hr
- Location
- Toronto, Ontario, Canada
- Workplace
- Hybrid
- Type
- Contract
- Department
- Engineering
- Seniority
- Senior
- Experience
- 8+ years
- Closing date
- Today
Description
Location: Toronto, ON (Hybrid)
Estimated Duration: 6 Months
Key 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.
MUST-HAVE Hard Skills:
- 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
SOFT SKILLS:
- Strong communication skills (written and verbal)
- Strong information gathering, reporting and documentation skills
- Strong collaboration skills, team player mindset
- Takes initiative
NICE-TO-HAVE
- Banking or financial institution experience
- AML or FCRM experience