As a member of the Client Transition Services (CTS) team, this role handles moderate to complex data and asset transfer processes during new client plan conversions. Ensures timely and proper notification of cash flows to the Transamerica Retirement Services (TRS) Funding Group, and milestone task completion to project team members.

Responsibilities:

  • Partner with clients, vendors, payroll providers and internal resources to gather data elements for migration.

  • Establish an ongoing data dialog, via payroll files, to maintain data elements.

  • Analyze and reconcile data received against documented plan rules.

  • Post transferred records from former record systems into company system; maintain auditable records of completed conversion steps.

  • Audit, analyze and perform data quality reviews for each conversion.

  • Maintain the NBI (new business intelligence) database and transaction calendar.

  • Participate in meetings with the Implementation staff.

  • Lead and/or participate in department projects and data-specific initiatives.

  • Manage large data conversion projects.

  • Maintain department tools and procedures as assigned.

  • Identify procedural issues/gaps and recommend solutions.

Qualifications:

  • Five years of pension/retirement industry experience.

  • Five years of experience using electronic data files.

  • Working knowledge of Paris or related database systems, and SQL (AQT).

  • Experience using Informatica or Pervasive software, or related systems.

  • Written and verbal communication skills to present information to internal and external stakeholders.

  • Organizational skills and attention to detail.

  • Problem-solving and analytical skills.

  • Proficiency in MS Word/Excel.

  • Experience constructing queries.

Preferred Qualifications:

  • Proficiency in MS Access.

  • Working knowledge of Alteryx.

Working Conditions:

  • Office environment: hybrid or remote location.

Compensation:

**Please note that the compensation information that follows is a good faith estimate for this position only and is provided pursuant to applicable pay transparency and compensation posting laws. It is estimated based on what a successful candidate might be paid in certain Company locations.**

The Salary for this position generally ranges between  $62,000 - $73,500 annually. This range is an estimate, based on potential qualifications and operational needs. Salary may vary above and below the stated amounts, as permitted by applicable law.

Bonus Eligibility:

This position is also typically eligible for an Annual Bonus based on the Company Bonus Plan/Individual Performance and is at Company 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 to perform job functions, the applicable HR Business Partner should be contacted to evaluate the accommodation request.