IT Data Specialist

Work Location:

Toronto, Ontario, Canada

Hours:

37.5

Line of Business:

Technology Solutions

Pay Details:

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

Job Description:

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.

KEY ACCOUNTABILITIES

CUSTOMER

  • 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 on-going 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

SHAREHOLDER

  • 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

EMPLOYEE / TEAM

  • Work effectively as a team, supporting other members of the team in resolving critical service issues

  • Prioritize and manage own workload in order to deliver quality results and meet timelines

  • Support a positive work environment that promotes service to the business, quality, innovation and teamwork and ensure timely communication of issues/ points of interest.

  • Participate in knowledge transfer within the team and business units

  • Continuously enhance knowledge / expertise in own area and keep current with leading-edge technologies trends

  • Identify and recommend opportunities to enhance productivity, effectiveness and operational efficiency of the business unit and/or team

BREADTH & DEPTH

  • Subject Matter Expert on technical environment/ tools for own area

  • 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

EXPERIENCE & EDUCATION

  • Undergraduate degree or Technical Certificate

  • 7+ years relevant experience

  • Required experience with Azure Cloud Services, Python, Delta Lake and SQL

  • Preferred experience with Databricks andPySpark

Who We Are:

TD is one of the world's leading global financial institutions and is the fifth largest bank in North America by branches/stores. Every day, we strive to make every interaction, product, and experience remarkably human and refreshingly simple for over 27 million households and businesses in Canada, the United States and around the world. More than 95,000 TD colleagues bring their skills, talent, and creativity to foster deeper relationships, ensure disciplined execution, and build a simpler, faster banking experience. TD is deeply committed to being a leader in client experience, that is why we believe that all colleagues, no matter where they work, are client facing. Together, we are reimagining what banking can be for our clients, colleagues and communities.

Our Total Rewards Package

Our Total Rewards package reflects the investments we make in our colleagues to help them and their families achieve their financial, physical, and mental well-being goals. Total Rewards at TD includes a base salary, variable compensation, and several other key plans such as health and well-being benefits, savings and retirement programs, paid time off, banking benefits and discounts, career development, and reward and recognition programs. Learn more (

Additional Information:

We’re delighted that you’re considering building a career with TD. Through regular development conversations, training programs, and a competitive benefits plan, we’re committed to providing the support our colleagues need to thrive both at work and at home.

Please be advised that this job opportunity is subject to provincial regulation for employment purposes. It is imperative to acknowledge that each province or territory within the jurisdiction of Canada may have its own set of regulations, requirements.

Colleague Development

If you’re interested in a specific career path or are looking to build certain skills, we want to help you succeed. You’ll have regular career, development, and performance conversations with your manager, as well as access to an online learning platform and a variety of mentoring programs to help you unlock future opportunities.

If you’re passionate about helping clients and building deep, lasting relationships, TD offers diverse career paths where you can grow your expertise and make a meaningful impact.

We're committed to your success and foster a respectful workplace where diverse perspectives are valued, everyone has fair opportunities to grow, and you can unlock your full potential to achieve your career goals. Here at TD, we hire and develop the best.

Training & Onboarding

We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.

Interview Process

We’ll reach out to candidates of interest to schedule an interview. We do our best to communicate outcomes to all applicants by email or phone call.

Accommodation

Your accessibility is important to us. Please let us know if you’d like accommodations (including accessible meeting rooms, captioning for virtual interviews, etc.) to help us remove barriers so that you can participate throughout the interview process.

We look forward to hearing from you!

Language Requirement (Quebec only):

Sans Objet

Federal law prohibits job discrimination based on race, color, sex, sexual orientation, gender identity, national origin, religion, age, equal pay, disability and genetic information.

Back to blog

Other Jobs To Apply

No other job posts for this day.

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...