Senior Business Analyst
Custom Software Systems, Inc.
SQL
Senior Benefit Calculation Analyst
Legal & General Retirement America
full-time
Posted on:
Origin: • 🇺🇸 United States
Visit company websiteSalary
💰 $70,000 - $80,000 per year
Job Level
Senior
Tech Stack
SQLVBA
About the role
- Define, develop, and implement Group Annuity Contract specific standard methodologies and procedures which align with benefit specifications and associated plan or client requirements and comply with new or existing federal and state regulatory laws.
- Understand complex pension calculation concepts for plans with different benefit structures.
- Properly administer contracts in accordance with the plan sponsor requirements, with a focus on the deferred population and executing benefit calculations.
- Support administration system transformation and new cases including creating test plans, plan specifications, and administering calculation testing of existing and new cases.
- Process and handle monthly payments, new payment set ups, death processing and monthly reconciliation of files.
- Assist or handle complex cases. Provide appropriate paperwork for new payments including QDRO’s and benefit quoting.
- Assist Transition team with onboarding of new pension risk transfer plans and validating data in servicing systems, including mapping of deferred data fields in onboarding files and testing of the integration between the administration system and the calculator.
- Create sample calculations for confirmation with Plan Sponsors to create clear documentation of GAC interpretation of benefit calculations.
- Implement process automation solutions to deliver system improvements. Validate systems and workflows to ensure all new processes are functioning correctly including conducting UAT for system modifications. Identify defects and define options for remediation.
- Collaborate on project scope, issues, and options. Accurately plan and appropriately complete projects. Participate in accurate and complete testing of new system updates.
- Identify, track and report issues in a timely manner. Promptly provide comments, feedback, and recommendations.
- Deliver training to junior team members as needed.
- Participate in delivering continuing training to other departments on benefit calculation topics as needed.
- Develop and document procedure manuals for Retirement Support Services.
- Complete all other tasks and projects.
Requirements
- Bachelor’s Degree in a related field or equivalent work experience.
- 3+ years of retirement plan administration experience, including in depth pension benefit calculation knowledge.
- Strong analytical, organizational, and project management skills.
- Ability to balance multiple priorities in a fast-paced environment.
- Display history of building trust and developing team relationships.
- Exceptional oral and written communication skills as well as presentation skills; ability to deliver information in a concise manner.
- Advanced spreadsheet proficiency (Excel).
- Database capabilities (VBA, SQL) a plus.
- Proficiency in Microsoft Office product suite.
- Willingness to travel as needed.
