Pension Calculation Automation Analyst I
About The Position
The Pension Calculation Automation Analyst I develops and supports desktop tools, primarily using Excel and Visual Basic, to automate Defined Benefit (DB) calculations. The work supports pension customer experience and scalability while mitigating organizational risk. The analyst applies DB calculation knowledge to recommend improvements and serves as a resource for internal and external contacts seeking support with data, analytics, and calculations. The role analyzes, creates, and fixes defects in DB calculation tools; delivers solutions to production; and provides ongoing support for defects, fixes, and improvements. It partners with the DB plan onboarding team to configure calculation systems according to plan specifications and seeks clarification when needed. The analyst follows firm and business processes and quality standards, conducts detailed testing and quality reviews of tools and calculation outputs, raises issues and potential delays, and assists with new tools and processes. Depending on experience and assigned needs, the role also assists with mentoring and training team members. The position may be performed in-office, hybrid, or remotely. Remote arrangements are available only to people residing more than 30 miles from Des Moines, Iowa, or Charlotte, North Carolina. The posting indicates a broad target salary range of $55,800–$152,400 per year across levels and locations; the Analyst I location-specific ranges provided are $55,800–$75,600 in Wichita, $58,900–$79,800 in Des Moines, $62,000–$84,000 in Charlotte, $68,200–$92,400 in Chicago/Minneapolis, and $74,400–$100,800 in Los Angeles/New York City. Non-sales positions may participate in a bonus program. Salaried exempt employees are offered Flexible Time Off without an accrued bank or set number of days. The employer states that it is not considering candidates who need immigration sponsorship or work authorization now or in the future.
Requirements
- At least 3 years of Defined Benefit product knowledge.
- Familiarity with the Defined Benefit pension field.
- Understanding of pension administration technology and calculation formulas.
- Planning, problem-solving, analytical, time-management, decision-making, and interpersonal skills.
- Strong mathematical, technical, and analytical skills, with keen attention to detail.
- Strong written and verbal communication skills across long- and short-form formats, including the ability to explain mathematical examples clearly.
- Experience mentoring and developing junior-level team members.
- Ability to interpret sophisticated, detailed plan provisions.
- Ability to manage a full workload and prioritize.
- Ability to work as a team player and be a positive influence in a team environment.
- Strong proficiency in Excel.
- High integrity and discretion when handling sensitive client data.
Nice To Haves
- Calculation system or Defined Benefit calculation experience.
- An associate degree or higher in mathematics, actuarial science, statistics, or a similar field.
- Experience with Visual Basic.
- Experience working with databases.
Responsibilities
- Analyze, create, and fix defects in Defined Benefit calculation desktop tools.
- Deliver solutions to the production environment and provide ongoing support for defects, fixes, and internal improvements.
- Partner with and support the defined benefit plan onboarding team to set up calculation systems according to specifications and request clarification when interpreting plan specifications.
- Follow firm and line-of-business processes, protocols, and quality standards when developing and deploying solutions for implementations and ongoing servicing.
- Perform in-depth quality reviews and detailed testing of tools and calculation system output.
- Raise appropriate issues and potential delays related to desktop tool implementation or fixes.
- Assist with developing new tools, processes, and solutions to create efficiencies and business outcomes.
- Assist with mentoring, training, and developing team members on assigned items, based on experience.
- Provide services and support to internal and external contacts around data, analytics, and calculations.
Benefits
- Flexible Time Off for salaried exempt employees, with no accrued bank or set number of days.
- Non-sales positions have the opportunity to participate in a bonus program.
- Comprehensive benefit offerings intended to support employees' physical, financial, and social well-being.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Education Level
No Education Listed
