Data Engineer - Financial Crime Risk Management

Procom

Toronto

Hybrid

CAD 110,000 - 160,000

Full time

46 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Procom is seeking a Data Engineer for Financial Crime Risk Management in a 6-month hybrid role in Toronto. You will develop and validate SQL-based data quality rules to support Customer Risk Rating and Transaction Monitoring, ensuring regulatory compliance.

You will perform source-to-target reconciliations, troubleshoot data issues, and collaborate with data and business teams to resolve defects quickly. Start ASAP; 3 days in-office, 2 days remote.

Qualifications

  • 8+ years of experience in Data Management.
  • 8+ years of experience using SQL including complex joins, CTEs, subqueries, aggregations, window functions, data profiling, reconciliation.
  • 8+ years of data quality testing, data analysis, and SQL-based 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.

Responsibilities

  • Develop and implement complex SQL-based Data Quality rules supporting CRR and 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 reflect acceptance criteria.
  • Troubleshoot data, rule-logic, and performance issues; perform root-cause analysis; resolve defects with technical and business teams.
  • Support 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.
  • Maintain documentation and testing evidence to support governance, regulatory, and audit requirements.

Skills

SQL
Data Quality
Data Management
Regulatory
Root Cause Analysis
Collaboration
Documentation
Communication

Tools

Collibra

Job description

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 mindsetData Engineer - Financial Crime Risk Management – Nice-to-Have Skills:• Banking or financial institution experience• AML or FCRM experienceData 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:ASAPData Engineer - Financial Crime Risk Management - Assignment Location:Toronto, Ontario, hybrid with 3 days in the office and 2 days work from home.This posting is for an existing vacancy.This employer uses both human and technology-assisted tools to support candidate screening and assessment. Final hiring decisions are made by people.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Hybrid Data Engineer – Financial Crime Risk (SQL, CRR/TM)
Hybrid Data Engineer – Financial Crime Risk (SQL, CRR/TM)

Procom • Toronto

Hybrid
CAD 110,000 - 160,000
Data Engineer
Data Engineer

Global Technical Talent, Inc. • Toronto

Hybrid
CAD 103,000 - 124,000
IT Data Specialist
IT Data Specialist

Insight Global (United States) • Toronto

On-site
CAD 100,000 - 120,000
Data Engineer- AML and Payment domain
Data Engineer- AML and Payment domain

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 90,000 - 120,000
Finance Business & Data Analyst
Finance Business & Data Analyst

eTeam • Montreal

On-site
CAD 85,000 - 110,000
Senior Data Developer
Senior Data Developer

Procom • Canada

Remote
CAD 110,000 - 150,000
Développeur ingénierie de données
Développeur ingénierie de données

Procom • Montreal

Hybrid
CAD 110,000 - 150,000
Data Systems Engineer—IT & Analytics
Data Systems Engineer—IT & Analytics

Insight Global (United States) • Toronto

On-site
CAD 100,000 - 120,000
Senior Data Management & AML Risk Specialist
Senior Data Management & AML Risk Specialist

TD Bank Group • Toronto

On-site
CAD 97,000 - 137,000
Intermediate Data Engineer ( SQL, Databricks/ Snowflakes, DBT, Airflow)
Intermediate Data Engineer ( SQL, Databricks/ Snowflakes, DBT, Airflow)

Talent To Hire Inc. • Toronto

Hybrid
CAD 80,000 - 100,000