Data Engineer - Financial Crime Risk Management:
On behalf of our Banking client, Procom is searching for a Data Engineer - Financial Crime Risk Management for a 6-month role. This position is a hybrid position with 3 days onsite at our client’s Toronto office.
Data Engineer - Financial Crime Risk Management - Job Description:
The project focuses on enhancing data quality and controls for a Financial Crime Risk Management (FCRM) capability. The role involves developing and implementing complex SQL-based data quality rules to support regulatory requirements for Customer Risk Rating and Transaction Monitoring.
Data Engineer - Financial Crime Risk Management - 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.
Data Engineer - Financial Crime Risk Management - Mandatory Skills:
- 8+ years of experience in Data Management
- 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
Data Engineer - Financial Crime Risk Management – Nice-to-Have Skills:
- Banking or financial institution experience
- AML or FCRM experience
Data Engineer - Financial Crime Risk Management – Assignment Length:
This is a 6-month contract position with the possibility of extension based on business needs and performance.
Data Engineer - Financial Crime Risk Management - Start Date:
ASAP
Data Engineer - Financial Crime Risk Management - Assignment Location:
Toronto, Ontario, hybrid with 3 days in the office and 2 days work from home.