Work Location:Mount Laurel, New Jersey, United States of America
Hours:40
Pay Details:$91,000 - $136,240 USD
TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary range over time as they progress in their role. The base pay actually offered may vary based upon the candidate's skills and experience, job-related knowledge, geographic location, and other specific business and organizational needs.
As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role.
Line of Business:Technology Solutions
Job Description:The IT Data Specialist provides technical leadership across a broad range of data analysis functions including data modeling, structured query language (SQL), data quality, data profiling, extract-transform-load (ETL), metadata enrichment and management, data provenance and lineage, report design and other specialized data management functions. Works independently as a senior lead and may manage and direct activities related to analysis, design and support of technical data management solutions on various projects ranging in larger projects.
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 behavior detection algorithms to detect suspicious and fraudulent activity.
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.
Depth & Scope:- Subject Matter Expert on technical environment/ tools for own area of expertise
- Subject Matter Expert on business processes and procedures, as well as broader organizational issues and technology
- Advanced knowledge of business/ organization, Bank standards, infrastructure, architecture and technology in related areas from a design/ support/ solutions perspective
- Primary subject matter expert in multiple areas and consults with clients/or project teams with respect to all aspects of research, analysis, design, hardware/ software support and/or development of technical solutions
- Works autonomously as a senior/lead on a diverse range of tasks and is relied upon to coach/ educate others
- Manages and directs activities related to analysis, design and support of technical data management solutions on larger projects
- Assignments are highly complex and multi-faceted
- Acts as a key resource in the exchange of technical information for project teams, the business and/or outside vendors
- Generally reports to a Senior Manager or Executive
Education & Experience: - Undergraduate degree or Technical Certificate
- 5-7 years related experience
Preferred Qualifications:- University degree, preferably in technology/ data engineering
- Minimum of 5+ years of AML transaction monitoring experience, preferably with large banks
- Minimum of 5+ years of experience in data management (Hands-on experience in data profiling, designing, and developing data controls / Data quality rules across the data pipeline, Developing, and analyzing Source to Target mapping documents, Performing root cause analysis across data issues)
- Minimum of 5+ of experience in PL/SQL, including query optimization, stored procedures, and indexing (Preferably in Oracle based tools)
- Proven ability to run complex analytical queries directly against Azure Data Lake Storage (ADLS) using distributed query engines such as Azure Synapse Serverless SQL, Databricks SQL etc.
- Hands-on experience reading, writing, and transforming data in ADLS using PySpark, Pandas or Polars to perform data wrangling at scale.
- Experience with relational databases (PostgreSQL, MySQL, SQL Server, Oracle) and NoSQL databases (MongoDB, Redis, etc.)
- 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.
- Must be comfortable working in different time zones (SG, IN & US) as there would be an overlap with Singapore and India teams.
- 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.
Physical Requirements:Never: 0%; Occasional: 1-33%; Frequent: 34-66%; Continuous: 67-100%
- Domestic Travel - Occasional
- International Travel - Never
- Performing sedentary work - Continuous
- Performing multiple tasks - Continuous
- Operating standard office equipment - Continuous
- Responding quickly to sounds - Occasional
- Sitting - Continuous
- Standing - Occasional
- Walking - Occasional
- Moving safely in confined spaces - Occasional
- Lifting/Carrying (under 25 lbs.) - Occasional
- Lifting/Carrying (over 25 lbs.) - Never
- Squatting - Occasional
- Bending - Occasional
- Kneeling - Never
- Crawling - Never
- Climbing - Never
- Reaching overhead - Never
- Reaching forward - Occasional
- Pushing - Never
- Pulling - Never
- Twisting - Never
- Concentrating for long periods of time - Continuous
- Applying common sense to deal with problems involving standardized situations - Continuous
- Reading, writing and comprehending instructions - Continuous
- Adding, subtracting, multiplying and dividing - Continuous
The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties and skills required. The listed or specified responsibilities & duties are considered essential functions for ADA purposes.
