Title:  Data Engineer

Requisition ID: 243181

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

Join a friendly, passionate, and seasoned team who is committed to deliver results in an efficient manner. The Team is responsible for Data sourcing, transformation, Integration, Quality and Availability. The team serves the customers of all Wealth business lines, including iTrade, Scotia McLeod, Private Investment Council and Scotia Trust. The team is known for excellence in delivery and support of many critical client facing and back-office applications.

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

1. ETL Process Analysis, Design and Development

• Develop ETL code and build packages as per best practices and suggest improvements when possible.
• Ingesting and transforming data from various sources. Building scripts, writing specifications and collaborating with senior members for and end-to-end delivery of data
• Develop and test code from design specifications, as well as implement and support enhancements to applications
• Self-starter, Proactive and possess technical expertise to handle medium-to-complex projects as a Data Engineer.
• Exposure to agile, scrum and kanban environment and organization standards.
• Work in close collaboration with Technical Business Analyst, Tech Lead, Architects and other cross functional team members in creating design documents, outlining overview, diagrams, technical requirements and solution that best addresses a business needs.

2. ETL Processes Support, Testing & Deployment

• Participate in Unit, IST, UAT, regression testing on projects, as needed
• Prepare test cases and test scripts and assist in creating and retrieving required test data.
• Assist and support Release coordinator to make sure that releases are delivered efficiently and without defect. 
• Provide overnight and weekend support for project implementations and releases as needed. 
• Participate in production support activities on rotation basis. Pager support may be required.
• Assist in creating internal operation support manuals and assist in post implementation shakedown testing, as required.
• Meet the SLA/SLO for incidents and project timelines

3. Communications Management

• Build a good understanding of the Division's business strategies, business policies, financial instruments, risk management and back-office processing.
• Identify and communicate any impediments with practical solutions to Sr. Data Engineer, Technical Production Owner and Team Lead
• Being Proactive vs Reactive.
• Communicate Clear and concise manner and an ability to articulate technical work in simple business terms.

4. Team Player

• Work with already established mature team members, adapt to team norms, culture and dynamic.
• Respectful, open-minded and able to work with teams with different cultures and time zones.
• Collaborate with team members in-person and virtually from different regions in Canada and India.
• Collaborate with various stakeholders like product owner, business lines and QA team.
• Enthusiastic, passionate and bring forward new ideas and opportunity to collaborate with team.
  

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

• 3+ years’ IT industry experience with ETL tools like Talend, DataStage, Informatica etc.
• 1 to 3+ years’ experience with relational databases with a good knowledge of SQL Scripting, database structures, principles and design theories.
• Exposure and/or hands-on experience with data integration, development using one or more tool and technologies like shell scripting, Java, AutoSys, Tidal.
• Familiar with Unix, Linux and Windows platforms.
• Experience with data sourcing, ETL and data integration.
• Hands on experience with MS Office Suite i.e., MS Outlook, MS Word, Excel, Access, PowerPoint, and Project
• Understanding of Database environment (i.e., relational, structural, etc.)
• Familiar with Dockers, Kubernetes
• Familiar with Cloud technologies like GCP, Azure, AWS

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 - We offer opportunities for community engagement & belonging with our various programs such as hackathons.

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.