Data EngineerLocation: Toronto, ON
Onsite FlexibilityHybrid - 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 SummaryThis 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 ClientThis 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 GTTGTT 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