AML Tech Data Control Developer

Job Description:

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 can't 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 a 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:

We are looking for an AML Data Controls Developer 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.

We are seeking an experienced developer (SQL, Python) who has a minimum of 12-15 years of experience designing, developing, and optimizing complex database solutions and data pipelines. The ideal candidate should 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 should collaborate with business teams, define data quality (DQ) requirements (validations, control checks) and the various business logic transformations to be done while sourcing data. The hire will be involved in designing and developing data controls using technology such as SQL and python to ensure that the integrity of the data feeding in is maintained.

The ideal candidate should also have experience in leading complex data projects and should be familiar with Data concepts, translating business requirements into System design specifications, Implementing ETL and/or Data Quality Controls to ensure data integrity from Source to Target, formalizing processes to manage data exceptions/anomalies, developing and analysing Source to Target Technical Metadata documents across our Financial Crime & Risk Management (FCRM) systems.

Meaningful work is fueled by meaningful performance and career development conversations with your manager. Here's some of what you may be asked to perform:

• 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 Data Quality requirements and controls for FCRM systems
• Lead the development work within the FCRM team which requires extensive collaboration with data engineers, software developers, data analyst, business teams globally to gather business requirements on data controls and develop a tangible plan to execute these initiatives
• Design, develop and maintain logic for data controls 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.
• Design and implement data pipelines and ETL processes using Python and SQL
• Improve database performance tuning, indexing, and partitioning strategies
• Collaborate with the Technology development and testing teams to ensure all data transformation logics are adequately developed and tested across 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 metrics to measure the quality of data being obtained across source systems
• Independently assess and further 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 10 years of AML transaction monitoring and/or KYC development experience, preferably with large banks
• Minimum of 10 - 12 years of experience in SQL development, including query optimization, stored procedures, and indexing.
• Minimum of 10+ years of experience in data (data lifecycle, data governance, data quality, Metadata, Data issue resolution, and other data concepts)
• Minimum of 10+ years of experience in data sourcing and mapping, preferably in systems which deal with Regulatory Compliance data
• Strong experience in Python for data manipulation, scripting, and automation
• Experience with relational databases (PostgreSQL, MySQL, SQL Server, Oracle) and NoSQL databases (MongoDB, Redis, etc.)
• Hands-on working experience in ETL frameworks and data pipeline orchestration (e.g., Apache Airflow, Prefect). Experience with informatica ETL tool is a big plus.
• Solid understanding of database architecture, normalization, and performance tuning
• Good understanding of Cloud platforms (AWS, Azure, GCP) and database management in a cloud environment
• Must be comfortable working in different time zones (SG, IN & US) as there would be an overlap with Singapore & India teams
• Excellent 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
• 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 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.

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

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, 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. Whether you have a passion for helping customers and want to expand your experience, or you want to coach and inspire your colleagues, there are many different career paths within our organization at TD - and we're committed to helping you identify opportunities that support your goals.

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!

Language Requirement (Quebec only):
Sans Objet