Find work in Canada.

575,904 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 10 mins ago
AC
Pilot Training Scheduling Analyst - Temporary
Air Canada
Toronto, ON
- Full-time
Sound computer skills, including working knowledge of NetLine, Forum, Microsoft Word, Microsoft Excel and other PC applications.
Added 10 mins ago
G
IT Services Specialist
Genesys
Toronto, ON
- Full-time
Diagnose Windows, macOS, mobile device, VPN, TCP/IP connectivity, Microsoft 365, and collaboration technology issues.
Added 10 mins ago
F
Salesforce Technical Lead
Finning
Surrey, BC
- Full-time
Added 10 mins ago
Analyst, Cybersecurity
Dollarama
Mont-Royal, QC
Strong knowledge of Microsoft products (Windows 7, Windows 10, Office Suite 2007, 2010, and 2016);
Added 10 mins ago
Director of Programming and Operations
University of Guelph
Guelph, ON
Advanced technology skills, including proficiency with Microsoft Office and enterprise business systems.
Added 10 mins ago
Ward Clerk
Health Sciences North
Sudbury, ON
3. Demonstrated computer skills with advanced proficiency in Microsoft Office software (e.g. Word, Excel, Power Point and Outlook) and applicable patient information systems.
Added 10 mins ago
Intake Worker
Health Sciences North
ON · Sudbury, ON
14. Demonstrated excellent computer skills with proficiency in Microsoft Office software (e.g. Word, Excel, Power Point and Outlook) and patient information systems (e.g. Meditech, BCare).
Added 10 mins ago
Senior Sales Manager - CONFIDENTIAL
The Aldo Group Inc / Le Groupe Aldo Inc.
Montreal, QC
Proficiency in Microsoft Office, including but not limited to Excel, Word, PowerPoint
Added 10 mins ago
SAP SD Consultant Sr.
Syntax
Thornhill, ON
…has offices worldwide, and partners with Oracle, SAP, AWS, Microsoft, IBM and other global technology…
Added 10 mins ago
Lead Full Stack Engineer
Scotiabank
Toronto, ON
Apply your development experience to deliver microservices in the cloud (Google Cloud, Microsoft Azure)
Added 10 mins ago
Fraud Detection Analyst
Scotiabank
Toronto, ON
You have working knowledge of basic PC applications, including Microsoft Word and Microsoft Excel.
Added 10 mins ago
A
Cyber Security Analyst
AltaLink
Remote, Canada
- Full-time
- Remote
Working knowledge of UNIX, Linux, and Microsoft operating systems, security software and tools, working with software developers, and adhering to compliance requirements.
Added 10 mins ago
JH
AI/ML Engineer
JAVA Holdings Ltd.
Remote, Canada
- Full-time
- Remote
…to deliver secure, scalable and maintainable solutions using Microsoft technologies, third-party AI platforms and open-source…
Added 10 mins ago
PL
Project Manager - PL#60248
Peter Lucas Project Management Inc.
Dartmouth, NS
- Full-time
Proficiency with Microsoft Office, SharePoint, and project scheduling software such as Microsoft Project, Primavera P6, or equivalent.
Added 10 mins ago
PL
Project Manager - PL#60248
Peter Lucas Project Management Inc.
Halifax, NS
- Full-time
Proficiency with Microsoft Office, SharePoint, and project scheduling software such as Microsoft Project, Primavera P6, or equivalent.
Added 10 mins ago
Administrative Assistant (Bilingual)
The Canada Life Assurance Company
Montreal, QC
Added 10 mins ago
CI
Student Intern, Buyer
Celestica International LP
Newmarket, ON
- $24 to $30 CAD / hour
Data Management & Analytics: Strong proficiency in Google Sheets and Microsoft Excel, along with knowledge of Power BI.
Added 10 mins ago
CI
Student Intern, Human Resources Information Systems (HRIS)
Celestica International LP
Toronto, ON
- $24 to $30 CAD / hour
Added 10 mins ago
Project Manager
QinetiQ
Medicine Hat, AB
Proficient user of Microsoft Office Suite and project management tools, including Project Insight and Jira.
Added 10 mins ago
O
Combustion Turbine System Engineer
OpTalent
Oakville, ON
- Full-time
Added 10 mins ago
Legal Counsel
ROSEN-Group
Calgary, AB
Proficiency with Microsoft Teams, Word, Excel, and document comparison, redlining, and PDF-editing tools.
Added 10 mins ago
PL
Project Manager - PL#60248
Peter Lucas
Dartmouth, NS
- Full-time
Proficiency with Microsoft Office, SharePoint, and project scheduling software such as Microsoft Project, Primavera P6, or equivalent
Added 10 mins ago
M
Business Analyst
Manpower
Calgary, AB
- Contract
✔️ Proficiency with Microsoft Excel, Word, PowerPoint, and other business applications.
Added 10 mins ago
AE
Executive Assistant - Temporary
Arc'teryx Equipment
North Vancouver, BC
- Temporary
Added 10 mins ago
N
Client Care Associate - Group Retirement Services
Navacord
Elmira, ON
- $50,000 to $60,000 CAD / year
- Full-time
Proficient in Microsoft Office suite of products, with the ability to adapt to different systems

MCAP

Data & Business Support Analyst

Toronto, ON, Canada

Salary Range: $67,000 - $77,000 · Full-time

Apply About employer

Applications open in a new tab.

Job details

Pay: Salary Range: $67,000 - $77,000
Job type: Full-time
Posting language: English
Posted: Nov 3, 2026

Original job description

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.

Apply About employer

More about this job

Responsibilities

The role involves supporting the Capital Markets business unit through data analysis, requirements gathering, and quality assurance testing. Responsibilities also include managing portfolio insurance processes, liquidity analysis, and reporting to support informed business decisions.

Requirements

Candidates should have 3+ years of experience in QA or business analysis, preferably within the mortgage or financial industry. Proficiency in MS SQL, Excel, and strong analytical skills are required, along with an undergraduate degree in mathematics, computer science, or a related field.

Skills

Data analysis
Quality assurance
Requirements gathering
MS SQL
Data mining
Reporting
Test automation
Regression testing
Portfolio insurance
Liquidity analysis
Mortgage industry
Capital markets
MS Office
SharePoint
Azure DevOps
Problem-solving

Benefits

Competitive total rewards offering
Continuous learning and development
Formal and informal training

Visa sponsorship

Not detected in the job text

Keywords

Data analysis
Business support
Capital markets
Quality assurance
Requirements gathering
MS SQL
Data mining
Reporting
Test automation
Regression testing
Portfolio insurance
Liquidity analysis
Mortgage industry
MS Office
SharePoint
Azure DevOps
MBS
Audit support
Data integrity
Problem-solving
Analytical skills
Time management
Mathematics
Computer science
Financial services

Report this job