Technical Analyst Advisory (Mortgage Backed Securities and Securitization)
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Scotiabank seeks a Technical Analyst Advisory for Mortgage Backed Securities and Securitization. This hybrid role combines business analysis, technical analysis, application support, data analysis, and development support.
Key Skills for This Role
Responsibilities
- 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
Requirements
- 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
Full Job Posting
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.
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.
Do you have the skills that will enable you to succeed in this role?
- 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.
- Accessibility and Workplace Accommodations – We value the unique skills and experiences each individual brings.
- 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.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Scotiabank
Business Analysis Specialist Market Risk
Toronto, CAN
Scotiabank is seeking a Business Analysis Specialist for Market Risk to provide subject matter expertise on FRTB aggregation and the Atoti platform. The role involves interacting with stakeholders, managing requirements,
Senior Manager, Enterprise Payments, Global Transaction Banking
Toronto, CAN
Scotiabank is seeking a Senior Manager, Product Management – Payments API Standardization to lead the strategy, roadmap, and lifecycle management for payment API standards across a global API platform. The role involves
Business Analysis Specialist Market Risk
Toronto, CAN
Scotiabank seeks a Business Analysis Specialist to join the Global Risk and Treasury Engineering team, providing technical expertise on FRTB Market Risk aggregation and managing the Atoti platform. The role involves stak
Manager, Data & Analytics Strategy
Toronto, CAN
Scotiabank is looking for a Manager, Data & Analytics Strategy to drive the creation and adoption of the CID&A strategy and support strategic initiatives. You will execute complex programs, develop strategy content, and
Inside Sales Representative, Dynamic
Calgary, CAN
Scotiabank's Dynamic Funds seeks an Inside Sales Representative to support wholesalers by generating sales, managing client relationships, and executing outbound campaigns. The role requires strong product knowledge and
Business Analyst, Business Initiatives - Scotia Jarislowsky Fraser - Toronto
Toronto, CAN
Scotiabank is seeking a Business Analyst to support the development, planning, and execution of business initiatives within Scotia Jarislowsky Fraser. You will assist with project delivery, data analysis, event coordinat
Senior Manager, Analytics and BI
Toronto, CAN
Scotiabank seeks a Senior Manager, Analytics and BI for the Deposits & Savings business. You will lead analytics and BI initiatives, provide strategic insights, and manage a team. The role requires extensive analytics ex
Senior Manager, Product Strategy and Solutions, Private Banking
Toronto, CAN
Scotiabank seeks a Senior Manager to serve as the central product relationship manager for Private Banking, representing the division in enterprise product initiatives and influencing product roadmaps. The role requires
Business Analysis Specialist Market Risk
Toronto, CAN
Senior Manager, Enterprise Payments, Global Transaction Banking
Toronto, CAN
Business Analysis Specialist Market Risk
Toronto, CAN
Manager, Data & Analytics Strategy
Toronto, CAN
Inside Sales Representative, Dynamic
Calgary, CAN
Business Analyst, Business Initiatives - Scotia Jarislowsky Fraser - Toronto
Toronto, CAN
Senior Manager, Analytics and BI
Toronto, CAN
Senior Manager, Product Strategy and Solutions, Private Banking
Toronto, CAN