Pension Calculation Automation Analyst I

Principal Financial GroupDes Moines, IA
3d$55,800 - $152,400Hybrid

About The Position

As a Pension Calculation Automation Analyst I, you will get the opportunity to complete desktop tool coding primarily within Excel and Visual Basic – related to Defined Benefit (DB) calculation automation to drive pension customer experience, scalability, and mitigate risks for the organization. Use DB calculation experience to provide recommendations for improvements and automation. Serve as an expert for internal and external contacts by providing services and support around data, analytics, and calculation. Responsible for analyzing, creating, and fixing defects within DB calculation desktop tools. Deliver the solution to the production environment and provide ongoing support for defects/fixes and internal improvements as necessary. Partner and support defined benefit plan onboarding team to assure that the calculation system can be set up according to specifications and request clarification as necessary when interpreting plan specifications. Follow firm and line of business processes, protocols and quality standards in the development and deployment of solutions for all implementations and ongoing servicing. Perform highly in-depth quality reviews through detailed testing for tools and calculation system output. Raise appropriate issues and potential delays related to desktop tool implementation or fixes. Assist with development of new tools, processes, and solutions to create efficiencies and business outcomes. Assist with mentoring, training, and development of team members on specific items assigned, based upon experience.

Requirements

  • 3+ years of DB product knowledge.
  • Familiarity within DB pension field required.
  • An associate degree or higher in math, actuarial science, statistics, or a similar field is helpful.
  • Understanding of pension administration technology, calculation formulas.
  • Planning, problem solving, analytical, time management decision making, and interpersonal skills required.
  • Strong mathematical, technical, and analytical skills along with keen attention to detail.
  • Strong communication skills across multiple mediums – including both long- and short- form written and verbal formats. Ideally able to illustrate mathematical examples in an easy to digest format.
  • Experience mentoring and developing junior level team members.
  • Ability to interpret sophisticated, detailed plan provisions.
  • Ability to handle a full workload and prioritize.
  • Be a team player and a positive influence in a team environment.
  • Strong proficiency in Excel is required, experience with Visual Basic is preferred.
  • High integrity and discretion to ensure the confidentiality of sensitive client data.

Nice To Haves

  • Calculation system or DB calculation experience preferred.
  • Experience working with databases is preferred.

Responsibilities

  • Complete desktop tool coding primarily within Excel and Visual Basic – related to Defined Benefit (DB) calculation automation to drive pension customer experience, scalability, and mitigate risks for the organization.
  • Use DB calculation experience to provide recommendations for improvements and automation.
  • Serve as an expert for internal and external contacts by providing services and support around data, analytics, and calculation.
  • Responsible for analyzing, creating, and fixing defects within DB calculation desktop tools.
  • Deliver the solution to the production environment and provide ongoing support for defects/fixes and internal improvements as necessary.
  • Partner and support defined benefit plan onboarding team to assure that the calculation system can be set up according to specifications and request clarification as necessary when interpreting plan specifications.
  • Follow firm and line of business processes, protocols and quality standards in the development and deployment of solutions for all implementations and ongoing servicing.
  • Perform highly in-depth quality reviews through detailed testing for tools and calculation system output.
  • Raise appropriate issues and potential delays related to desktop tool implementation or fixes.
  • Assist with development of new tools, processes, and solutions to create efficiencies and business outcomes.
  • Assist with mentoring, training, and development of team members on specific items assigned, based upon experience.

Benefits

  • Flexible Time Off (FTO) is provided to salaried (exempt) employees and provides the opportunity to take time away from the office with pay for vacation, personal or short-term illness.
  • Employees don’t accrue a bank of time off under FTO and there is no set number of days provided.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume

What This Job Offers

Job Type

Full-time

Career Level

Entry Level

Education Level

Associate degree

Number of Employees

5,001-10,000 employees

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service