Job Description
Full job description
Work Location:
Toronto, Ontario, Canada
Hours:
37.5
Line of Business:
Technology Solutions
Pay Details:
$76,800 - $115,200 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:
What you’ll be doing
Reporting to the Senior manager Core Platform, the DE will support the core capabilities and features of Fraud's data lake platform. Responsibilities will include assisting front line support with trouble shooting complex issues, development of ETL Frameworks, real time pipelines, and ensuring high quality and trusted data is available and accessible to Fraud Performance Management team to make informed business decisions on our registrants. The DE is responsible for working with data and product owners and various stakeholders from the business, IT and external teams to ensure successful delivery of the Data Projects.
Scope and Complexity
The DE is responsible for developing and maintaining data pipelines in Azure data platform, designing, and managing data repositories, lakes and data warehouse. The DE supports the data governance and data quality strategies on the operational level maintaining the various artifacts on the data assets, including the data dictionary, lineage, ownership and business rules.
The DE works closely with the other data engineers and the data analysts (DA), business analysts (BA), product owners, IT and business SME’s. Specifically, for the Data migration project, the DE designs the source to target mapping, extracts the data from the current systems, transforms and loads the data into the new cloud-based solution. The DE also works closely with the Application and QA teams to validate the data ensuring quality and alignment with the data architecture.
Duties/Accountabilities
Provide Level 4 support for ETL process, real time pipelines, reporting data marts across Fraud's data lake platform.
Responsible for designing, building, and maintaining secure and compliant data processing pipelines using various Microsoft Azure data services and frameworks including but not limited to Azure Databricks, Data factory, ADLS Storage, PySpark.
Build reporting and analytical tools to utilize the data pipeline, provide actionable insight into key business performance metrics.
Design, implement, and maintain data pipelines for data ingestion, processing, and transformation in Microsoft Azure Cloud.
Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and/or Azure Blob Storage.
Utilize Azure Data Factory or comparable technologies, create and maintain ETL (Extract, Transform, Load) operations.
Implement data validation and cleansing procedures to ensure the quality, integrity, and dependability of the data.
Improve the scalability, efficiency, and cost-effectiveness of data pipelines.
Monitor and resolve data pipeline problems to ensure consistency and availability of the data.
Identify, design, and implement internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
Adapt and learn new technologies per business requirements.
Ensure compliance with data governance, privacy and security policies.
Fosters and maintains an organizational culture that promotes equity, diversity and inclusion, mutual respect, teamwork, and service excellence.
Qualifications
A bachelor’s degree in computer science or other quantitative field plus relevant experience.
Minimum 5 years experience working with relational and distributed databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Advanced experience programming ETL code, building and optimizing data pipelines, architectures, and datasets using Microsoft Azure technologies including Azure Databricks, Azure Data Factory, Spark, and Python.
Experience with data migration projects within a Microsoft and Azure
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Strong analytic skills related to working with unstructured datasets.
A successful history of manipulating, processing, and extracting value from large, disconnected datasets.
Ability to plan, prioritize and manage workload within a time sensitive environment.
Excellent oral, written, and interpersonal communication skills. Ability to use audience appropriate communication and language to present information, analyze results and convey concepts.
Ability to work outside of regular work hours, on occasion, to ensure the smooth functioning of Fraud related systems.
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 deliver legendary customer experiences to over 27 million households and businesses in Canada, the United States and around the world. More than +5,000 TD colleagues bring their skills, talent, and creativity to the Bank, those we serve, and the economies we support. We are guided by our vision to Be the Better Bank and our purpose to enrich the lives of our customers, communities and colleagues.
TD is deeply committed to being a leader in customer experience, that is why we believe that all colleagues, no matter where they work, are customer facing. As we build our business and deliver on our strategy, we are innovating to enhance the customer experience and build capabilities to shape the future of banking. Whether you’ve got years of banking experience or are just starting your career in financial services, we can help you realize your potential. Through regular leadership and development conversations to mentorship and training programs, we’re here to support you towards your goals. As an organization, we keep growing – and so will you.
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. Whether you have a passion for helping customers and want to expand your experience, or you want to coach and inspire your colleagues, there are many different career paths within our organization at TD – and we’re committed to helping you identify opportunities that support your goals.
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
You must create an Indeed account before continuing to the company website to apply
Work Location:
Toronto, Ontario, Canada
Hours:
37.5
Line of Business:
Technology Solutions
Pay Details:
$76,800 - $115,200 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:
What you’ll be doing
Reporting to the Senior manager Core Platform, the DE will support the core capabilities and features of Fraud's data lake platform. Responsibilities will include assisting front line support with trouble shooting complex issues, development of ETL Frameworks, real time pipelines, and ensuring high quality and trusted data is available and accessible to Fraud Performance Management team to make informed business decisions on our registrants. The DE is responsible for working with data and product owners and various stakeholders from the business, IT and external teams to ensure successful delivery of the Data Projects.
Scope and Complexity
The DE is responsible for developing and maintaining data pipelines in Azure data platform, designing, and managing data repositories, lakes and data warehouse. The DE supports the data governance and data quality strategies on the operational level maintaining the various artifacts on the data assets, including the data dictionary, lineage, ownership and business rules.
The DE works closely with the other data engineers and the data analysts (DA), business analysts (BA), product owners, IT and business SME’s. Specifically, for the Data migration project, the DE designs the source to target mapping, extracts the data from the current systems, transforms and loads the data into the new cloud-based solution. The DE also works closely with the Application and QA teams to validate the data ensuring quality and alignment with the data architecture.
Duties/Accountabilities
Provide Level 4 support for ETL process, real time pipelines, reporting data marts across Fraud's data lake platform.
Responsible for designing, building, and maintaining secure and compliant data processing pipelines using various Microsoft Azure data services and frameworks including but not limited to Azure Databricks, Data factory, ADLS Storage, PySpark.
Build reporting and analytical tools to utilize the data pipeline, provide actionable insight into key business performance metrics.
Design, implement, and maintain data pipelines for data ingestion, processing, and transformation in Microsoft Azure Cloud.
Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and/or Azure Blob Storage.
Utilize Azure Data Factory or comparable technologies, create and maintain ETL (Extract, Transform, Load) operations.
Implement data validation and cleansing procedures to ensure the quality, integrity, and dependability of the data.
Improve the scalability, efficiency, and cost-effectiveness of data pipelines.
Monitor and resolve data pipeline problems to ensure consistency and availability of the data.
Identify, design, and implement internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
Adapt and learn new technologies per business requirements.
Ensure compliance with data governance, privacy and security policies.
Fosters and maintains an organizational culture that promotes equity, diversity and inclusion, mutual respect, teamwork, and service excellence.
Qualifications
A bachelor’s degree in computer science or other quantitative field plus relevant experience.
Minimum 5 years experience working with relational and distributed databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Advanced experience programming ETL code, building and optimizing data pipelines, architectures, and datasets using Microsoft Azure technologies including Azure Databricks, Azure Data Factory, Spark, and Python.
Experience with data migration projects within a Microsoft and Azure
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Strong analytic skills related to working with unstructured datasets.
A successful history of manipulating, processing, and extracting value from large, disconnected datasets.
Ability to plan, prioritize and manage workload within a time sensitive environment.
Excellent oral, written, and interpersonal communication skills. Ability to use audience appropriate communication and language to present information, analyze results and convey concepts.
Ability to work outside of regular work hours, on occasion, to ensure the smooth functioning of Fraud related systems.
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 deliver legendary customer experiences to over 27 million households and businesses in Canada, the United States and around the world. More than +5,000 TD colleagues bring their skills, talent, and creativity to the Bank, those we serve, and the economies we support. We are guided by our vision to Be the Better Bank and our purpose to enrich the lives of our customers, communities and colleagues.
TD is deeply committed to being a leader in customer experience, that is why we believe that all colleagues, no matter where they work, are customer facing. As we build our business and deliver on our strategy, we are innovating to enhance the customer experience and build capabilities to shape the future of banking. Whether you’ve got years of banking experience or are just starting your career in financial services, we can help you realize your potential. Through regular leadership and development conversations to mentorship and training programs, we’re here to support you towards your goals. As an organization, we keep growing – and so will you.
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. Whether you have a passion for helping customers and want to expand your experience, or you want to coach and inspire your colleagues, there are many different career paths within our organization at TD – and we’re committed to helping you identify opportunities that support your goals.
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
You must create an Indeed account before continuing to the company website to apply
💡 Quick Summary
Seeking a career-building opportunity? The Data Engineer II position is now open for candidates interested in the Bank Jobs sector. This role in Toronto offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Bank Jobs is a plus.