The IT Data Specialist role at TD is needed to provide technical leadership for data analysis functions, specifically focusing on AML Process enhancement within the bank using Microsoft Azure technology, Databricks, Python, and SQL.
Requirements
- Proficiency in SQL and Python
- Understanding of Data Models and ability to create Basic Data Models
- Experience in analyzing and performance tuning SQL queries.
- Strong experience with relational databases such as SQL Server, Synapse Dedicated Pool, or Oracle.
- Drive to uplift knowledge and support for Unity Catalog and Databricks Lakehouse
- Expert knowledge of data engineering frameworks, technologies, tools, processes, patterns, and procedures, including how they impact and integrate with other technology areas such as Architecture or Infrastructure
- Performs highly complex technical tasks independently
Responsibilities
- 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.
- Subject Matter Expert on technical environment/ tools for own area of expertise
- 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
- Manages and directs activities related to analysis, design and support of technical data management solutions on larger projects
- Designs and develops to meet business and technical requirements; analyzes, adapts, integrates, codes, tests, debugs, and executes
- Uses and evolves established patterns to solve complex problems; leads the development of new patterns where necessary
Other
- Undergraduate degree or Technical Certificate
- 5-7 years related experience
- Good experience in Banking/Financial Domain
- Strong analytical and problem-solving abilities to troubleshoot and resolve database-related issues.
- Participate fully as a member of the team, support a positive work environment that promotes service to the business, quality, innovation and teamwork and ensure timely communication of issues/ points of interest
