Lien Resolution Specialst

Location: Willow Grove, PA
Date Posted: 10-23-2017
The primary purpose of this position is to receive, process, verify and report on data applicable to the clearance of government (Medicare and Medicaid) and private health insurance liens in mass tort cases. 

This position will report to the Senior Management team as well as external Attorneys, Paralegals and Qualified Settlement Fund accounting staff. 

Summary of Position
Candidate will be responsible for receiving law suit settlement and claimant data from claims administrators and processing that data into a form that is ready for import and manipulation into various information systems and tracking spreadsheets.  Additionally, will update internal information systems and spreadsheets as new and changed information is received from various parties related to the settlement. 

  • Receive data in various formats from law firms, claims administrators, other vendors and government agencies
  • Process data into standard formats using MS Excel and CRM software and other data manipulation tools to prepare and analyze data.
  • Use existing or create new macros to manipulate and verify lien resolution data, identify inconsistencies and discrepancies in sheets and tabs to fit specific formats
  • Import data into proprietary information systems using MS Excel and other data transformation tools.
  • Enter and update data into information systems
  • Interact with attorneys, paralegals, claims administrators, and other parties to receive updates and verify data
  • Process data contained in spreadsheets or applications into specific formats necessary for payments to various parties
  • Develop and implement a set of quality control procedures to ensure the accuracy of data transmissions
Primary Qualifications:
  • Comfortable working with large sets of data in spreadsheets and other systems (large sets of data such as 4,000 rows/columns)
  • Strong MS Excel skills, SQL, including macro use and development
  • Moderate to advanced VBA for Excel
  • Ability to work with data import toolsets (training available on specifics)
  • Experience with Customer Relationship Management software.  Salesforce and/or ACT or Goldmine a plus. 
  • Previous staff management experience required.
Personal Attributes
  • Strong detail-orientation
  • “Accounting” mentality.  “Everything must tie out or it isn’t right”
  • Self-motivated and directed
  • Excellent analytical evaluative and problem-solving abilities
this job portal is powered by CATS