IT Data Specialist

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

Job summary

A leading staffing and consulting firm is hiring a Senior IT Data Specialist to work with a top banking client in Toronto. This role involves designing and implementing data controls for AML transaction monitoring and customer risk systems. Candidates should have 8+ years in data engineering, strong experience with PL/SQL and Python, and expertise in compliance systems. This position offers the chance to influence financial crime prevention technology in Canada’s banking sector.

Qualifications

• 8+ years leading complex data projects in enterprise environments.
• 8+ years in data lifecycle management including governance and quality.
• Deep understanding of payments flows and financial crime data.

Responsibilities

• Leading global data initiatives with cross-functional teams.
• Designing and implementing data governance processes and pipelines.
• Performing root-cause analysis on data issues and remediation.

Skills

Leading complex data projects

Data lifecycle management

Designing and implementing data controls

Advanced PL/SQL skills

Strong Python experience

Design and implement ETL processes

Understanding of payments flows

Hands-on experience with AML systems

Collaboration across time zones

Education

Degree in Computer Science, Data Engineering, or equivalent

Tools

Informatica

Hadoop

Spark

Snowflake

Azure

AWS

GCP

Job description

Required Experience & Skills

• 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

Nice to Have Skills & Experience

• Familiarity with big data technologies (Hadoop, Spark, Snowflake)
• Cloud database experience (Azure, AWS, GCP)
• Experience with payments settlement systems and messaging formats

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.