Toronto, Ontario, Canada, Canada
July 18, 2023
Apply NowJob description
TD Description
Tell us your story. Don't go unnoticed. Explain why you're a winning candidate. Think TD if you crave meaningful work and embrace change like we do. We are a trusted North American leader that cares about people and inspires them to grow and move forward.
Stay current and competitive. Carve out a career for yourself. Grow with us. Here's our story: jobs.td.com
Department Overview
Data as a Service (DaaS) is an enterprise-wide data management improvement initiative that brings business data and technology resources together to maximize customer and colleague benefit.
The Data Engineering Practice is comprised of a group of highly skilled Subject Matter Experts (SME) with the same job/roles, sharing a common domain of expertise and discipline, and are focused on the delivery of specialized work including building data pipelines, supporting data science needs, driving data automation, creating and implementing data & analytics platforms. Roles within the team include Big Data Engineers, ETL Engineers, Database Engineers, Distributed Engineers, Data Modelers and Business Systems Analysts that specialize in data applications. These SMEs, or practitioners, are forward deployed to Enterprise and Segment Product families (such as Personal Banking, Business Banking, TD Insurance, TD Wealth) within the DaaS Platform. This practice is 100% dedicated to DaaS
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:
Job 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:
Additional Information
Join in on what others in TD Technology Solutions are doing:
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.
Tell us your story. Don't go unnoticed. Explain why you're a winning candidate. Think TD if you crave meaningful work and embrace change like we do. We are a trusted North American leader that cares about people and inspires them to grow and move forward.
Stay current and competitive. Carve out a career for yourself. Grow with us. Here's our story: jobs.td.com
Department Overview
Data as a Service (DaaS) is an enterprise-wide data management improvement initiative that brings business data and technology resources together to maximize customer and colleague benefit.
The Data Engineering Practice is comprised of a group of highly skilled Subject Matter Experts (SME) with the same job/roles, sharing a common domain of expertise and discipline, and are focused on the delivery of specialized work including building data pipelines, supporting data science needs, driving data automation, creating and implementing data & analytics platforms. Roles within the team include Big Data Engineers, ETL Engineers, Database Engineers, Distributed Engineers, Data Modelers and Business Systems Analysts that specialize in data applications. These SMEs, or practitioners, are forward deployed to Enterprise and Segment Product families (such as Personal Banking, Business Banking, TD Insurance, TD Wealth) within the DaaS Platform. This practice is 100% dedicated to DaaS
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 life cycle management, governance, lineage, metadata and reporting elements.
- Apply automation and innovation on new and on-going data platforms for those development projects aligned to business or organizational strategies.
- 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.
- Deliver business or enterprise data deliverables (that adhere to enterprise frameworks) for various platforms/servers/applications/systems.
- 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.
- Support the user community by helping them interpret data.
- Engage with data managers, stewards and owners to implement, maintain, enhance data governance, quality and related policies, aligning with TD's standards and frameworks.
- Ensure capture of requirements related to data privacy and security, governance and access controls.
- Respect TD's technology delivery practices, standards, project management disciplines.
Job 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.
- 5+ years of relevant experience working in a batch support environment for ETL applications with Mainframe and Unix background
- 5+ years relevant experience in SQL Scripting, SSMS, T-sql, SSIS, SSMS, SSRS
- 2+ years relevant experience in supporting applications on Azure Cloud
- Subject matter expertise on business processes and procedures, as well as broader organizational issues and technology.
- Azure data factory
- Python
- Databricks
- Tablue
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,
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.