Data & Business Support Analyst

MCAP at a Glance

JoiningMCAP means you will be a part of our diverse workforce of highly talentedindividuals who are recognized for their expertise and success At MCAP, yourprofessional expertise, commitment to teamwork and passion for serviceexcellence are recognized and rewarded with competitive total rewards offering,a career with continuous learning and development (formal & informaltraining), and exciting opportunities in a dynamic, entrepreneurialenvironment.

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 SharePoint and Azure DevOps 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 quick-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 environment
- Carries out duties with integrity and takes res

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