IT Data Specialist

IT Data Specialist at TD

Residing within the Enterprise Protect organization, the Financial Crime & Risk Management (FCRM) Technology team at TD is responsible for the delivery and support of technology solutions for the respective FCRM business unit. Given the ongoing pace of regulatory change and the 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 is a core focus. The scale and scope of what TD does may surprise you, and the rapid pace of change makes it imperative to be smart and open-minded in technology. TD's technology and business teams are increasingly intertwined as new opportunities arise, making banking at TD anything but boring.

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 paramount as experts collaborate with technology project managers, developers, delivery partners, business and systems analysts, testing and quality assurance teams, sponsors, and other stakeholders to clarify requirements.

About This Role

We are looking for an IT Data Specialist for our Financial Crime & Risk Management systems, specifically 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 technology and capabilities, aligning with portfolio and enterprise technology roadmaps.

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

This open role is for an individual with 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 interfaces 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.

Here Are Some Of The Tasks That You May Be Asked To Perform

• Lead data initiatives within the FCRM team, requiring extensive global collaboration to gather business requirements and develop tangible execution plans.
• 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, ensuring sourced data meets designed quality standards.
• 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 and 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 fixes for identified data issues.
• 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 are captured for traceability.
• 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.

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/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. Experience with Informatica ETL tool is a big plus.
• Exceptional 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.
• Must be comfortable working in different time zones (SG, IN & US) as there would be an overlap with Singapore and India teams.
• Experience working with big data technologies (Hadoop, Spark, Snowflake, etc.) is a plus.
• Strong people skills with demonstrated ability to forge strong relationships with key business partners, understand financial markets and regulation, and apply analytics to drive commercial value.
• Experience in Oracle AML product development and customization would be highly preferred.

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 strive to make every interaction, product, and experience remarkably human and refreshingly simple for 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 foster deeper relationships, ensure disciplined execution, and build a simpler, faster banking experience. TD is deeply committed to being a leader in client experience, which is why we believe that all colleagues, no matter where they work, are client facing. Together, we are reimagining what banking can be for our clients, colleagues, and communities.

Our Total Rewards Package

Our Total Rewards package reflects the investments we make in our colleagues to help them and their families achieve their financial, physical, and mental well-being goals. Total Rewards at TD includes a base salary, variable compensation, and several other key plans such as health and well-being benefits, savings and retirement programs, paid time off, banking benefits and discounts, career development, and reward and recognition programs. Learn more about our comprehensive benefits.

Additional Information

We’re delighted that you’re considering building a career with TD. Through regular development conversations, training programs, and a competitive benefits plan, we’re committed to providing the support our colleagues need to thrive both at work and at home. Please be advised that this job opportunity is subject to provincial regulation for employment purposes. It is imperative to acknowledge that each province or territory within the jurisdiction of Canada may have its own set of regulations and requirements.

Colleague Development

If you’re interested in a specific career path or are looking to build certain skills, we want to help you succeed. You’ll have regular career, development, and performance conversations with your manager, as well as access to an online learning platform and a variety of mentoring programs to help you unlock future opportunities. If you’re passionate about helping clients and building deep, lasting relationships, TD offers diverse career paths where you can grow your expertise and make a meaningful impact. We're committed to your success and foster a respectful workplace where diverse perspectives are valued, everyone has fair opportunities to grow, and you can unlock your full potential to achieve your career goals. Here at TD, we hire and develop the best.

Training & Onboarding

We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.

Interview Process

We’ll reach out to candidates of interest to schedule an interview. We do our best to communicate outcomes to all applicants by email or phone call.

Accommodation

Your accessibility is important to us. Please let us know if you’d like accommodations (including accessible meeting rooms, captioning for virtual interviews, etc.) to help us remove barriers so that you can participate throughout the interview process.

We look forward to hearing from you!

Key skills/competency

• Data Governance
• ETL Processes
• SQL Optimization
• Python Scripting
• AML Transaction Monitoring
• KYC Compliance
• Financial Crime Risk Management
• Oracle Database
• Data Quality Controls
• Root Cause Analysis