Senior Data Engineer; Tech Delivery Lead

Work Location

Toronto, Ontario, Canada

37.5

Technology Solutions

$96,900 - $136,800 CAD

This role is eligible for a discretionary variable compensation award that considers business and individual performance.

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 guidance and advice across a broad range of highly complex or specialized data engineering functions including data modeling, data quality, data profiling, data acquisition and ingestion, extract transform load (ETL and ELT), metadata enrichment and management, data provenance and lineage, and other specialized data management functions.

• Lead or provide expertise to Data Analysts /Specialists in defining and managing detailed system design for data integration processes or data marts/ warehouse builds or extensions
• Interface with the architecture group to determine the overall solution and ensure conformance to established data management standards
• Work closely with various technology teams, business systems analysis, development and project teams in the creation of detailed system requirements, specification documents related to Data Management initiatives and resolve information flow and content issues
• Coordinate with various infrastructure teams for assessing impacts of projects on storage, network, database infrastructure
• Create development estimates for various phases of project requests and responsible for reviewing and approving business / system specification requirements, authoring system design specifications and system deployment plans
• Collaborate with testing services and approving test strategy and plans
• Coordinate with project managers and resource manager to establish project plan and allocate resources to the project
• Responsible for leading the implementation and support of leading-edge, data warehouse / big data environments
• Support data warehouse (ETL) data management process in database usage and data warehousing.
• Extract data from homogeneous or heterogeneous data sources and transform the data for storing in proper format or structure for querying and analysis purposes
• Load data into the final target (database, operational data stores, data marts, or data warehouse)
• Ensure metadata and data lineage is captured and compatible with enterprise metadata and data management tools and processes
• Provide data management expertise to the development and testing teams to resolve data issues
• 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
• Oversee that requirements regarding privacy and security of data, data governance and access controls are appropriately captured.
• Comply with well-defined enterprise technology delivery practices and standards and project management disciplines
• Lead coordination efforts with other technology work teams such as, ITS, Architecture, TRMIS etc. to ensure project success
• Perform or lead complex analysis in an evolving data environment and gather, analyze, document and maintain all data requirements related to the business applications, interfaces, and reporting environments in different kinds of data maps.
• Apply standards and best practices to ensure that the application’s data is accurate, complete, current, understandable, and accessible
• Define, build and manage data dictionary / catalog for respective data platforms, systems / servers / applications
• Manage and coordinate efforts of data modelers, data warehouse/data integration developers, and Extract, Transform and Load conformance to established data management standards
• 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;
  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

• Leads coordination & and manages expectations with the technology work teams such as ITS, ARE, Architecture, Enterprise Protect etc. to ensure overall delivery success
• Perform or lead data…