IT Data Specialist

Base pay range

CA $80,000.00/yr - CA$/yr

Job Description:

We are looking for an IT Data Specialist for our Financial Crime & Risk Management systems (Oracle - Transaction Monitoring and Customer Risk Rating solutions). You will have the opportunity to engage in cross team initiatives beyond your immediate project to modernize the technology and capabilities to align with the portfolio and enterprise technology roadmaps.

The primary responsibility of our team is to design, develop and maintain the technology platform that processes the banks payments through behaviour detection algorithms to detect suspicious and fraudulent activity.

The open role is for a person who has 12 – 15+ years of working experience in leading complex data projects and is extremely familiar with Data concepts, translating business requirements into Functional specifications, Implementing Data Controls (including Data Quality and ETL controls), Investigating data issues across the data pipeline, Data Exception Management process, Data sourcing and further mapping to various interface across our Financial Crime & Risk Management (FCRM) systems.

The ideal candidate should also have good experience in SQL query optimization, stored procedures, and database design while also being proficient in Python scripting, automation, and data manipulation.

The ideal candidate will be part of the team that designs and maintains the data governance process to ensure data integrity is adhered to when payment and reference data information is sent to the FCRM systems. This also involves documenting and managing the development of relevant data quality controls and business logic validations and checks for the feeds that are sent to FCRM systems.

• Lead data initiatives within the FCRM team which requires extensive collaboration with multiple teams globally to gather business requirements on data and develop a tangible plan to execute these initiatives
• Lead business and technology discussions to develop and implement Data Quality requirements and data controls for FCRM systems
• Design and implement data controls and develop processes to ensure data integrity from source to target, i.e., ensuring data being sourced meets the data quality standards designed
• Design and implement data pipelines and ETL processes using Python and SQL
• Troubleshoot database and data pipeline issues efficiently.
• Independently perform data profiling, root cause analysis and analyze Source to Target Mappings documents, data dictionaries to identify data issues and assist with implementing feasible solutions post alignment with Business and Technology stakeholders
• Lead triage meetings globally and collaborate with required stakeholders to determine fix for data issues identified.
• Define metrics to measure the quality of data being obtained across source systems
• Automate data processing tasks and build scalable solutions
• Independently assess and further improve existing documentation to ensure end-to-end processes performed by the team is captured for traceability purpose.
• Collaborate with teams to integrate databases with applications and analytics platforms
• Foster an environment and culture that encourages productivity, innovation, process improvement, teamwork, and a high level of professionalism.

• University degree, preferably in technology/ data engineering
• Minimum of 10 years of AML transaction monitoring and/or KYC experience, preferably with large banks
• Minimum of 12+ years of experience in data (data lifecycle, data governance, data quality, Metadata, Data issue resolution, Root Cause analysis and other data concepts)
• Minimum of 12+ years of experience in data sourcing and mapping, preferably in systems which deal with Regulatory Compliance data
• Minimum of 12+ years of experience in PL/SQL, including query optimization, stored procedures, and indexing (Preferably in Oracle based tools)
• Strong experience in Python for data manipulation, scripting, and automation
• In-depth understanding of ETL requirements and processes that transform data from source. Good experience with designing ETL controls.…