Lead Data Engineer in Toronto

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Wealth Data engineering team within the Global Wealth Engineering (GWE) is the key team in meeting the operational data needs of the various stakeholders within Wealth Management. The Lead Data Analyst will play a key role in designing and implementing business solutions using Google Cloud, working closely with the enterprise data team and data architects, solution architects, data analysts, and data engineers.

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

• Be responsible for creating automated test scripts, conducting software testing, and collaborating with software developers to identify and address defects. You will play a key role in ensuring the quality and reliability of software products.
• Develop and design new software systems by reviewing, repairing, maintaining, and testing systems to improve business operations. Focus on performing analysis and research to determine the weaknesses and strengths of existing systems.
• Focus on the design, implementation, and optimization of automated systems within a variety of industries.
• Create test cases and scripts for manual and automated testing based on project requirements. Design and develop automation scripts using appropriate tools and frameworks. Review and verify test cases and scripts for quality standards.
• Guide a team of QA specialists and work hands-on in developing frameworks and mapping specs using best practices that will meet the demanding performance requirements.
• Use your advanced technical knowledge to support claims and answer clients' questions about the proposed changes.
• Provide end-to-end business/technical guidance and expertise on data integrity and referential integrity across LOBs.
• Define Use Case Scenarios and validate the scenarios.

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

• 10+ years of experience in data analysis, performance optimization for large OLTP applications.
• Knowledge of Wealth Industry - Retail/Wealth, IIROC-CRM guidelines, CRA guidelines.
• Oral and written communication skills.
• Interpersonal and consultative skills.
• Analytical thinking and problem solving.
• Being detail-oriented and capable of delivering a high level of accuracy.
• Organizational skills.
• Knowledge of business structure.
• Stakeholder analysis.
• Expertise knowledge of Hadoop HDFS, Hive, Pig, Flume, and Sqoop.
• Working experience with Google Cloud Platform Databases (SQL, Spanner, PostgreSQL).
• Experience working with relational/NoSQL databases.
• Experience with data streaming and technologies such as Kafka, Spark-streaming, etc.

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 embraced through bias-free practices and inclusive values across Scotiabank.
• 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.
• 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, contests, cooking with friends, Humans of Digital, and much more!

Location(s): Canada : Ontario : Toronto