Talend Data Engineer

Scotiabank; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading bank in Canada seeks a Data Engineer to join their innovative team in Toronto. The role involves developing and supporting ETL workflows using Talend and various database technologies. Candidates should have a strong background in data integration, database design, and excellent communication skills. This position promotes collaboration in a hybrid work environment, offering numerous benefits and a dynamic workplace culture.

Benefits

Diversity and Inclusion programs

Tuition assistance

Flexible vacation and personal days

Competitive Rewards program including bonus

Community engagement programs

Dynamic workspace with collaboration spaces

Qualifications

• 5+ years’ experience as a Data Engineer.
• Talend Data Integration and database design experience required.
• Excellent communication skills to articulate integration requirements.

Responsibilities

• Collaborate to design, develop, and support ETL workflows.
• Analyze and resolve technical application issues.
• Maintain documentation for ETL processes and data flows.

Skills

Data Integration

Database Design

SQL

ETL Workflows

Communication

Education

University degree in Computer Science

Tools

Talend

AWS

SQL Server

Oracle

Salesforce

Jenkins

Jira

Autosys

Control-M

Job description

Requisition ID: 227260

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

The Data Engineer will focus on application development and support in a Talend-based development environment. In a team-oriented atmosphere, the incumbent will work closely with the Technical Lead, Senior Data Engineers, Data Engineers, Business Analysts, and Quality Assurance Analysts in delivering solutions for our clients. The incumbent will be responsible for the end-to-end design and development, testing and implementation of ETL workflows and contribute to the overall Database Design. Development tools include but are not limited to Talend, Salesforce and various on-prem and cloud-based database technologies such as AWS (SQL) and Oracle.

Is this role right for you? In this role you will:

• Collaborate with teammates to plan, design, develop, test, and support ETL workflows in Talend
• Design and/or implement changes to existing Database Model
• Design and implement stored procedures, functions and views to support the ETL workflows
• Participate in peer-reviews of solution designs and related code
• Package and support deployment of automated releases
• Analyze and resolve technical and application problems
• Provide Production Support and Release Support nights and weekends when required
• Assess opportunities for application and process improvement and prepare documentation of rationale to share with team members and other affected parties
• Work with teammates to roll-out and maintain continuous integration practices
• Adhere to high-quality development principles while delivering solutions on-time and on-budget
• Develop and managebatch jobsusingAutosys,Control-M, or similar scheduling tools
• Monitor and troubleshoot ETL jobs and data pipelines inLinux-based environments
• Maintain documentation for ETL processes, data flows, and system configurations

Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:

• 5+ years’ experience as a Data Engineer
• University degree in Computer Science or a related discipline
• Extensive experience in Talend Data Integration, database design and development
• Experience with Database Modeling design patterns in any Database platform
• Proficient with SQL Server and/or Oracle Database Technologies
• Experience with large Salesforce implementations – specifically Talend to Salesforce integration experience would be considered an asset
• Familiar with Integrating Salesforce with other cloud-based application systems using REST, SOAP API
• Experience with deployment processes and release pipelines. Ex: Jenkins, Bitbucket/Git
• Experience using Jira for backlog management
• Experience working in an Agile Team
• Experience with business intelligence tools like Tableau, SAS, and Power BI considered an asset
• Experience in hosted environments like Azure or AWS considered a strong asset
• Experience integrating withSalesforce and Kafka.
• Proficiency inLinux/Unixcommand-line tools and scripting (e.g., Bash, Shell).
• Experience withjob scheduling toolslikeAutosys,Control-M, orCron.
• Excellent communication skills to clearly articulate integration requirements to business users. Interaction with various business lines will be imperative for the success of the incumbent.

• Talend certification(s) is a asset.
• Understanding of Cloud Hosted environments and related technologies
• Knowledge of various database modeling techniques including database theory, and a strong understanding of business data structures

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.
• Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.
• Community Engagement - No matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons.

Working location condition: Hybrid

#LI-Hybrid

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.