The Role This position is responsible for supporting the Capital Markets business unit’s systems and databases along with its data needs by providing requirements gathering and analysis, quality assurance and data analysis services.

This role may include creation of test plans, execution of tests, logging of defects, identification and resolution management of data integrity issues and communication with team members to ensure business requirements are satisfied.

This role will also participate in Capital Markets sales and liquidity analysis (analyzing and reporting asset portfolio and the various funding programs to make informed business decisions) and portfolio insurance process.

Data Mining Analysis and Reporting Perform complex data analysis to support various initiatives within the team.

Document and present data analysis and data mining results to the manager Keep current with data mining methodologies and recommends use of them where appropriate Support building and maintaining various reporting templates and models.

Quality Assurance and Testing Identify and document the test cases, steps to execute test cases, required data, and expected results required to validate that the functional and non-functional requirements have been met Participate in test automation and test strategy activities Execute tests as planned, and record actual results, to provide traceable documentation Compare actual results to expected results, and analyze any variances to identify defects Create problem logs and tracks defects.

Manage the defects through resolution by working with appropriate IT and business resources.





Summarize test results to provide documentation for IT and Business partners Builds and enhance regression tests for supported systems Triage issues, confirm and troubleshoot production defects Conducts post-implementation confirmation testing Portfolio Insurance Reporting Prepare scheduled reports for review by Capital Markets management Process insurance premium payment based on the established procedures Work with internal counterparties to collect and analyze various reports to ensure the information is precise and accurate Identify eligible mortgages to be submitted for portfolio insurance program Assist in preparing portfolio insurance submissions and co-ordinate communication with the insurers Liquidity and Sales Planning Analyze eligibility and recommend portfolio for sale transactions based on the asset liquidity.

Prepare and distribute data tapes timely and accurately.

Work with internal counterparties to collect and analyze data to ensure the information is precise and accurate.

Support bulk sale submissions.

Prepare scheduled reports for review by Capital Markets management Support audit process Produce and deliver post settlement documents Miscellaneous regular/ad-hoc Tasks Perform ad‐hoc tasks/analysis upon the management's requests timely and accurately.





Prepare scheduled reports.

Create and maintain procedure documents.

Provide documents and samples for audit Process contractual repurchase Run and save query results from various systems and databases What You Bring To The Team 3+ years of QA and/or BA experience is an asset 3+ years of mortgage/financial industry experience is an asset Solid knowledge of Microsoft Office (Excel and Word) Project management experience is an asset Proven ability to write complex MS SQL queries Experience with Business Requirements Gathering & Analysis practices Experience with MS Share

Point and Azure Dev

Ops is an asset Experience with MBS/Mortgage Industry is preferred Experience with Capital Markets is an asset Strong oral and written communication skills Excellent organizational and time-management skills Ability to multi-task in a fast-paced environment Strong analytical and problem-solving skills Proven ability to foster relationships Self-driven, motivated with the ability to work independently and in a team setting Carries out duties with integrity and takes responsibility for actions Superior time management skills with the ability to meet tight deadlines Advanced MS Word and Excel skills Aptitude for learning new computer software programs Excellent attention to detail and results oriented with a track record demonstrating strong problem solving and analytical skills Analyzes data from multiple sources to support decisions The stamina for extended periods of isolated focus Undergraduate degree in mathematics, computer science, or the equivalent

📌 Data & Business Support Analyst (Toronto)
🏢 MCAP
📍 Toronto