Back to search

Data Engineer

Supports data quality and controls development for an FCRM capability within a team of five.

  • Toronto, Ontario, Canada
  • Contract
  • Hybrid
  • CA$75–CA$90 per hour
  • Posted Nov 16, 2026
INDUSTRYSoftware & InternetData & Analytics

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.

Requirements

  • Post-secondary education
  • Experience in a Banking

Nice to have: Banking or financial institution experience, AML or FCRM experience

Skills

SQLdata profilingreconciliationtroubleshooting large datasetsdata quality testingdata analysisrule developmentroot-cause analysisCollibra

Full description

Data Engineer Location: Toronto, ON Onsite Flexibility Hybrid — 3 days in office, 2 days work from home (anchor days pod dependent) Contract Details Position Type: Contract Contract Duration: 6 months (with potential extension and conversion based on business needs and performance) Pay Rate: C$75.00–C$90.00 / Hour (CAD) Shift / Schedule: Monday–Friday, core business hours, 37.5 hours per week, 7.5 hours per day Travel Requirements: Not required Job Summary This role supports data quality and controls development for an FCRM (Financial Crime Risk Management) capability within a team of five. The contractor will work internally with TD stakeholders and will have access to customer data. The successful candidate will spend approximately 4 hours per day in meetings and will be expected to work independently in a fast-paced regulatory environment with aggressive delivery timelines. 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 Requirements 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 Required Skills Strong communication skills (written and verbal) Strong information gathering, reporting, and documentation skills Strong collaboration skills, team player mindset Takes initiative Preferred Skills Banking or financial institution experience AML or FCRM experience Education Requirements Post-secondary education is an asset Required Experience 8 years of overall experience in a relevant data-focused discipline About the Client This client is a leading financial services and banking institution operating across Canada and internationally, employing tens of thousands of professionals across technology, data, risk, and operations functions. The organization consistently ranks among the largest banks in North America and serves millions of customers across its network. Teams here include data engineers, solutions developers, IT specialists, risk and compliance professionals, and financial crime risk management experts who collaborate in agile, fast-paced environments focused on regulatory excellence and innovation. About GTT GTT is an NMSDC-certified Minority Business Enterprise (MBE) headquartered in Portsmouth, New Hampshire. GTT is a subsidiary of Chenega Corporation, an Alaska-based company and one of the largest Alaska Native-owned corporations. An Inc. 5000 honoree and one of SIA's Best Staffing Firms to Work For, GTT connects professionals with Fortune 500 organizations across IT, engineering, construction, utilities, life sciences, financial services, and healthcare throughout the U.S. and Canada. We're committed to diverse, inclusive workplaces and to placing people in roles where they can do their best work. Job Number: 26-19453 Industry: Data & Analytics #LI-Hybrid #LI-GTT #gttca

Data Engineer at GTT, LLC | Referso Jobs