Senior Data Consultant

Transamerica•Cedar Rapids, IA
•$70,000 - $79,000•Hybrid

About The Position

As a member of the Client Transition Services (CTS) team, the Senior Data Consultant handles moderate to complex data and asset transfer processes during new client plan conversions. The role ensures timely and proper notification of cash flows to the Transamerica Retirement Services (TRS) Funding Group and completion of milestone tasks by project team members. The position works with clients, vendors, payroll providers, and internal teams to gather and maintain data for migrations. It analyzes and reconciles incoming data against plan rules, transfers records into company systems, and performs conversion audits and data-quality reviews. The consultant also maintains conversion tools and procedures, identifies procedural gaps, and contributes to department projects and data-specific initiatives. The role is based in a hybrid office environment, with in-office work Tuesday through Thursday. Locations listed are Cedar Rapids, Denver, and Philadelphia. The stated annual salary range is $70,000–$79,000.

Requirements

  • Five years of experience in the financial services industry, including work with electronic data files.
  • Working knowledge of a record-keeping system and SQL.
  • Experience using Informatica or Pervasive software, or related systems.
  • Written and verbal communication skills for presenting information to internal and external stakeholders.
  • Organizational skills and attention to detail.
  • Problem-solving and analytical skills.
  • Proficiency in MS Word and Excel.
  • Experience constructing queries.

Responsibilities

  • Partner with clients, vendors, payroll providers, and internal resources to gather data elements for migration.
  • Establish an ongoing data dialog through payroll files to maintain data elements.
  • Analyze and reconcile received data against documented plan rules.
  • Post transferred records from former record systems into the company system and 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 create transactions.
  • Participate in meetings with 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 or gaps and recommend solutions.

Benefits

  • Competitive pay
  • Bonus for eligible employees
  • Benefits package
  • Pension plan
  • 401(k) match
  • Employee stock purchase plan
  • Tuition reimbursement
  • Disability insurance
  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Employee discounts
  • Career training and development opportunities
  • Paid time off starting at 160 hours annually for employees in their first year of service
  • Ten paid holidays per year
  • Holistic wellness program with Wellness Coaching and Reward Dollars
  • Paid parental leave for eligible employees
  • Adoption assistance
  • Employee Assistance Program
  • Back-Up Care Program
  • PTO for volunteer hours
  • Employee Matching Gifts Program
  • Employee Resource Groups
  • Inclusion and diversity programs
  • Employee Recognition Program
  • Referral bonus programs
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service