Sr. Analyst, Calculations

Why you’ll love working here:high-performance, people-focused cultureour commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selveslearning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees’ career growthmembership in HOOPP’s world class defined benefit pension plan, which can serve as an important part of your retirement securitycompetitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team's diversity and mental health (e.g., gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, parental leave top-up, and a health spending account).optional post-retirement health and dental benefits subsidized at 50%yoga classes, meditation workshops, nutritional consultations, and wellness seminarsthe opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workersJob Summary:The Sr. Calculations Analyst (“Sr. Analyst”) is primarily responsible for ensuring that quality is inherent in all HOOPP processes by supporting the mandate of the Operations Support and Actuarial Solutions area. The position requires technical expertise to perform in-house review of all technical questions regarding calculations by applying the use of the Plan Text and internal policies from the Plan Operations business. This role also requires the preparation and/or review of all calculations not performed on the administration system, assistance with certain individual member benefit costings, analysis and summary of certain demographic populations with known calculation defects (including summarizing resulting calculation details and preparation of presentation material), and assistance in modelling individual member calculations in support of the proposed Plan changes and Plan design. From time to time the role will require coordination with other areas of Operations Support (such as Data, Policy, and Operational Controls), Client Services, and PSG Pension Solutions Group.What you will do:Support the Actuarial Solutions team with the following:All off-system calculations by either reviewing or preparing for review the calculation details and any corresponding information required to be managed through the business processRecommending enhancements to calculation standards and procedures for all off-system toolsPreparation of actuarial materials for internal meetingsBeing a resource to other areas of Plan Operations for ongoing operations and for special projects when they arise from time to timeWorking with the internal HOOPP audit group as requiredSupport the Member Services Team with the following:Conduct processing reviews of cases including review of calculation methodologies, to ensure overall accuracy and quality of member filesConduct production validation of QAMs for off-system processingAnalyze data to identify quality issuesPrepare statistics reports summarizing and analyzing findingsProvide recommendations for corrections (in accordance with applicable corrections policies), where applicableRecommend improvements to methodologies as applicableLiaise with Client Services as applicableSupport the Cyclical Processes, Payroll and Data team with the following:Accountable for calculation support and audit for cyclical processes (Salary Indexing, COLA, Annual Calculations, Annual Statements, COLA Statements)Available to support data quality, actuarial and pre/post audit as requiredPerform data validations to ensure correctly imported to Ariel DB and can be used for calculation purposesBe a resource when information is needed on how data is stored in Insight/Ariel DB/Ariel PayrollProduct Support: a nalyze complex production problems related to system implementations and releases, troubleshoot for system limitations, report and escalate issues through appropriate channels.Accountable for business specifications and coordination relating to special projects including but not limited to benefit improvement, mergers, data health assessments, demographic studies, etc.Maintain a standard of information sharingEnsure other team members are up to date on any issues/workarounds/process flow changes, etc. regarding event processingMaintain contact with the Client Services Team, Training Team, Data Integration Team and other Operational Support teams as requiredMaintain actuarial tools and documentation and processes for purposes of on and off-system calculations. Update internal wiki pages with information related to calculation procedures and actuarial pagesCollaborate with other divisions of the organization, including middle to senior management, to provide direction, advice, training and recommendations for improvements / resolution on Plan provisions, administrative policy, legislative and issues that fall outside set policies and procedures, and difficult, unusual or precedent-setting casesProactively provide feedback and escalate issues, as appropriate, to ManagerParticipate in weekly project status reportsProvide ongoing training and mentoring of team membersPrepare and provide monthly and quarterly statistics for ManagerWhat you bring:University degree in actuarial science, math or statistics or a combination of equivalent training, education and experienceFive years progressive experience in the pension industry with at least four years at a pension benefits specialist/analyst levelSolid knowledge and exposure to pension plan administration and governing legislation and regulations, Pension Benefits Act, Income Tax Act, Family Law Act, Employment Standards Act and other general pension principlesSound understanding of systems and Microsoft applications (Excel, Word, PowerPoint) and relevant HOOPP or external administration software applicationsAbility to transfer knowledge to other members of the calculation teamAbility to build, maintain and update spreadsheet calculations/tools is imperative for this roleExcellent mathematical skills, analytical and problem-solving skillsTeam player with good interpersonal, oral and written communication skillsExcellent organizational and interpersonal skills and high degree of independence and initiativeStrong analytical and technical data mining skillsEffective verbal and report writing communication skillsAbility to work effectively with multiple stakeholders and influence without direct authorityPython experience is an assetThe expected annual base salary range for this role is: $71,000 - $109,000 CADThe actual base salary offered to the successful candidate may vary based on multiple factors including, but not limited to, individual's expertise and level of experience applicable to the role they are being offered.This role is eligible to participate in discretionary incentive plan(s), subject to the terms and conditions of the applicable incentive plan text.This job is for an existing vacancy. #J-18808-Ljbffr