Apply now

Posted yesterday

SQL Data Quality Engineer

@ SPECTRAFORCE

Toronto, Ontario

Remote8+ years experience
Apply now
SIGNALS

Responsibilities:

  • For information on benefits, equal opportunity employment, and location-specific applicant notices, click here

Requirements summary:

  • •Develop and implement complex SQL-based Data Quality (DQ) rules supporting Customer Risk Rating (CRR) and Transaction Monitoring (TM) regulatory requirements.
  • •Translate business and data quality requirements into efficient SQL logic, ensuring rules accurately reflect documented requirements and acceptance criteria.
  • •Maintain appropriate documentation and testing evidence to support governance, regulatory, and audit requirements.
  • Must-have hard skills:
  • 1.) 8+ years of experience of Data Management experience
  • 2.) 8+ years of experience using SQL including complex joins, CTEs, subqueries, aggregations, window functions, data profiling, reconciliation, and troubleshooting large datasets.

Tools & skills

Source and dates

Source type not verified · spectraforce-careers

Employer posting date
2026-11-15
First seen by our source
2026-11-16
Source record updated
2026-11-16

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

FieldValue
HeadquartersRaleigh
Open jobs on Jobsy97
Job description

Role: SQL Data Quality Engineer
Duration 6 Months
Location: Toronto, ON -3 days in office, 2 days work from home

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:
1.) 8+ years of experience of Data Management experience
2.) 8+ years of experience using SQL including complex joins, CTEs, subqueries, aggregations, window functions, data profiling, reconciliation, and troubleshooting large datasets.
3.) 8+ years of data quality testing, data analysis, and SQL-based control/rule development
4.) Experience analyzing failed records and performing root-cause analysis across multiple data sources

Soft skills:
1.) Strong communication skills (written and verbal)
2.) Strong information gathering, reporting and documentation skills
3.) Strong collaboration skills, team player mindset
4.) Takes initiative

Nice-To-Have
1.) Banking or financial institution experience
2.) AML or FCRM experience

Applicant Notices & Disclaimers

  • For information on benefits, equal opportunity employment, and location-specific applicant notices, click here


At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. The pay rate for this position is C$70.00/hr.

Similar jobs

  • Sales Coordinator (Customer Service Representative)

    Toronto, ON
    HybridFull Time

    Quarterback Transportation: Quarterback Transportation is a dynamic and results-oriented company.

    2+ YOEBy joining Quarterback Transportation, you have the opportunity to learn from an industry leader where you will gain knowledge and skills to help you get to the next level; Other duties as required; 2 years of previous…

    Sales, Customer service, EDI, Auditing, TMS, Scheduling

  • Sr. Financial Analyst, Strong Roots

    Toronto, ON
    Full Time

    McCain Foods

    Bachelor’s degree in Finance, Accounting, Business, Economics, or a related field; 3+ years of experience in FP&A with a focus on supporting Commercial Finance (sales & marketing) or a similar finance business…

    Inventory Analyst

    Toronto, ON
    Full Time

    McCain Foods

    Bachelor’s degree in Business, Supply Chain Management, Operations Research, Industrial Engineering, or a related field from an accredited institution; Experience working with SAP S/4; experience with APO/SCM is…

    Senior Manager, Commercial Acceleration

    Toronto, ON
    Full Time

    McCain Foods

    Bachelor’s degree in Business, Marketing, Finance, Strategy, Operations, Supply Chain, or a related field; MBA or advanced degree is an asset; 7+ years of progressive experience in Commercial, Marketing, Strategy,…

    Project Manager, Commercial Acceleration

    Toronto, ON
    Full Time

    McCain Foods

    5+ YOEDevelop project plans including scope, timelines, milestones, resources, dependencies, risks, and governance requirements; Bachelor’s degree in Business, Marketing, Operations, Supply Chain, Engineering, Finance, or a…

    Supply chain management, Sales, Packaging, Communication skills, Project management, Program management

  • Keyholder

    Toronto, ON
    On-siteFull Time

    Mine & Yours

    1+ YOEAs a Keyholder, you will lead by example on the sales floor, support daily store operations, and help create an exceptional experience for every client; You are a part of every area of the retail store including client…

    Sales, Leadership, Retail operations, Sales targets, Coaching, Opening and closing procedures

  • Senior Account Manager, Portfolio Management, Commercial Finance Group (CFG)

    Toronto, ON
    HybridFull Time

    EQ Bank | Canada's Challenger Bank

    Work product must adhere to established policies and underwriting standards and meet compliance and control requirements; The incumbent must be able to manage multiple competing priorities in order to achieve…

    Bilingual Senior Account Manager, Portfolio Management

    Toronto, ON +1
    On-siteFull Time

    EQ Bank | Canada's Challenger Bank

    Work product must adhere to established policies and underwriting standards and meet compliance and control requirements; The incumbent must be able to manage multiple competing priorities in order to achieve…

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.