Sign In
 [New User? Sign Up]
Mobile Version

Data Specialist


Scranton, PA
Job Code:
Apply on the Company Site
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

Position Title: Data Specialist
Job Code: 413138
Job Location: Pennsylvania-Scranton

The Data Specialist is part of the Prudential Retirement Service Delivery team. Under direct supervision and following prescribed practices and procedures, this role includes:

Managing 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 Pension Risk Transfer (PRT) recordkeeping systems. Day to day functions include:

  • Create Paris accounting record
  • Create Active Life Recordkeeping (ALR) system  / mainframe 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
  • 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 the mainframe system
  • Running various system programs to feed data sets into ALR / mainframe recordkeeping system (ABC) 
  • 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 check writing mini-series to produce payments for specific contract when loaded after main check writing cycle
  • Calculate and apply benefit increase data to ALR / ABC via COLA program
  • 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
  • May support training and procedure development

  • BS degree or equivalent work experience
  • Minimum one year of Operations, Financial, or Accounting related work experience utilizing intermediate Excel functions
  • 2 -3 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.
Job Function: Other
Schedule: Full-time
Apply on the Company Site

Featured Jobs[ View All ]

Featured Employers [ View All ]