Virtual Assistant Excel Jobs in Fishers, IN (NOW HIRING)

FuturePlan is the nation's largest third-party administrator (TPA) of retirement plans, partnering with advisors in all 50 states. FuturePlan delivers the best of both worlds: high-touch personalized service from local TPAs backed by the strength and security of a large national firm, Ascensus. Our roots go back decades, with nearly 30 outstanding legacy firms now joined together to deliver unmatched levels of service, innovation and expertise to a fast-growing client base from coast to coast. The FuturePlan team includes more than 500 credentialed plan professionals, 60 actuaries, and one of the industry's largest in-house ERISA teams. Learn more at FuturePlan.com.

Section 1: Position Summary

Timely and accurate completion of contribution calculations and annual nondiscrimination testing for small to medium combo 401(k)/Cash Balance plans. Be a technical resource for consultants and other team members.

Section 2: Job Functions, Essential Duties and Responsibilities

• Review employee census data and prepare questions for the client as needed
• Perform nondiscrimination testing including ADP/ACP, 410(b), 401(a)(4), and 401(a)(26) for small to medium size 401(k)/cash balance combo plans of intermediate complexity
• Calculate options for failed tests with minimal assistance
• Complete DC balance forward valuations and related journals and participant statements
• Calculate cash balance contributions and earnings, and prepare journals and participant statements
• Perform self-employment income calculations
• Perform year-end estimates and plan design studies and projections
• Perform and review trust accounting and Forms 5500-SF
• Perform technical research and assist consultants with compliance and plan design issues
• Identify consulting opportunities and propose recommendations to add value
• Recommend and support improvements to testing procedures and programs, including testing of new systems and writing procedures
• Actively participate in team meetings and collaborative discussions
• Provide backup support and additional tasks as assigned
• Independently manage assigned workload and update workflow system daily
• Complete projects accurately, efficiently, and timely
• Responsible for protecting, securing, and proper handling of all confidential data held by Ascensus to ensure against unauthorized access, improper transmission, and/or unapproved disclosure of information that could result in harm to Ascensus or our clients.
• At Ascensus we are guided by our Core Values of People Matter, Quality First and Integrity Always. They inspire us every day to prioritize an environment of respect for those we serve and one another and should be visible in your actions on a day-to-day.

Supervision

• N/A

Section 3: Experience, Skills, Knowledge Requirements

• Minimum of 3 years of experience administering 401(k)/Profit Sharing/Cash Balance plans
• Intermediate to advanced experience performing DC nondiscrimination testing including carve-outs, new comparability, gateway, and top-heavy
• Hands-on cash balance experience (calculating hypothetical contributions, performing 401(a)(26) and combo DC/CB nondiscrimination testing).
• Intermediate to advanced understanding of retirement plan regulations
• Strong verbal and written communication skills, with the ability to clearly explain technical concepts
• Attention to detail and accuracy
• Strong analytical and problem-solving abilities
• Intermediate proficiency in Excel
• Basic accounting skills
• Ability to work independently as well as collaborate with others
• Self-starter with strong organization, time management, and project management skills
• Ability to manage multiple priorities and adjust to changing business needs
• Reliable and accountable with a proven ability to follow through on commitments and responsibilities
• Commitment to professional development and retirement industry education. ASPPA CPC or QPA designation preferred
• Availability to work overtime when business needs require
• Comfortable working in a fast-paced remote environment

For all virtual remote positions, in order to ensure associates can effectively perform their job duties with no distractions, we require an uninterrupted virtual workspace and there is also an expectation of family care being in place during business hours. Additionally, there is an internet work speed requirement of 25 Mbps or better for individual use. If more than one person is utilizing the same internet connection in the same household or building, then a stronger connection is required.If you are unsure of your internet speed, please check with your service provider. Note: For call center roles specifically, it is a requirement to either hardwire your equipment directly to the internet router or ensure your workstation is in close proximity to the router. Please ensure that you are able to meet these expectations before applying.

We are proud to be an Equal Opportunity Employer

Be aware of employment fraud. All email communications from Ascensus or its hiring managers originate from @ascensus.com or @futureplan.com email addresses. We will never ask you for payment or require you to purchase any equipment. If you are suspicious or unsure about validity of a job posting, we strongly encourage you to apply directly through our website.