Defined Benefit Analyst V

Principal Financial Services • Des Moines, IA

281d • $63,750 - $147,600 • Remote

About The Position

We're looking for a Defined Benefit Analyst V to join our Defined Benefit Actuarial Services team. In this role, you'll lead the data conversion validation efforts for large market clients. You'll deliver meaningful analysis ensuring a smooth conversion, implementation, and ongoing administration for our Defined Benefit clients! Coordinate and collaborate with implementation team to share information about the conversion data, complete data mapping, solve data related issues and load data in test environment. Analyze the conversion data to determine data gaps and develop understanding of content. Collaborate with vendor and client to present analysis and resolve issues / questions. Thorough documentation and communication of data load process, assumptions, and issue resolutions. Lead ongoing payroll implementations with the client and vendors. Identify, map, and communicate ongoing data needs to effectively support the ongoing administration needs. Lead and coordinate the internal and external testing efforts around data components, including active and terminated vested data conversion, retiree payment conversion and payroll set up.

Requirements

• Bachelor degree preferably in an analytical field (such as Math, Actuarial Science, Statistics).
• 5+ years of work related experience in defined benefit pension systems.
• 3+ years of previous experience working and analyzing large data sets.
• Experience implementing ongoing data feed in support of defined benefit administration functions.
• Proficient in spreadsheet and database software, SQL experience and familiarity with hierarchical data models.
• Strong mathematical, technical and analytical skills with keen attention to detail.
• Excellent presentation and communication skills.
• Strong decision making and organizational skills.
• Ability to interpret complex plan provisions and take proactive measures.
• High integrity and discretion to ensure confidentiality of sensitive client data.

Nice To Haves

• Extensive testing experience with the ability to perform detailed and precise data validation.
• Payroll experience or familiarity with payroll systems.

Responsibilities

• Lead the data conversion validation efforts for large market clients.
• Deliver meaningful analysis ensuring a smooth conversion, implementation, and ongoing administration for Defined Benefit clients.
• Coordinate and collaborate with implementation team to share information about the conversion data.
• Complete data mapping, solve data related issues and load data in test environment.
• Analyze the conversion data to determine data gaps and develop understanding of content.
• Collaborate with vendor and client to present analysis and resolve issues/questions.
• Document and communicate data load process, assumptions, and issue resolutions.
• Lead ongoing payroll implementations with the client and vendors.
• Identify, map, and communicate ongoing data needs to support ongoing administration.
• Lead and coordinate internal and external testing efforts around data components.

Benefits

• Flexible Time Off (FTO) for salaried employees.
• Pension Eligible.
• Opportunity to participate in a bonus program.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Bachelor's degree