Data Analyst

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

Assets:

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

Other:

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