Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM 59033

S.I. Systems Ltd.

Toronto

Hybrid

CAD 100,000 - 130,000

Full time

2 days ago
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

S.I. Systems Ltd. is seeking a Data Quality Engineer IV with 8+ years of experience to develop SQL-based data quality rules and controls for FCRM.

The role supports CRR and Transaction Monitoring regulatory requirements and involves working in a hybrid Toronto environment with onboarding and data management training. Six-month contract with potential extension. Join a small, collaborative team and contribute to data governance, rule testing, and production readiness, with emphasis on end-to-end

Qualifications

  • 8+ years in Data Management required.
  • 8+ years using SQL with complex joins, CTEs, subqueries, aggregations and window functions.
  • 8+ years in data quality testing and SQL-based rule development.
  • Root-cause analysis across multiple data sources and failed-record analysis.

Responsibilities

  • Develop complex SQL-based Data Quality rules supporting CRR and TM regulatory requirements.
  • Test SQL queries across large datasets to identify data quality issues and control failures.
  • Validate DQ rules end to end through reconciliation and investigation of failed records.
  • Translate business and data quality requirements into efficient SQL logic aligned with requirements and acceptance criteria.
  • Troubleshoot data, rule-logic, and performance issues with technical and business teams.
  • Support DQ rule deployment into Collibra with testing and validation before production rollout.
  • Maintain documentation and testing evidence for governance and audit purposes.

Skills

Data Management
SQL
data quality testing
Root-cause analysis

Education

Post-secondary education

Tools

Collibra

Job description

Data Quality Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM 59033

Our banking client is seeking a Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM

Support data quality and controls for an FCRM capability, with SQL-based rules addressing Customer Risk Rating (CRR) and Transaction Monitoring (TM) regulatory requirements. Join a five-person team in a positive, collaborative work environment, with onboarding and FCRM data management training. This six-month contract offers potential extension or conversion based on business needs and performance.

Contract, Toronto, Hybrid, Working Hours: EST

Must Haves
  • 8+ years in Data Management.
  • 8+ years using SQL, including complex joins, CTEs, subqueries, aggregations, window functions, data profiling, reconciliation, and troubleshooting large datasets.
  • 8+ years in data quality testing, data analysis, and SQL-based control/rule development.
  • Root-cause analysis across multiple data sources, including analysis of failed records.
Nice to Have
  • Banking or financial institution experience.
  • AML or FCRM experience.
  • Post-secondary education.
Responsibilities
  • Develop complex SQL-based Data Quality (DQ) rules supporting CRR and TM regulatory requirements.
  • Test SQL queries across large datasets to identify data quality issues, exceptions, and control failures.
  • Validate DQ rules end to end through source-to-target reconciliation, record-level analysis, expected-result validation, and failed-record investigation.
  • Translate business and data quality requirements into efficient SQL logic aligned with documented requirements and acceptance criteria.
  • Troubleshoot data, rule-logic, and performance issues through root-cause analysis and defect resolution with technical and business teams.
  • Support DQ rule implementation and deployment into Collibra, including testing and validation before production rollout.
  • Maintain documentation and testing evidence supporting governance, regulatory, and audit requirements.

Our banking client is seeking a Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM

Support data quality and controls for an FCRM capability, with SQL-based rules addressing Customer Risk Rating (CRR) and Transaction Monitoring (TM) regulatory requirements. Join a five-person team in a positive, collaborative work environment, with onboarding and FCRM data management training. This six-month contract offers potential extension or conversion based on business needs and performance.

Contract, Toronto, Hybrid, Working Hours: EST

Must Haves
  • 8+ years in Data Management.
  • 8+ years using SQL, including complex joins, CTEs, subqueries, aggregations, window functions, data profiling, reconciliation, and troubleshooting large datasets.
  • 8+ years in data quality testing, data analysis, and SQL-based control/rule development.
  • Root-cause analysis across multiple data sources, including analysis of failed records.
Nice to Have
  • Banking or financial institution experience.
  • AML or FCRM experience.
  • Post-secondary education.
Responsibilities
  • Develop complex SQL-based Data Quality (DQ) rules supporting CRR and TM regulatory requirements.
  • Test SQL queries across large datasets to identify data quality issues, exceptions, and control failures.
  • Validate DQ rules end to end through source-to-target reconciliation, record-level analysis, expected-result validation, and failed-record investigation.
  • Translate business and data quality requirements into efficient SQL logic aligned with documented requirements and acceptance criteria.
  • Troubleshoot data, rule-logic, and performance issues through root-cause analysis and defect resolution with technical and business teams.
  • Support DQ rule implementation and deployment into Collibra, including testing and validation before production rollout.
  • Maintain documentation and testing evidence supporting governance, regulatory, and audit requirements.
Disclaimer:
AI may be used in evaluating candidates.
This posting is for an existing vacancy.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Quality Engineer - SQL Rules for Banking
Senior Data Quality Engineer - SQL Rules for Banking

S.I. Systems Ltd. • Toronto

Hybrid
CAD 100,000 - 130,000
Data Engineer
Data Engineer

Global Technical Talent, Inc. • Toronto

Hybrid
CAD 103,000 - 124,000
Finance Business & Data Analyst
Finance Business & Data Analyst

Infotree Global Solutions • Montreal

On-site
CAD 65,000 - 90,000
Finance Business & Data Analyst
Finance Business & Data Analyst

eTeam • Montreal

On-site
CAD 85,000 - 110,000
Business Data Analyst
Business Data Analyst

HireTalent • Montreal

Hybrid
CAD 85,000 - 110,000
Finance Business Analyst
Finance Business Analyst

Axelon Services Corporation • Montreal

On-site
CAD 65,000 - 90,000
Data Quality Analyst
Data Quality Analyst

TEEMA Group • Victoria

On-site
CAD 91,000 - 129,000
IT Data Specialist
IT Data Specialist

Insight Global (United States) • Toronto

On-site
CAD 100,000 - 120,000
Data Quality Analyst - Advanced- 186132-1
Data Quality Analyst - Advanced- 186132-1

Randstad Canada • Toronto

On-site
CAD 90,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