Data Analyst

Location : Toronto, ON (Currently 100% Remote, possibility of changing to hybrid)

Duration : 12 months

Contract Type : T4 only

Pay Rate : CA$28.60 / Hour

Job Description :

• The role is responsible for the timely calculation, processing and reconciliation of commission compensation for Mortgage Specialists (MSs).
• Completion of bi-weekly reporting for payroll submission, monthly sales reporting and yearly sales incentive calculations.

Key Accountabilities:

• Administration of the sales compensation database.
• Daily review of mortgage deals to ensure proper classification for compensation, including identifying new clients.
• Investigation of commissions and general compensation questions coming from MSPROGRAM.
• Respond to MSPROGRAM questions and emails in a timely manner.
• Approving and implementing manual adjustments to compensation as required.
• Processing business expenses for mortgage specialists against their compensation, for Mortgage Specialist Assistants.
• Review and action reports from the compensation database to ensure deals pay properly and amend compensation as required.
• Review and action reports related to deal cancellations of mortgages and process recoveries from the MSs.
• Review and action reports related to insurance cancellations and process recoveries from the MSs.
• Review and action reports related to appraisal fee violations and process recoveries from the MSs.
• Produce bi-weekly payroll reports to be submitted to Alight.
• Process insurance payouts including investigations with SunLife for missing deals and production of monthly invoice.
• Produce monthly management reports.
• Produce ad-hoc reports as required.

Job Requirements: Knowledge and Skills:

• Comfortable working with numbers.
• 2-3 years relevant experience; experience managing sales compensation plans is an asset.
• Business-related degree/diploma.
• Self-motivated and able to meet deadlines.
• Able to collaborate with immediate team as well as the team in MSPROGRAM and Pricing.
• Strong knowledge of MS Office (EXCEL and ACCESS specifically).

Nice to Have:

• Bilingual - Bill 96 Quebec Mortgage Specialists are required to have payroll in French.