IT Data Specialist - Toronto, Canada - TD Bank

TD Bank

Verified Company

Toronto, Canada

1 week ago

Posted by:

Sophia Lee

beBee Recruiter

Description

401004BR

Technology Solutions

Toronto, ON

February 28, 2023

Company Overview

Department Overview

Building a World-Class Technology Team at TD
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 Data and Information Management covers building, developing, designing, and implementing involved with tech data management solutions. Where do we begin? These experts analyze, design, develop and support TD's info management system; lead and support bank data curation; develop data road map and info management strategies; focus on complex data integration, and drive use of our data reference model. This area doesn't work in isolation. We love data and we feel the same about integration and our assignments prove it.

There's room to grow in all of it.

Job Description:

About This Role
We need someone to provide technical leadership covering a range of data analysis functions.

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

You're a solid, independent, senior lead equipped to manage and direct activities related to analysis, design and support of technical data management solutions for larger projects.

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:

Elicit, analyze, interpret business and data requirements to develop complete business solutions, includes data models (entity relationship diagrams, dimensional data models), ETL and business rules, data management, governance, lineage, metadata and reporting elements.
Design, implement reporting platforms (e.g. modeling, ETL, BI framework) and complex ETL frameworks that meet business requirements. Work with technology/project teams to understand the business meaning of data, provide analysis and requirements so that data design is fully understood and the development initiatives are in line with intended design and standards.
Provide data analysis and requirements within enterprise platform (e.g. Hadoop).
Implement processes aligned to data management standards, ensure data quality and requirements are embedded in/adhered to within system development deliverables.
Develop, maintain knowledge of data available from upstream sources and data within various platforms.
Perform data profiling using TD tooling and ad hoc system query languages to validate data analysis.
Help development and testing teams resolve data issues.

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:

Undergraduate Degree or Technical Certificate.
7+ years relevant experience as a Database Designer/Data Modeler.
7+ years of experience with SQL
5+ years of experience with Oracle

- strong Database design skills

Experience with MS Azure is Preferred
Excellent analysis and problem solving ability.
Advanced knowledge of business, standards, infrastructure, architecture and technology in related areas from a design/ support/ solutions perspective.
Consult as an expert in multiple areas and consult with clients and project teams with respect to research, analysis, design, hardware/software support, solutions development, serve as a key resource for technical information exchange within project teams, with the business and outside vendors.
Ability to direct activities related to analysis, design and support of technical data management solutions on larger projects that are highly complex and multifaceted.

Additional Information

Join in on what others in TD Technology Solutions are doing:

Inspire a positive work environment and help champion quality, innovation, teamwork and service to the business.
Learn voraciously, stretch your thinking,

Hours

37.5

Inclusiveness

At TD, we are committed to fostering an inclusive, accessible environment, where all employees and customers feel valued, respected and supported.

We are dedicated to building a workforce that reflects the diversity of our customers and communities in which we live and serve.

If you require an accommodation for the recruitment/interview process (including alternate formats of materials, or accessible meeting rooms or other accommodation), please let us know and we will work with you to meet your needs.