DB Senior Client Calc Automation Manager

Alight Solutions; Toronto; On-site; CAD 84,000 - 169,000; Full time

Job summary

A leading consulting firm is seeking an Actuarial Support Group Consultant in Toronto. This role involves performing defined benefit calculations, consulting clients on actuarial concepts, and creating Excel tools. The ideal candidate has a Bachelor's degree in a relevant field and 5+ years of experience in actuarial services. Expertise in Canadian pension plan regulations is required.

Benefits

Health coverage options

Retirement plans

Flexible working arrangements

Continuing education and training

Qualifications

• Must have effective communication skills for domain and technical matters.
• Proven analytical abilities when dealing with complex data.
• Proficiency in Excel including advanced functions.

Responsibilities

• Perform manual defined benefit calculations.
• Consult with clients on actuarial concepts.
• Create and maintain calculation tools in Excel.

Skills

Effective communication skills

Proven analytical abilities

Attention to detail

Expertise in actuarial principles

Proficiency in Excel

Experience in VBA for Excel

Knowledge of Canadian pension plan rules

Education

Bachelor's degree in mathematics, statistics, actuarial science, finance, or equivalent

5+ years of relevant work experience

Job description

Actuarial Support Group Consultant

Overview

The Actuarial Support Group (ASG) Consultant collaborates with client delivery teams to support defined compensation calculations and projects. This role involves independent work with peer review, interpreting complex DB requirements, consulting with clients, and proficiency in Excel and coding principles. The position requires knowledge of DB regulations.

Responsibilities

• Having the ability to perform manual defined benefit calculations and create/maintain calculation tools in Excel.
• Addressing questions related to complex situations, participant inquiries, client escalations, and participant calculations in regard to defined benefits.
• Consulting with clients on a variety of actuarial concepts and facilitate interactions with third party actuaries, plan sponsors, ERISA counsel, and client finance department contacts.
• Consulting with clients and client teams on how new legislation would impact their plans’ calculation methodology.
• Executing large scale calculation projects and write complex plan requirements.
• Consulting with internal colleagues, clients, and third parties to resolve issues or differences related to actuarial concepts.
• Creating actuarial factors and factor tables. This sometimes involves determining a factor’s formula based on the stream of payments.

Qualifications

• Have effective communication skills on domain and technical matters, internally and externally.
• Have proven analytical abilities and attention to detail when working with complex data.
• Have a solutions-oriented mindset with the ability to report data to stakeholders.
• Have expertise in actuarial principles and relevant systems.
• Have proficiency in Excel, including the ability to create complex calculation spreadsheets and utilize advanced Excel functions.
• Have advanced management and organizational skills with the ability to adapt to change.
• Have some experience in VBA for Excel to automate and enhance actuarial calculations and processes.
• Expertise in Canadian pension plan rules and regulations.
• Working knowledge and familiarity with US pension plan rules and regulations.

Education

• Bachelor's degree in mathematics, statistics, actuarial science, finance, or equivalent work experience.
• 5+ years of relevant work experience in actuarial services or related fields.
• Ability to learn through formal and on-the-job training.

Other Details

Alight requires all virtual interviews to be conducted on video.

Flexible Working

So that you can be your best at work and home, we consider flexible working arrangements wherever possible. Alight has been a leader in the flexible workspace and “Top 100 Company for Remote Jobs” 5 years in a row.

Benefits

We offer programs and plans for a healthy mind, body, wallet and life because it’s important our benefits care for the whole person. Options include a variety of health coverage options, wellbeing and support programs, retirement, vacation and sick leave, maternity, paternity & adoption leave, continuing education and training as well as several voluntary benefit options.

By applying for a position with Alight, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Alight’s employment policies. Background checks may include some or all the following based on the nature of the position: SSN/SIN validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position.

Our commitment to Inclusion

We celebrate differences and believe in fostering an environment where everyone feels valued, respected, and supported. We know that diverse teams are stronger, more innovative, and more successful. At Alight, we welcome and embrace all individuals, regardless of their background, and are dedicated to creating a culture that enables every employee to thrive. Join us in building a brighter, more inclusive future.

As part of this commitment, Alight will ensure that persons with disabilities are provided reasonable accommodations for the hiring process. If reasonable accommodation is needed, please contact [e-mail].

Equal Opportunity Policy Statement

Alight is an Equal Employment Opportunity employer and does not discriminate against anyone based on sex, race, color, religion, creed, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, marital or domestic partner status, citizenship, military or veteran status, sexual orientation, gender, gender identity or expression, genetic information, or any other legally protected characteristics or conduct covered by federal, state, or local law. In addition, we take affirmative action to employ, disabled persons, disabled veterans and other covered veterans.

Alight provides reasonable accommodations to the known limitations of otherwise qualified employees and applicants for employment with disabilities and sincerely held religious beliefs, practices and observances, unless doing so would result in undue hardship. Applicants for employment may request a reasonable accommodation/modification by contacting their recruiter.

Authorization to work

Applicants must have work authorization in the Employing Country and must not require sponsorship now or in the future.

Note: this job description does not restrict management's right to assign or reassign duties and responsibilities to other entities, including subsidiaries, partners, or purchasers of Alight business units.

We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.

Salary Pay Range

Minimum: 84,900 CAD

Maximum: 169,000 CAD

Pay Transparency Statement: Alight considers a variety of factors in determining whether to extend an offer of employment and in setting the appropriate compensation level, including, but not limited to, a candidate’s experience, education, certification/credentials, market data, internal equity, and geography. Bonus and/or incentive eligibility are determined by role and level.

Nothing in this job description restricts management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units.