Data Engineer II

Description :The Data Engineer II provides a broad range of data engineering functions including data modeling, data quality, data profiling, data acquisition and ingestion, extract transform load (ETL), metadata enrichment and management, data provenance and lineage, and other specialized data management functions.Depth & Scope:Advanced knowledge of data engineering frameworks, technologies, tools, processes, patterns, and procedures, including how they impact other technology areas such as Architecture or InfrastructurePerforms complex technical tasks independentlyAdvanced knowledge of TD applications, systems, networks, innovation, design activities, business, organization, best practices, and standardsDesigns and develops to meet business and technical requirements; analyzes, adapts, integrates, codes, tests, debugs, and executesUses and evolves established patterns to solve complex problems; leads the development of new patterns where necessaryMay be recognized as a subject matter expert in areas directly related to key accountabilitiesEducation & Experience:Degree, Postgraduate Degree, or Technical Certificate in Data Management or related discipline (e.g. Computer Science, Engineering), or equivalent practical experience3+ years of relevant experienceCustomer Accountabilities:Performs data analysis and assesses data management requirements for a specific Platform or Journey, including complex analysis involving multiple pods or productsMaintains expert knowledge of upstream data, including knowledge provided through data profiling, data quality reporting, and via the production of metadataSupports the acquisition and ingestion of dataArticulates complex, large scale, and high impact technical design and development details to non-technical business partnersElicits, analyzes, and understands 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, and metadataEnsures data is maintained in compliance with enterprise data standards, policies, and guidelinesDevelops and maintains complex data models using industry standard modeling toolsDevelops and maintains complex ETL jobs and frameworks using the Bank's standard toolsProvides support to the development and testing teams to resolve data issues, including escalation support on complex issuesSupports partners and stakeholders in interpreting and analyzing dataBuilds effective working relationships within own pod and across partner teams to encourage collaboration on all pod deliverablesShareholder Accountabilities:Coordinates with technology work teams such as ITS, ARE, Architecture, Enterprise Protect etc. to ensure overall delivery successSupports the QA team with data analysis/investigations of complex issues/ test cases as part of SIT/UAT/PAT testingProvides oversight on post implementation activities during the warranty periodExecutes & approves code check-in/ check-out into source code repository as part of source code managementWorks closely with ITS/ ARE teams to support code packaging & deployment (CI & CD) into higher environmentsIs the lead participant in the design & architecture reviews or the applicationRaises service-now requests and works with the change management team to support release management activitiesLeads data engineering initiatives and capabilities, data governance principles and how they apply across the organizationEnsures metadata and data lineage is captured and compatible with enterprise metadata and data management tools and processesAdheres & contributes towards standard security coding practices to ensure application is free of most common coding vulnerabilitiesEnsures technical decisions, technical risks and lessons learned are identified, clearly documented and enhancements are accordingly implementedProtects the interests of the organization – identifies and manages risks, and escalates non-standard, high-risk activities as necessaryAdheres to internal policies/procedures and applicable regulatory guidelinesKeeps current on emerging trends/ developments and grow knowledge of the business, related tools, and techniquesEnables team members by sharing knowledge and leveraging engineering best practicesEmployee/Team Accountabilities:Participates fully as a member of the team, supports a positive work environment that promotes service to the business, quality, innovation and teamwork and ensures timely communication of issues/ points of interestProvides thought leadership and/or industry knowledge for Data engineering best practices and participates in knowledge transfer within the team and business unitKeeps current on emerging trends/ developments and grows knowledge of the business, related tools and techniquesParticipates in personal performance management and development activities, including cross training within own teamKeeps others informed and up-to-date about the status / progress of projects and/or all relevant or useful information related to day-to-day activitiesActively mentors and enables team members by sharing knowledge and leveraging engineering best practicesSupports the team by providing guidance and proactively identifying and resolving issuesLeads, motivates and develops relationships with internal and external business partners / stakeholders to develop productive working relationshipsContributes to a fair, positive and equitable environment that supports a diverse workforceActs as a brand ambassador for your business area/function and the bank, both internally and/or externallyPreferred Qualifications:3+ years of hands-on experience with databases including SQL servers and Oracle, experience with stored procedures3+ years of extensive experience in Alteryx Workflow development and maintenance1+ years of experience building and optimizing data pipelines, architectures, and datasets using Microsoft Azure technologies including Azure Databricks, Azure Data Factory, Spark, and PythonStrong knowledge and experience with ETL tools and processes including InformaticaExtensive Knowledge working on Banking domain projects specifically Commercial applicationsUnderstanding of Agile/Waterfall and SDLC processesPhysical Requirements:Never: 0%; Occasional: 1-33%; Frequent: 34-66%; Continuous: 67-100%Domestic Travel – OccasionalInternational Travel – NeverPerforming sedentary work – ContinuousPerforming multiple tasks – ContinuousOperating standard office equipment - ContinuousResponding quickly to sounds – OccasionalSitting – ContinuousStanding – OccasionalWalking – OccasionalMoving safely in confined spaces – OccasionalLifting/Carrying (under 25 lbs.) – OccasionalLifting/Carrying (over 25 lbs.) – NeverSquatting – OccasionalBending – OccasionalKneeling – NeverCrawling – NeverClimbing – NeverReaching overhead – NeverReaching forward – OccasionalPushing – NeverPulling – NeverTwisting – NeverConcentrating for long periods of time – ContinuousApplying common sense to deal with problems involving standardized situations – ContinuousReading, writing and comprehending instructions – ContinuousAdding, subtracting, multiplying and dividing – ContinuousThe above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties and skills required. The listed or specified responsibilities & duties are considered essential functions for ADA purposes.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 95,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 PackageOur 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 base salary and variable compensation/incentive awards (e.g., eligibility for cash and/or equity incentive awards, generally through participation in an incentive plan) and several other key plans such as health and well-being benefits, savings and retirement programs, paid time off (including Vacation PTO, Flex PTO, and Holiday PTO), banking benefits and discounts, career development, and reward and recognition. 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.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 & OnboardingWe 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.AccommodationTD Bank is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, status as a protected veteran or any other characteristic protected under applicable federal, state, or local law.If you are an applicant with a disability and need accommodations to complete the application process, please email TD Bank US Workplace Accommodations Program at . Include your full name, best way to reach you and the accommodation needed to assist you with the applicant process.