Pension Risk Transfer Business Consultant

at  MassMutual

THE OPPORTUNITY

The Pension Risk Transfer Business Consultant provides technical support for the Pension Risk Transfer administration team. The Business Consultant supports the new business process by programming the calculation system with plan-specific provisions and working with Data Analysts to ensure the quality of incoming participant/annuitant data. The Business Consultant supports on-going contract administration by troubleshooting and correcting setup errors, debugging existing script programming, and adding new code for existing contract builds. Additionally, collaboration with digital experience operations as a subject matter expert, helping to support Pension Risk Transfer innovation.

THE MINIMUM QUALIFICATIONS

• 3+ years of experience in Defined Benefit or Pension Risk Transfer calculations.
• 1+ year of experience with back-end use of calculation systems.
• 2+ years of experience working Microsoft Excel with the ability to use complex formulas and data management functions.
• Bachelor’s degree or HS diploma with 5+ years of experience in Defined Benefit or Pension Risk Transfer calculations.

THE IDEAL QUALIFICATIONS

• Bachelor’s degree in mathematics or finance
• Experience working with FIS OmniDBEN a plus.
• Experience working with Vitech V3locity a plus.
• Intermediate knowledge of programming in OmniScript.
• Experience writing and understanding code language (e.g. python, JavaScript, java, c+/c++, SQL)
• Knowledge of complex pension and actuarial concepts.
• Operates from a mentality of end-to-end ownership.
• Strong project management skills.
• Ability to manage multiple urgent priorities.
• Continuous Improvement mindset, with effective execution.
• Excellent analytical and problem-solving skills.
• Strong written and verbal communication skills – ability to explain technical concepts to clients or internal partners at a level appropriate for their background.

• Understand complex calculation concepts for plans with different benefit structures.
• Identify data elements needed for benefit calculations.
• Work with business partners to ensure annuitant data is complete and formatted correctly for use by the calculation system.
• Apply calculation concepts to produce expected results for system testing.
• Translate standard plan provisions into formula elements within the calculation system.
• For non-standard provisions of varying levels of complexity, develop script programming required to produce expected results.
• Identify and implement required changes to an existing contract setup when errors in the calculation are reported.
• Debug existing script code when errors in the calculation are reported.
• Test and document system output to ensure accuracy of benefit calculations.
• Build and support benefit calculation worksheets utilized by business partners.
• Analyze Bid Specifications and Requests for Proposals (RFPs) for New Business Sales.
• Ability to manage and prioritize multiple daily tasks and projects successfully