Requisition ID: 266804
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
The Team
A Technical Analyst Advisory (Mortgage Backed Securities and Securitization) is a hybrid role that combines business analysis, technical analysis, application support, data analysis, and development support. The role acts as a bridge between business stakeholders, IT teams, infrastructure teams, and external vendors to support the delivery, maintenance, enhancement, and stability of enterprise applications.
The Role
This role requires the ability to understand business needs, analyze system functionality, troubleshoot production issues, work with data and SQL, support system integrations, coordinate releases, and contribute to technical solutions. The individual should be comfortable working across both business and technology teams and should be able to support coding, scripting, testing, documentation, and production validation activities.
Is this role right for you? In this role you will:
- Gather, analyze, and document business requirements for system enhancements, fixes, reporting needs, and operational improvements.
- Translate 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 systems.
- Analyze application workflows, data structures, business rules, interfaces, and downstream dependencies.
- Work with business users to understand issues, process gaps, and 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.
- Support development activities by writing, reviewing, and troubleshooting SQL queries, scripts, validation logic, and technical documentation.
- Assist with 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 behavior.
Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:
- Strong business analysis and technical analysis skills.
- Ability to understand both business processes and technical system behavior.
- 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.
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.
#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.