Technical Analyst Advisory - Scotiabank, Toronto

Position Summary

Scotiabank is seeking a Technical Analyst Advisory specializing in Mortgage Backed Securities and Securitization. This is a dynamic, hybrid role that serves as a crucial link between business stakeholders, IT teams, infrastructure teams, and external vendors. The position is integral to supporting the delivery, maintenance, enhancement, and stability of enterprise applications within a purpose-driven, high-performing culture.

The successful candidate will blend expertise in business analysis, technical analysis, application support, and data analysis. This role requires a deep understanding of business needs, the ability to analyze system functionality, troubleshoot production issues, and work extensively with data and SQL. You will support system integrations, coordinate releases, and contribute to robust technical solutions, working comfortably across both business and technology teams.

Key Duties and Responsibilities

As a Technical Analyst Advisory, your responsibilities will include a range of critical tasks to ensure the smooth operation and continuous improvement of our systems:

• Gather, analyze, and document business requirements for system enhancements, fixes, reporting needs, and operational improvements.
• Translate complex business needs into clear functional and technical specifications.
• Work with structured data, including database tables, CSV files, reporting views, stored procedures, extracts, and reconciliation outputs.
• Validate reports and system outputs against source data, business rules, and stakeholder expectations.
• Perform data mapping, data profiling, variance analysis, and reconciliation between various systems.
• Analyze application workflows, data structures, business rules, interfaces, and downstream dependencies.
• Collaborate with business users to understand issues, identify process gaps, and explore enhancement opportunities.
• Partner with developers, QA teams, vendors, and infrastructure teams to ensure requirements are properly understood and implemented.
• Build strong relationships and communicate effectively with colleagues across global regions and diverse teams.
• Support development activities by writing, reviewing, and troubleshooting SQL queries, scripts, validation logic, and technical documentation.
• Assist with the analysis of stored procedures, reporting logic, data extracts, batch jobs, and integration processes.
• Develop or support small-scale automation, data validation routines, file checks, and reconciliation processes.
• Review technical designs and help assess impacts across applications, data flows, and reporting outputs.
• Collaborate with development teams to investigate defects, validate fixes, and confirm expected system behaviour.

Skills and Experience

To succeed in this challenging role, candidates should possess a strong foundation in both business and technical domains, coupled with practical experience in system support and data management:

• Strong business analysis and technical analysis skills.
• Ability to understand both business processes and technical system behaviour.
• Proficiency in SQL, data analysis, reporting validation, and troubleshooting database-driven applications.
• Ability to write or support scripts, queries, validation routines, and automation logic.
• Understanding application architecture, system integrations, APIs, file transfers, batch processes, and reporting layers.
• Experience with production support, root cause analysis, issue management, and incident resolution.
• Experience with release management, change control, UAT coordination, and production deployment support.
• Strong data validation, reconciliation, and reporting oversight skills.

Life at Scotiabank

Joining Scotiabank means becoming part of a winning team committed to results in an inclusive and high-performing culture. We are dedicated to fostering an environment where every employee is empowered to reach their fullest potential.

Scotiabank offers a comprehensive package designed to support your professional growth and personal well-being:

• 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 employees 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 Opportunities: Access to online courses, cross-functional development opportunities, and tuition assistance to support your continuous learning.
• Competitive Rewards Program: Includes bonus, flexible vacation, personal and sick days, with benefits commencing on day one.
• Community Engagement: Opportunities for community engagement and belonging through various programs, regardless of your work location.