Sr Retirement Data Specialist, Pension Risk Transfer

Prudential Financial   •  

Moosic, PA

Industry: Accounting, Finance & Insurance


5 - 7 years

Posted 29 days ago

This job is no longer available.

Since 1928, Prudential has been an industry leader in the Pension Risk Transfer market and has partnered with pension plan sponsors and their advisors to provide secure retirement income. As the #1 largest manager of U.S. pension buy-outs based on assets, Prudential's Pension Risk Transfer team (PRT) is a proven leader in the ability to administer benefit payments to more than 1.4 million annuitants and supports more than 4,400 Defined Benefit plans.

This position is part of the Prudential Retirement Service Delivery team. Under direct supervision and following prescribed practices and procedures, this role will manage large amounts of annuitant data incorporating data research, merging functions, sorting, coding, and comparison within Microsoft Excel and related systems programs for the purpose of loading data to PRT recordkeeping systems.

Day to day functions include:

  • Create Paris accounting record
  • Create ALR / ABC accounting records via Master record program
  • Review plan specifications related to specific client to determine data load strategy
  • Interact with business partners (e.g., GP Valuation, Accounting) to validate load strategy and ability to support downstream needs
  • Ownership of the Data Matrix used to identify Certificate populations
  • Receiving files in Microsoft Excel or text format, reviewing for missing information
  • Applying data to external search engine to identify potentially incorrect data
  • Mapping data manually or via mapping software to Prudential data format
  • Re-formatting data fields as required by Prudential's data load programs
  • Applying internal coding to data file
  • Creating data sets within TSO mainframe system
  • Running various system programs to feed data sets into ALR / ABC recordkeeping system
  • Reviewing system output reports for errors
  • Reconciling system output reports to original data received
  • Manually update annuitant records as needed
  • Create data extract reports to for client review, response, and sign-off
  • Run recordkeeping checkwriting mini-series to produce payments for specific contract when loaded after main checkwriting cycle
  • Extracting data from the recordkeeping system to populate Annuity Exhibit templates with participant data
  • Identifying list of demographic changes for New Business Pricing as part of premium true-ups
  • Determining technology solutions required to support new sales. Drafting business requirements, serving as a business contact for questions, reviewing and approving functional requirements, conducting user acceptance testing and post installation check out of system installations.
  • Partnering closely with other PRT teams to implement successful solutions
  • Provide support as needed to other internal teams for plans recently on-boarded to understand processes, calculations and other specific needs for administering benefits under the contract.
  • Develops unique and innovative solutions for the most complex situations
  • Handles most complex clients/conversion problems
  • May communicate directly with clients
  • Oversight for Data Specialist procedures
  • Ensures that training plans are developed / completed as needed for Jr. associates; Train new associates
  • Mentors and guides junior associates
  • Supports the development of others by sharing subject matter expertise

BS degree or equivalent work experience

Minimum three years of Operations, Financial, or Accounting related work experience utilizing intermediate Excel functions

5 - 7 years of Retirement Industry experience a plus

Strong attention to detail

Overall strong PC skills

Ability to work independently and collaborate as part of a team

Self-motivated and proactive

Discretion to deal with confidential information

Strong time management and organizational skills

Strong communication skills and ability to foster relationships with multiple departments

Ability to work in a fast-paced, ever-changing, and challenging environment
Prudential is a multinational financial services leader with operations in the United States, Asia, Europe, and Latin America. Leveraging its heritage of life insurance and asset management expertise, Prudential is focused on helping individual and institutional customers grow and protect their wealth. The company's well-known Rock symbol is an icon of strength, stability, expertise and innovation that has stood the test of time. Prudential's businesses offer a variety of products and services, including life insurance, annuities, retirement-related services, mutual funds, asset management, and real estate services.

We recognize that our strength and success are directly linked to the quality and skills of our diverse associates. We are proud to be a place where talented people who want to make a difference can grow as professionals, leaders, and as individuals. Visit to learn more about our values, our history and our brand.

Prudential is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, genetics, disability, age, veteran status, or any other characteristic protected by law.

Note that this posting is intended for individual applicants. Search firms or agencies should email Staffing at for more information about doing business with Prudential.