Skip to content
Solutions Design IT Specialist – Data
| Company | TD Bank |
|---|
| Location | Toronto, ON, Canada |
|---|
| Salary | $91200 – $136800 |
|---|
| Type | Full-Time |
|---|
| Degrees | Bachelor’s |
|---|
| Experience Level | Expert or higher |
|---|
Requirements
- Undergraduate degree or Technical Certificate
- Minimum 10 years of hands-on experience as a senior/lead data engineer or data architect
- 2-4 years of Cloud Data Solution experience
- Expert knowledge of data modeling, e.g. relational, dimensional and hierarchical
- Expert knowledge of platform and data warehouse design and principles
- Expert knowledge of System integration via REST API, SOAP, Kafka Streaming, MQ, Topic, MFTP, API Gateway, and enterprise service bus
- In depth Experience in working on data integration projects or large scale, complex technology projects using formal project delivery methodology
Responsibilities
- Provide 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
- Facilitate and document current/future data architecture to ensure effects of data are understood and communicated across all project stakeholders
- Work effectively with multiple teams across a broad spectrum of initiatives and functional domains, influencing and aligning others as needed
- Develop new standards for Data documentation for use by projects
- Collaborating with Developers and Solutions Architects in all phases of the development lifecycle
- Merging project solutions with enterprise architecture
- Conducting research and assessment of options for technical design issues
- Solving problems in detail design document
- Recognizing issues and developing solutions
- Working with operations teams and providing documentation, training, production support, root cause analysis, and issue resolution
- Troubleshooting and debugging issues related to data integrations, including ETL, API and messaging.
Preferred Qualifications
- Graduate degree preferred
- Hands-on experience working with SQL language to carry-on daily data profiling and data quality is considered an asset
- Good understanding of MDM concept
- Knowledge of Fraud domain data and systems considered an asset
- Knowledge of industry model, e.g. FSDM considered an asset
