IT Data Specialist

Insight Global; Toronto; On-site; CAD 100,000 - 130,000; Full time

Job summary

A top financial services company in Toronto is seeking a Senior IT Data Specialist to enhance financial crime prevention technology. Key tasks include leading data initiatives, implementing governance processes, and optimizing data pipelines for compliance systems. The ideal candidate has over 8 years of experience in data engineering, robust AML knowledge, and proficiency in PL/SQL and Python. Join a dynamic team committed to diversity and inclusion within one of Canada's leading banks.

Qualifications

• 8+ years leading complex data projects in enterprise environments.
• 8+ years in data lifecycle management including governance, quality, metadata.
• Advanced PL/SQL skills for performance tuning.

Responsibilities

• Leading global data initiatives and collaborating with teams.
• Designing and implementing data governance processes.
• Building Python/SQL validation logic and optimizing performance.

Skills

Leading complex data projects

Data lifecycle management

Designing and implementing data controls

PL/SQL query optimization

Python for data manipulation

Designing ETL processes

Understanding payments flows

AML transaction monitoring

Working across global time zones

Degree in Computer Science or Data Engineering

Cloud database experience

Education

Degree in Computer Science, Data Engineering, or equivalent

Tools

Informatica

Azure

AWS

GCP

Hadoop

Spark

Snowflake

Job description

Job Description

Insight Global is hiring a senior IT Data Specialist to join a top 5 banking client in their Financial Crime & Risk Management (FCRM) Technology team. This role focuses on designing, developing, and maintaining critical data controls and pipelines that power AML transaction monitoring and customer risk rating systems—ensuring data integrity, quality, and regulatory compliance at scale.

Key responsibilities include:

• Leading global data initiatives and collaborating with cross-functional teams to gather requirements and define data quality standards

• Designing and implementing data governance processes, ETL pipelines, and source-to-target controls

• Building Python/SQL validation logic, optimizing database performance, and managing exceptions

• Performing root-cause analysis on data issues and driving remediation strategies

• Documenting processes for traceability and compliance

• Working closely with AML platforms and payment systems to ensure accurate and timely data flow

Ideal candidates will have extensive experience in data engineering for compliance systems, strong AML/regulatory knowledge, and proven leadership in data quality initiatives. This high-impact role offers the opportunity to shape enterprise-grade financial crime prevention technology within one of Canada’s leading banks.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail]. To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• 8+ years leading complex data projects in enterprise environments

• 8+ years in data lifecycle management: governance, quality, metadata, exception handling, root-cause analysis

• 8+ years designing and implementing source-to-target data controls and validations for compliance/regulatory systems

• Advanced PL/SQL skills (query optimization, stored procedures, indexing, partitioning, performance tuning)

• Strong Python experience for data manipulation, automation, ETL logic, and data quality controls

• Proven ability to design and implement ETL processes and controls (Informatica experience is a plus)

• Deep understanding of payments flows (SWIFT, ACH, Fedwire) and financial crime/risk data

• Hands‑on experience with AML transaction monitoring and/or KYC systems in large banks

• Comfortable working across global time zones (overlap with Singapore & India)

• Degree in Computer Science, Data Engineering, or equivalent - Familiarity with big data technologies (Hadoop, Spark, Snowflake)

• Cloud database experience (Azure, AWS, GCP)

• Experience with payments settlement systems and messaging formats