Skip to main content
Home
  • About us
    • Our company
    • Our strategy
    • Our purpose
      • Our purpose
      • Our brands
      • Community investments
    • Governance
      • Governance structure
      • Board of Directors
      • Executive Committee
      • Governance documents
    • Compliance
      • Group Compliance
      • Insider Dealing
      • Code of Conduct
      • Speaking up
      • Workplace harassment prevention
      • Financial Economic Crime
      • Compliance documentation
  • Investors
    • Annual reports
    • Financial results
    • Presentations
    • Shareholder meetings
      • Annual General Meeting
      • Extraordinary General Meeting
    • Financial calendar
    • Dividend
      • Latest
      • Dividend history
      • Dividend policy
    • Share buybacks
    • Debt and ratings
      • Guiding principles
      • Debt programs
      • Senior notes
      • Capital securities
      • Fixing Schedule Perpetuals
      • Subordinated notes
      • Ratings
    • Investor information
      • Contact investor relations
      • Major shareholders
      • Retail US shareholders
      • Financial and shareholder FAQs
      • Share price tool
      • Financial calendar
  • Media
    • All news
    • Contact media relations
    • Media kit
  • Sustainability
    • Our priorities
      • Climate change
      • Inclusion and diversity
    • Our approach
    • Our commitments
    • Our ratings
    • Our reports and policies
    • Business conduct
      • Human rights
      • Responsible investment
      • Responsible tax
      • Responsible procurement
      • Government and policy affairs
  • Careers
    • Vacancies
      • Search
    • Why Aegon
    • Inclusion & Diversity
    • Career development
    • Graduates and interns
  • Aegon country websites

    Select another Aegon website from the list of links below.
    • country flag
      Aegon Life (India)
    • country flag
      Transamerica (USA)
    • country flag
      Aegon Spain
    • country flag
      Mongeral Aegon (Brazil)
    • country flag
      Aegon Asset Management
    • country flag
      Aegon in China
    • country flag
      Aegon United Kingdom

Data Consultant

Full Time
Customer Service
United States

Breadcrumb

  1. Vacancies
As a member of the Client Transition Services (CTS) team, handles 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.

Qualifications

  • Two years of pension/retirement industry experience.

  • Two years of experience using electronic data files.

  • Organizational skills and attention to detail.

  • Problem-solving and analytical skills.

  • Written and verbal communication skills.

  • Working knowledge of database systems and SQL (AQT)

  • Knowledge of data transformation software.

  • Proficiency in MS Word/Excel.

Preferred Qualifications

  • Proficiency in MS Access.

  • Experience using Informatica software and/or Paris database system.

Working Conditions

  • Work from Home/Remote

  • Please note that the compensation information that follows is a good faith estimate for this position only and is provided pursuant to the Colorado Equal Pay for Equal Work Act and Equal Pay Transparency Rules. It is estimated based on what a successful Colorado applicant might be paid. It assumes that the successful candidate will be in Colorado or perform the position from Colorado. Similar positions located outside of Colorado will not necessarily receive the same compensation. **

Compensation:

The Salary for this position has a target range of $48,500 - $64,500 per year.

This is an estimate, based on potential employee qualifications, operational needs and other considerations permitted by law. The range may vary above and below the stated amounts, as permitted by Colorado Equal Pay Transparency Rule 4.1.2.

Bonus Eligibility: This position is also typically eligible for an Annual Bonus Target of 7.5% based on the Company Bonus Plan/Individual Performance and is at Company Discretion.

Apply

Related Vacancies

Intermediate Client Onboarding Manager
SR CTS Quality Consultant
Director Segmentation and Portfolio Optimization (Work From Home)
Intermediate Operations Compliance & Process Analyst
Apply
  • About us
    • Our company
    • Our strategy
    • Our purpose
    • Contact Aegon
  • Investors
    • Annual reports
    • Financial results
    • Presentations
    • Investor information
  • Media
    • News
    • Media relations
    • Media kit
    • Newsletter sign up
  • Sustainability
    • Our approach
    • Our priorities
    • Business conduct
  • Careers
    • Search vacancies
    • Why Aegon
    • Career development
Site logo
  • Privacy statement
  • Cookie statement
  • Accessibility
  • Disclaimer
Aegon ©2023