[ref. m45820616] Toa Payoh - Sr. IT Data Analyst
Department Overview:
Residing within Enterprise Protect organization, the Financial Crime Risk Management (FCRM) Technology team is responsible for the delivery and support of technology solutions for the respective FCRM business unit. Given the ongoing pace of regulatory change and ongoing importance of risk management, this is a fast-growing area within the bank translating into considerable demand and growth within its technology teams.
Building a World-Class, Diverse and Inclusive Technology Team
We cannot afford to be boring. Neither can you. The scale and scope of what TD does may surprise you. The rapid pace of change makes it business imperative for us to be smart and open-minded in the way we think about technology. TD's technology and business teams become more intertwined as new opportunities present themselves.This new era in banking does not equal boring. Not at TD, anyway.
TD Applications & Systems Development covers technical planning, integration, systems analysis, design, development, unit, and component systems testing, support-maintenance, and more. Meaningful, effective relationship-building is part of what these highly skilled experts do best as they work together with technology project managers, delivery partners, business, and systems analysts, testing and quality assurance teams, sponsors and so many other stakeholders to clarify requirements.
Job Description:
About This Role
We are looking for a Senior IT Data Analyst 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 behavior detection algorithms to detect suspicious and fraudulent activity.
The person should have experience in complex data projects and is extremely familiar with Data concepts, translating business requirements into Functional specifications, Data Controls, and reconciliation (including Data Quality and ETL controls), Data Exception Management process, Data sourcing and further mapping to various interface across our Financial Crime & Risk Management (FCRM) systems.
The person will need to understand business needs, define data quality (DQ) requirements (validations, control checks) and the various business logic transformations to be done while sourcing data. The hire should acquire subject matter expertise pertaining to the Anti Money Laundering domain, would be required to work on DQ exception management processes and triage data quality issues with relevant stakeholders globally to remediate the same.The hire will also be part of the team that designs and maintains the data governance process to ensure that 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 checks and business logic validations across feeds that are sent to FCRM systems.
Meaningful work is fueled by meaningful performance and career development conversations with your manager. Here are some of the tasks that you may be asked to perform:
- Design and develop data controls and required processes to ensure data integrity from source to target, i.e., ensuring data being sourced meets the data quality standards that have been designed to ensure data is fit for FCRM purposes.
- Collaborate with the Technology development and testing teams to ensure all data transformation logics are adequately developed and tested across all required environments
- Independently analyze Source to Target Mappings documents, data dictionaries for root cause analysis and further business alignment
- Design, develop new processes and/or streamline existing processes to ensure exceptions are captured and there is adequate governance on Exception Management.
- Lead triage meetings globally and collaborate with required stakeholders to determine fix for data issues identified.
- Independently perform data profiling and end-to-end Root cause analysis across Data Issues identified and work with respective stakeholders as a part of the DQ Exception Management Process to remediate DQ issues.
- Define test scripts and cases for SIT, UAT and perform testing
- Improve existing documentation to ensure end-to-end processes performed by the team is captured for traceability purpose.
- Foster an environment and culture that encourages productivity, innovation, process improvement, teamwork, and a high level of professionalism.
Job Requirements:
What can you bring to TD? Share your credentials, but your relevant experience and knowledge can be just as likely to get our attention. It helps if you have:
- University degree, preferably in technology/ engineering
- Minimum of 8 years of banking experience in data sourcing and mapping, preferably in systems which deal with Regulatory Compliance data
- Minimum of 6 years of banking experience in data (data lifecycle, data governance, data quality, Metadata, Data issue Exception management and other data concepts)
- Must be comfortable working in different time zones (SG, IN & US) as there would be an overlap with India & US teams
- Advanced SQL & Python programming working experience (Preferably in Oracle based tools)
- In-depth understanding of ETL requirements and processes that transform data from source. Good experience with designing ETL controls. Experience with informatica ETL tool is a big plus.
- Good understanding of payments and data coming from settlement systems including the flow of funds, payment messaging formats such as Swift and systems such as ACH, Fedwire etc.
- Strong interpersonal skills with demonstrated ability to forge strong relationships with key business partners, understand financial markets and regulation and apply analytics to drive commercial value