Data Analyst


Posted 8 months ago
We are looking for a Data Analyst! Reach out if you are interested and feel free to refer friends/colleagues!


Type of Employment: Contract
Title: Data Analyst
Term: Contract – 6 months with extension
Location: Hybrid from Toronto – twice a week
Job ID number: C1314


Brief Description on Duties: 


The Business Development Sales Compensation team is responsible for the administration of the Business Development Sales Incentive Plan (SIP), within Group Benefits. Reporting to the Manager of Sales Compensation, the Compensation Analyst with will join a team that is responsible for the calculation of all incentive payments, onboarding new employees to the program, and supporting the sales team with inquiries, reporting and tools. The team partners with various areas such as HR, Finance, and GB Operations to obtain the necessary information in order to complete our end to end incentive payment process.

Qualified candidates will be highly organized, detail-oriented, computer and tech savvy and an excellent communicator with a professional demeanor and phone presence. Superb response to inquiries with the ability to question items and possessing an ongoing process improvement mindset. The Analyst has the ability to work both in a team environment and independently with little direction, outstanding initiative and ability to maintain confidential information.

What will you do?

  • Accurately and precisely calculate monthly and quarterly sales incentive bonuses
  • Calculate Sales Recognition Conference points on a quarterly basis to determine who is on track to qualify for the Conference
  • Work with the Manager of Sales compensation on quarterly earnings reporting
  • Onboard new sales staff with 1:1 training on their sales incentive plan to ensure they know the plan details, how it’s administered, and reporting available
  • Provide ongoing support in resolving calculation-related inquiries and exceptions with the sales teams
  • Maintain and enhance process documentation
  • Identify and participate in process improvement projects
  • Develop and maintain tools that support sales staff
  • Attend / present sales staff training sessions (joining Regional team meetings to present on compensation, help present to new hires at AE Academy)
  • Support the planning of the Sales Recognition Conference as required
  • Partner with HR and Finance on quarterly and annual reporting as requested
  • Support the Manager of Sales Compensation with modelling of potential plan changes

What do you need to succeed?

  • Post-Secondary education or equivalent 3-5 years work experience
  • Advanced Microsoft Excel skills (e.g., V-lookup, pivot tables, formulas, formatting, macros)
  • Strong mathematical, analytical, problem solving and financial modeling skills, with an eye for detail and accuracy
  • Ability to handle confidential information in a professional and discreet manner
  • Excellent written and oral communication
  • Ability to develop and maintain strong relationships with a customer focus
  • Excellent initiative to plan and manage work independently, including proactively solving problems and identifying ways to improve work processes and practices
  • Process driven, yet able to be resourceful and adaptable
  • Ability to deliver on commitments working independently to meet tight deadlines
  • Able to multi-task and adjust to shifting priorities, demands and timelines
  • Flexibility with hours in order to meet deadlines


  • Sound knowledge of Group Benefits products and services
  • Experience working with Sharepoint online


  • The incumbent may be required to work some overtime to meet quarterly payroll deadlines



Job Features

Job CategoryData analyst

Apply Online