TD Bank

Data Engineer II - CPB Data Curation

TD Bank • $81K — $115K *
Toronto, ON M3C 0E3In-Person
Information Technology
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Proficient in Java/PySpark, Python, and SQL with experience in Azure ADB and ADF.
  • Solid understanding of ETL design and optimization.
  • 3-5 years of relevant data engineering experience.
  • Degree or postgraduate degree in Data Science, Computer Science, Engineering, or equivalent practical experience.
  • Experience using GitHub Copilot to improve code quality is a plus.

Responsibilities

  • Perform data analysis to assess management needs for specific platforms or journeys.
  • Maintain knowledge of upstream data through profiling and quality reporting.
  • Support data acquisition and ingestion processes.
  • Communicate complex technical designs to non-technical partners.
  • Develop business solutions including data models, ETL, and governance.
  • Ensure adherence to enterprise data standards and guidelines.
  • Lead data engineering initiatives including governance integration.

Benefits

  • Collaborative work environment that encourages teamwork and innovation.
  • Opportunities for mentoring and knowledge transfer within the team.
  • Access to continuous learning and development resources.
  • Flexible work schedule with a focus on work-life balance.
  • Involvement in leading-edge data engineering projects.
Full Job Description
Work Location:
Toronto, Ontario, Canada

Hours:
37.5

Line of Business:
Technology Solutions

Pay Details:
$81,600 - $115,200 CAD

JOB DESCRIPTION SUMMARY

Provide a broad range of data engineering functions, including data modeling, data quality, data profiling, data acquisition and ingestion, extract, transform and load (ETL), metadata enrichment and management, data provenance and lineage, and other specialized data management functions.

JOB DESCRIPTION

CUSTOMER

  • Perform data analysis and assess data management requirements for a specific Platform or Journey, including complex analysis involving multiple pods or products.
  • Maintain expert knowledge of upstream data, including knowledge provided through data profiling, data quality reporting, and the production of metadata.
  • Support the acquisition and ingestion of data.
  • Articulate complex, large-scale and high-impact technical design and development details to non-technical business partners.
  • Elicit, analyze and understand business and data requirements to develop complete business solutions, including data models (entity relationship diagrams and dimensional data models), ETL and business rules, data lifecycle management, governance, lineage and metadata.
  • Ensure data is maintained in compliance with enterprise data standards, policies and guidelines.
  • Develop and maintain complex data models using industry-standard modeling tools.
  • Develop and maintain complex ETL jobs and frameworks using the Bank's standard tools.
  • Provide support to development and testing teams to resolve data issues, including escalation support for complex issues.
  • Support partners and stakeholders in interpreting and analyzing data.
  • Analyze and understand business and data requirements to develop complete ETL solutions under the guidance of senior peers and tech leads.


INTERNAL / INTERNE

  • Build effective working relationships within own pod and across partner teams to encourage collaboration on all pod deliverables.


SHAREHOLDER

  • Coordinate with technology work teams and stakeholders to ensure overall delivery success.
  • Support the QA team with data analysis and investigations of complex issues/test cases as part of SIT/UAT/PAT testing.
  • Provide oversight on post-implementation activities during the warranty period.
  • Execute and approve code check-in/check-out into the source code repository as part of source code management.
  • Work closely with Release Management teams to support code packaging and deployment (CI/CD) into higher environments.
  • Be the lead participant in application design and code reviews.
  • Raise ServiceNow requests and work with the Change Management team to support release management activities.
  • Lead data engineering initiatives and capabilities, including data governance principles and how they apply across the organization.
  • Ensure metadata and data lineage are captured and compatible with enterprise metadata and data management tools and processes.
  • Adhere to and contribute toward standard secure coding practices to ensure applications are free of common coding vulnerabilities.
  • Ensure technical decisions, technical risks and lessons learned are identified and clearly documented, with enhancements implemented accordingly.
  • Protect the interests of the organization by identifying and managing risks and escalating non-standard, high-risk activities as necessary.
  • Adhere to internal policies/procedures and applicable regulatory guidelines.


INTERNAL / INTERNE

  • Keep current on emerging trends/developments and grow knowledge of the business, related tools and techniques.
  • Enable team members by sharing knowledge and leveraging engineering best practices.


EMPLOYEE / TEAM

  • Participate fully as a member of the team and support a positive work environment that promotes service to the business, quality, innovation and teamwork, while ensuring timely communication of issues and points of interest.
  • Provide thought leadership and/or industry knowledge for data engineering best practices and participate in knowledge transfer within the team and business unit.
  • Keep current on emerging trends/developments and grow knowledge of the business, related tools and techniques.
  • Participate in personal performance management and development activities, including cross-training within own team.
  • Keep others informed and up to date about the status/progress of projects and all relevant or useful information related to day-to-day activities.
  • Actively mentor and enable team members by sharing knowledge and leveraging engineering best practices.
  • Support the team by providing guidance and proactively identifying and resolving issues.
  • Lead, motivate and develop relationships with internal and external business partners/stakeholders to develop productive working relationships.
  • Contribute to a fair, positive and equitable environment that supports a diverse workforce.
  • Act as a brand ambassador for your business area/function and the Bank, both internally and/or externally.


BREADTH & DEPTH

INTERNAL / INTERNE

  • Advanced knowledge of data engineering frameworks, technologies, tools, processes, patterns and procedures, including how they impact other technology areas such as Architecture or Infrastructure.
  • Perform complex technical tasks independently.
  • Advanced knowledge of TD applications, systems, networks, innovation, design activities, business, organization, best practices and standards.
  • Design and develop to meet business and technical requirements; analyze, adapt, integrate, code, test, debug and execute.
  • Use and evolve established patterns to solve complex problems; lead the development of new patterns where necessary.
  • May be recognized as a subject matter expert in areas directly related to key accountabilities.


EXPERIENCE AND/OR EDUCATION

  • Hands-on proficiency in Java/PySpark, Python and SQL, with experience in Azure ADB, ADF and Bitbucket (GitHub).
  • Solid technical skills in investigating ETL design, optimizing ETL workflows, mitigating risks and ensuring data accuracy-key functions that directly impact business outcomes.
  • Experience leveraging GitHub Copilot to enhance development productivity and code quality is an asset.
  • Degree, postgraduate degree or technical certificate in Data or a related discipline (e.g., Computer Science, Engineering), or equivalent practical experience.
  • 3-5 years of relevant experience.


#li-tech

About TD Bank

TD Securities offers a range of advisory and capital market services to its clients. The company's range of services includes research, investment banking, capital markets, and global transaction banking. Research consists of commodity and equity research. Investment banking consists of mergers, acquisitions, industry expertise, and credit origination. Global transaction banking consists of trade finance, cash management, and correspondent banking. TD Securities was founded in 1855 and is based in Ontario.

TD Bank Careers

Join the vibrant team at TD Bank, one of North America's leading financial services organizations, where innovation, leadership, and growth go hand in hand. At TD Bank, we are committed to fostering a culture of diversity and inclusion, making it an ideal place for ambitious professionals to thrive. Work You’ll Do At TD Bank, your professional journey is bolstered by a robust support system. From your first interview to every career milestone, you will find opportunities for growth and leadership. Our team is dedicated to helping you develop the skills necessary for success in the ever-evolving financial sector. TD Bank offers a variety of job opportunities across multiple fields, from customer service to investment banking. Each position at TD Bank is a chance to contribute to our culture of innovation and exceptional client service. Internship Programs Kickstart your career with a TD Bank internship. Our programs provide invaluable industry exposure and hands-on experience, making them a perfect starting point for students and recent graduates eager to make their mark in the banking industry. Interns at TD Bank enjoy the unique opportunity to work alongside seasoned professionals, gaining insights that are crucial for future employment. Benefits and Growth TD Bank is deeply committed to the well-being and continuous growth of our team members. We offer competitive benefits packages that cover health, finance, and family care. Our employees enjoy comprehensive health insurance, retirement plans, and generous paid time off, among other perks. Moreover, TD Bank encourages professional development through various training programs, including leadership development and diversity training. These initiatives ensure that our team remains at the forefront of industry standards and best practices. Join Our Team Explore the numerous career paths available at TD Bank and discover how your skills and interests align with our mission. We are actively hiring and continually looking for talented individuals who are passionate about banking and customer service. Networking and Professional Development At TD Bank, we believe in the power of networking and collaboration. Our employees have access to a wide range of networking events, workshops, and seminars that promote career development and professional growth. These platforms not only enhance your professional skills but also expand your industry connections. Stay Connected Keep up to date with the latest at TD Bank Careers by subscribing to our job alert emails. Tailor your subscription to match your career preferences and get the latest news, insider tips, and job opportunities delivered straight to your inbox. Explore job opportunities at TD Bank and be part of a team that values hard work, creativity, and a diverse workplace culture. Your next great career move is just a click away. SEARCH TD BANK JOBS Join us at TD Bank and let your ambition lead you to a rewarding career filled with opportunities to learn, grow, and innovate.
Learn more about TD Bank
Size
90,000 employees
Market Cap
$117.9 billion
Industry
Finance & Insurance
Net Income
-$6.9 million
5 Year Trend
+6.6%
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at TD Bank

More Information Technology Jobs

Find similar Data Engineer II - CPB Data Curation jobs:

NationwideToronto, ON