Data Analyst – Group Retirement Solutions

Job CategoryInformation Technology
Position TypeContract
Application Deadline November 25, 2019
Experience Required1 year
Job Duration6 months
Education RequiredCollege Diploma

Our client in Banking & Finance industry is seeking a Data Analyst – Group Retirement Solutions in Montreal. This is a 6 months contract position.
Job Description
The Bank`s Life Assurance’s Group Retirement Solutions (GRS) business develops and implements de-risking solutions for defined benefit pension plans. To support this growing business, The Bank`s Life Assurance is seeking a Group Annuity Analyst to join the Group Retirement Solutions team that is responsible for Benefit Administration; this is part of the Actuarial Pricing department.
Reporting to the Head of Client Relations, the successful candidate will support the business administration & implementation of new groups. The incumbent will also participate in other special projects as assigned.
This role is accountable for providing, business management, client relations support and process improvement. This is achieved by working closely with Group Annuity Clients, Actuarial Consulting Firms, Group Annuity Pricing Team, Customer Service Center and providing support where required.
Team collaborative environment – team of 4
EVP (Employee Value proposition):
Great opportunity to grow and great exposure to many different groups/client
RESPONSIBILITIES INCLUDE (but are not limited to):
Main responsibility will be to convert data from current in house platform to a third party administrator platform.
• data conversion from in house platform to third party administrator platform
• Provide oversight on improvement on data conversion tool
Other responsibilities include the following, but not limited to:
A. Business Management
• Handle inquiries from external Consulting Firms and internal partners in regards of group annuity
• Handle the monthly reconciliations of health premiums and secondary insurer payments for active groups
• Maintain up to date data records of ongoing changes that impact pricing (premium reconciliation process)
• Act as an Client Relations liaison between other departments on special projects or initiatives

B. New Business Support and Reporting
• Develop, analyze and provide management information reports as needed
• Prepare Database and files to facilitate data transfer
• Prepare contract documentation to be sent to new policyholders
• Prepare annual reports to be sent to annuitants
• Carry out functions with an extremely high sense of urgency
• Work in tandem with Customer Service Center to support the New Business Implementation process

C. Process improvement
• Provide expertise and insight to support process improvement
• Act as a Insurance liaison with external vendors providing services to Insurance in order to improve business process or develop new markets
• 1-3 years of experience in data analytics
• Good knowledge of the regulatory and tax requirements
• Advanced Microsoft Excel and Word skills, programming language (eg phyton)
• Experience with an in house Pension plan/ or large corporation/consulting firms
• Good knowledge of group annuity products and sales channels
• French (oral & written) is a definite asset
• Good knowledge of the regulatory and tax requirements from a pension perspective
• pension background
• Strong written and verbal communication skills
• In-depth analytical and problem-solving skills
• Strong relationship management skills
• Excellent organization skills
• Keen attention to detail.
• Undergraduate university degree
• Pension industry and Life insurance related education (e.g.: CEBS, LOMA,) is an asset
• Knowledge of the Bank`s Insurance systems (CAPSIL, Work Management and Alias) is an asset.
• Job hopping (without explanation)
• Short tenure (without explanation)
• if someone has pure insurance experience without pension admin would be a pass

INTERVIEW DETAILS: 1 round – in person
WHAT TYPE OF INTERVIEW WILL THIS BE?: panel or 2 separate interviews but would be the same day.
INTERVIEWERS: HM and team member

Candidates must be in Canada and with valid work permit for being able to apply for this role.
Please reply to: