Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

Tailor your resume to this Data & Business Support Analyst role.

Rezi rewrites your resume against MCAP's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Data & Business Support Analyst posting at MCAP — free, in seconds.

About the Role

This position supports the Capital Markets business unit’s systems and databases, providing requirements gathering, analysis, quality assurance, and data analysis services. The role involves supporting sales and liquidity analysis, including analyzing and reporting on asset portfolios and funding programs for informed business decisions, as well as managing the portfolio insurance process.

Responsibilities

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 their use where appropriate.
Support building and maintaining various reporting templates and models.
Identify and document test cases, execution steps, required data, and expected results to validate requirements.
Participate in test automation and test strategy activities.
Execute tests as planned and record actual results for traceable documentation.
Compare actual results to expected results and analyze variances to identify defects.
Create problem logs and track defects, managing them through resolution with IT and business resources.
Summarize test results to provide documentation for IT and Business partners.
Build and enhance regression tests for supported systems.
Triage issues, confirm, and troubleshoot production defects.
Conduct post-implementation confirmation testing.
Prepare scheduled reports for Capital Markets management review.
Process insurance premium payments based on established procedures.
Collect and analyze various reports from internal counterparties for precision and accuracy.
Identify eligible mortgages for submission to the portfolio insurance program.
Assist in preparing portfolio insurance submissions and coordinate communication with insurers.
Analyze eligibility and recommend portfolios for sale transactions based on asset liquidity.
Prepare and distribute data tapes timely and accurately.
Support bulk sale submissions.
Support the audit process.
Produce and deliver post-settlement documents.
Perform ad-hoc tasks and analysis upon management's requests timely and accurately.
Create and maintain procedure documents.
Provide documents and samples for audit.
Process contractual repurchases.
Run and save query results from various systems and databases.

Requirements

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.

Skills

Data analysis
Data mining
Reporting
Quality assurance
Testing
Requirements gathering
Business analysis
MS SQL queries
MS SharePoint
Azure DevOps
MBS/Mortgage Industry
Capital Markets
Microsoft Office (Excel, Word)
Project management
Communication
Organization
Time management
Problem-solving
Relationship building
Attention to detail

Location

Toronto, Ontario

Work Type

Permanent
Full Time
Onsite

Experience Level

3+ years QA/BA experience
3+ years mortgage/financial industry experience

Education Level

Undergraduate degree in mathematics, computer science, or equivalent

Salary/Compensations

$67,000 - $77,000

Benefits

Competitive total rewards offering
Career with continuous learning and development (formal & informal training)
Exciting opportunities in a dynamic, entrepreneurial environment

About the Company

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.
MCAP is also a leader in the Canadian residential construction lending market with over 25 years in business.
Our teams of dedicated professionals serve a variety of developer, construction and lender clients across Canada.

Equal Opportunity

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.