Sr. IT Data Analyst

at  TD Bank

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 experience in data (data lifecycle, data governance, data quality, Metadata, Data issue Exception management and other data concepts)
• Minimum of 8 years of experience in data sourcing and mapping, preferably in systems which deal with Regulatory Compliance data.
• 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

WHO WE ARE

TD is one of the world’s leading global financial institutions and is the fifth largest bank in North America by branches/stores. Every day, we deliver legendary customer experiences to over 27 million households and businesses in Canada, the United States and around the world. More than 95,000 TD colleagues bring their skills, talent, and creativity to the Bank, those we serve, and the economies we support. We are guided by our vision to Be the Better Bank and our purpose to enrich the lives of our customers, communities and colleagues.
TD is deeply committed to being a leader in customer experience, that is why we believe that all colleagues, no matter where they work, are customer facing. As we build our business and deliver on our strategy, we are innovating to enhance the customer experience and build capabilities to shape the future of banking. Whether you’ve got years of banking experience or are just starting your career in financial services, we can help you realize your potential. Through regular leadership and development conversations to mentorship and training programs, we’re here to support you towards your goals. As an organization, we keep growing – and so will you.

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 open role is for a person who has 10 - 12 years of working 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.