IT Data Specialist

Work Location

Toronto, Ontario, Canada

37.5

Technology Solutions

$96,900 - $136,800 CAD

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  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.

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. 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.

• Elicit, analyze and understand business and data requirements to develop complete business solutions, including data models (entity relationship diagrams, dimensional data models), ETL and business rules, data life‑cycle management, governance, lineage, metadata and reporting elements.
• Apply automation and innovation on new data platforms and ongoing on any new development projects / initiatives aligned to business or organizational strategies.
• Design and implement reporting platforms, including modeling, ETL, BI framework and be able to deliver complete BI solution that meets business requirements.
• Design and implement complex ETL frameworks to provide a solution that meets business requirements.
• Collaborate and build effective working relationships with colleagues across technology and the business to achieve business and IT objectives.
• Work closely with various technology/project teams to understand the business meaning of data, and provide analysis and requirements to ensure the data design is fully understood and the development initiatives are in line with the intended design and standards.

• Coordinate with other technology work teams such as, ITS, Architecture, TRMIS etc. to ensure project success.
• Deliver Business or Enterprise Data deliverables for the various related platforms/servers/applications/systems and ensure adherence to Enterprise frameworks.
• Provide the data analysis and requirements within the enterprise platform (e.g. Hadoop).
• Implement processes aligned to data management standards and ensure data quality and data requirements are embedded in and adhered to within the system development deliverables.
• Develop and maintain knowledge of data available from upstream sources and data within various platforms.
• Collaborate with business and technology partners to elicit information/data requirement and articulate those requirements in a manner that can be easily understood by team members.
• May be responsible for the Information Excellence data deliverables including contribution to the overall project business and data requirements documents.
• Perform data profiling using TD tooling and ad hoc system query languages to validate data analysis.
• Provide support to the development and testing teams to resolve data issues.
• Support the user community by helping users interpret the data.
• Implement, maintain and enhance Data Governance, Data Quality and related policies, in alignment with TD's Enterprise standards and frameworks in collaboration with the Data Managers/Stewards/Owners.
• Ensure requirements are captured regarding privacy and security of data, data governance and access controls.
• Comply with well‑defined enterprise technology delivery practices and standards and project management disciplines.

• Work…