Remote Excel Jobs in Berwick, ME (NOW HIRING)

Description

Job Summary:

The Relationship Manager will serve as the main daily contact for clients and be expected to help gather data, answer questions, explain testing and calculation results, and conduct annual plan or fiduciary reviews. This will require effective verbal and written communication skills, and someone who enjoys client interaction. The Relationship Manager should be able to rely on their technical plan knowledge to effectively communicate and manage the ongoing client relationship.

Duties/Responsibilities:

• Communicate directly with clients to ensure annual census and other required plan information is received timely. 
• Review annual census and data questionnaire to ensure complete and accurate. 
• Download necessary information on plan assets for assigned clients from vendor websites.
• Provide data to the administration team so they can perform annual testing (ADP/ACP, 402(g), Top Heavy determination, 410(b), etc.) accurately and timely.
• Correct plan errors and late deferrals as needed.
• Communicate failed test results to the client in a clear and concise manner to ensure the client understands the results. Complete correction forms for client and follow-up with client and vendors as necessary to ensure the corrections were made.
• Explain employer contribution calculations and true-up contributions accurately and timely.
• Ensure required projections, tests, and calculations are completed and presented to the client as needed. 
• Ensure required government forms (Form 5500, 5330, 5558, etc.) are filed accurately and timely as required. 
• Manage ongoing client communication, timely follow-up on outstanding items, and specific needs for individual clients.
• Conduct plan sponsor fiduciary reviews annually with 3(16) clients.  
• Identify 70.5 and force out distributions for balances under $7,000.? 
• Work directly with large plan auditors and/or DOL/IRS auditors as requested.
• Perform other tasks as requested.
• Work with billing representatives to ensure clients' questions are answered on a timely basis.
• Request and enter address or contact changes in Pension Pro.
• Consult with plan sponsors on needed plan amendments and launch project in Pension Pro. Ensure delivery of documents and 
• Consult with plan sponsors on needed plan amendments and launch project in Pension Pro. Ensure delivery of document and collection of signatures.  
• Consult with Liaison with 3(16) plans to ensure payroll issues are resolved, gather census information, and facilitate the processing of additional employer contributions.  

Requirements

Required Skills/Abilities/Certifications:

• Exceptional verbal and written communication skills using clear and grammatically correct language.  
• Exceptional interpersonal and customer service skills.
• Ability to analyze, problem solve, be proactive, and demonstrate initiative.  
• Robust time management and organizational skills with the ability to multi-task required.
• Comprehensive knowledge and understanding of retirement plans and record-keeping platforms.  
• Ability to work both independently and in a collaborative team environment.
• Superb attention to detail with the ability to meet deadlines.
• Ability to function well in a high-paced environment.
• Independently manage a book of business of plans with less than 100 participants.  

Education and Experience:

• Preferred Bachelor Degree in accounting, finance, or related field.
• 3 or more years of related experience in the retirement plan industry.   
• Experience using Datair, Pension Pro, and other retirement plan verification and calculation software platforms preferred.  
• Proficient with Microsoft Office Suite applications, especially Outlook and Excel.
• Completion of the ASPPA RFP course or the ability to complete the course within one year.  

Working Conditions and Physical Requirements:

• Prolonged periods of sitting at a desk and working on a computer are required.
• Requires the ability to operate a computer, phone, keyboard, mouse, and other related office equipment.
• Requires the ability to communicate and exchange information to others over phone or video conferencing software.
• The ability to see and observe printed or electronic information on computer monitors.  
• Working conditions include a normal indoor office environment. If remote in the employee's home, the space should be free of interruptions with minimal background noise.
• Regular work hours should match those hours of the clients and other employees are working which is generally Monday through Friday in the 7:00am - 6:00pm range.

POSITION CAN BE FULLY REMOTE OR HYBRID IN OUR STRATHAM, NH OFFICE.