Job Title: IT – Data Engineer IV
Location: Toronto, ON (Hybrid)
Estimated Duration: 6 Months
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 Hard Skills:
- 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
SOFT SKILLS:
- Strong communication skills (written and verbal)
- Strong information gathering, reporting and documentation skills
- Strong collaboration skills, team player mindset
- Takes initiative
NICE-TO-HAVE
- Banking or financial institution experience
- AML or FCRM experience
The pay range that the employer reasonably expects to pay for this position is between CA$80.00 and CA$90.00
Our voluntary benefits offering includes medical, dental, vision and retirement benefits.
This posting is for an existing vacancy.
If you believe this post to be fraudulent, please report by clicking here
Tundra Technical Solutions is a global workforce and technology delivery firm, ranked by Staffing Industry Analysts as one of the largest in North America. At Tundra, we aren't just hiring top talent at the world's most recognizable brands; we are pioneers of social recruitment. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other legally protected characteristics. We welcome and encourage diversity in the workplace.
We use artificial intelligence tools to help our recruiters screen and assess talent. These tools do not replace human decision making in the process.
Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!