Data & Business Support Analyst

Data & Business Support Analyst

MCAP at a Glance

Joining MCAP means you will be a part of our diverse workforce of highly talented individuals who are recognized for their expertise and success! At MCAP, your professional expertise, commitment to teamwork and passion for service excellence are recognized and rewarded with competitive total rewards offering, a career with continuous learning and development (formal & informal training), and exciting opportunities in a dynamic, entrepreneurial environment.

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 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 environment
• 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

If this sounds like you and you are looking to be a part of one of Canada’s largest independent mortgage finance companies, then we want to hear from you!

Be A Part Of Something Great

MCAP is Canada’s largest independent Mortgage Finance company with over $150 billion in assets under management providing mortgage solutions for residential and commercial properties. For over 35 years, MCAP originates, trades, securitizes and services mortgages in offices across Canada. MCAP originates residential mortgages exclusively through the mortgage broker channel as we believe that a professional mortgage broker is a consumer's best option and MCAP actively promotes the services of mortgage brokers across the country. MCAP is also a leader in the Canadian residential construction lending market with over 25 years in the business. Our teams of dedicated professionals serve a variety of developer, construction and lender clients across Canada.

Position #: req2288

Employment Status: Permanent Full Time

Location: Toronto; Ontario

Number Of Openings: 1

Department: Capital Markets

Internal Job Title: Data & Business Support Analyst

Salary Range: $67,000 - $77,000

The above information in this description has been designed to indicate the general nature and level of work performed by employees in the position. It is not designated to contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.

MCAP provides equal opportunities for all applicants and is committed to fostering an inclusive, accessible environment, where all employees feel valued, respected and supported throughout the recruitment and employment process. If you require accommodation, we will work with you to meet your needs.