Respond to inquiries and requests related to retirement systems and production processing of participant and client data. Analyze and work on system issues, database corrections, database updates/conversions, system testing and requirements, and report design for Operations departments. Consider financial impact and risk to participants, clients, and business units in all aspects of day-to-day work.

Responsibilities:

  • Create and process queries from multiple system tables.

  • Act as a liaison between business units and IT groups to correct and/or report system issues; create intake tickets (JIRA) with appropriate documentation.

  • Perform production table updates, inserts, and deletions using DB2 SQL and Microsoft SQL Server; maintain integrity and accuracy of data on multiple databases/systems.

  • Troubleshoot application/process issues to help identify the “root” cause and impact to stakeholders.

  • Interpret and communicate information to end users, management, and development/systems staff.

  • Compile training materials and conduct training as assigned for peers and business units; assist in communicating process improvements.

  • Develop a solid understanding of data structures within various system databases, including Paris 3, PSD, Pegasys, Fund Wizard, Taxport, CMS, and Edocs.

  • Provide data to various business units for mass mailings.

  • May participate in cross-functional project teams for new systems development and assist documentation of system and business requirements.

  • Perform testing of system changes for usability, performance, and adherence to standards; documents and report results to development team.

  • Collaborate with peers to ensure work items are completed within set timing standards as determined by priority level.

Qualifications:

  • Bachelor’s degree in a business or IT field, or equivalent education/experience

  • Two years of pension, accounting, and/or technical experience

  • Good understanding of retirement operations processes

  • Technical aptitude to work with mainframe (Paris), Linux, DB2 SQL, MS SQL Server, etc.

  • Analytical and problem-solving skills

  • Written and oral communication skills

  • Organizational skills and attention to detail

  • Proficiency using MS Office (Excel, Word, SharePoint, Access)

Preferred Qualifications:

  • Experience with AWD, Linux, DB2 SQL, and Microsoft SQL Server.

Working Conditions:

  • Hybrid: Tuesday - Thursday

Locations:

  • Cedar Rapids, IA

  • Baltimore, MD

  • Denver, CO

The Salary for this position generally ranges between $27 - $31 per hour. Please note that the salary range is a good faith estimate for this position and actual starting pay is determined by several factors including qualifications, experience, geography, work location designation (in-office, hybrid, remote) and operational needs. Salary may vary above and below the stated amounts, as permitted by applicable law.

Additionally, this position is typically eligible for an Annual Bonus based on the Company Bonus Plan/Individual Performance and is at the Company’s discretion.

This job description is not a contract of employment nor for any specific job responsibilities. The Company may change, add to, remove, or revoke the terms of this job description at its discretion. Managers may assign other duties and responsibilities as needed. In the event an employee or applicant requests or requires an accommodation in order to perform job functions, the applicable HR Business Partner should be contacted to evaluate the accommodation request.