Title:  Data Engineer

Requisition ID: 230100

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

Data Engineers are responsible for the development of ETL jobs that provides/process information to/from businesses within the Bank and its partners.  Experts in Azure Data Factory and have an in-depth knowledge on Cloud solutioning and data lineage technologies.  Strong skills on SQL Server programming.  Solid experience on ETL tools such as SSIS and similar technologies. These professionals are experts in data processes such as aggregating, cleansing and enrichment, lookup and referencing, pivoting and grouping, and process optimization with on-point compliance to security and CAB (Change Admin Board) standards.

In this role you will: 

• Ability to resolve highly complex, multi-faceted problems to meet business needs, provide recommendation on the design and methodologies, system solutions.
• Provide business support to all units globally, including new and existing portfolios, ad hoc queries, and assisting with the design and implementation of systems enhancements.  The incumbent is responsible for ensuring that management is kept informed and that problems and issues are escalated appropriately.
• Provide input to the continuous improvement of processes and adopting latest technologies and methodologies.
• Ability to Liase with different teams to fix data quality issues.
• Co-ordinate and follow up with various other different teams, vendors and third party for issue resolution.
• Work with Infrastructure teams to co-ordinate infrastructure/environment related upgrades, patches and migration activities.
• Ensure the documentation of issues, solutions, root cause and findings for use in future problem resolutions.
• Development techniques, such as debugging, testing, coding, use of version control tools like TFS.
• Performance tuning skills is a must
• DevOps process oriented
• Provide L1/L2/L3 support for ETL processes built on Azure Data Factory and legacy systems such as SSIS, DataStage and Stored Procedures

Do you have the skills that will enable you to succeed in this role? 
 

• Bachelor’s degree in technology and/or engineering course
• 3 years hands-on experience on TSQL programming 
• 2 years Azure Data Factory development experience
• Knowledge on Cloud solutions particularly on MS Azure Technologies
• In-depth understanding of modern Datahub and Data warehousing concepts
• Extensive knowledge on ETL standards concerning data security and run time process optimization
• Result-oriented, highly motivated, have a keen eye to details, and have a very good analytical skills to deliver efficient solutions.
• Curious about technologies, adaptive to changes, a good team player, works efficiently even under pressure, takes ownership of the tasks, and with a good interpersonal and communication skills

What's in it for you? 
 

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans. 
• Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove, and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.   
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance.   
• Competitive Rewards program including bonus, flexible vacation, personal, sick days, and benefits will start on day one. 
• Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more! 

Location(s):  Canada : Ontario : Toronto 

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.  

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.