Data Analyst

Location: Willow Grove, PA - Pennsylvania
Date Posted: 11-28-2017
Job Purpose:     
The primary purpose of this position is to receive, clean, process, verify and report on data applicable to the clearance of government (Medicare and Medicaid) and private health insurance liens in mass tort cases.  Strong Access experience is required.  

The position requires both anticipating and reacting to the needs of staff and clients throughout the life cycle of different mass tort projects to ensure maintenance of accurate data related to clearing of health plan liens.
  • Receive data in various formats from law firms, claims administrators, other vendors and government agencies
  • Process data into standard formats using MS Excel, Access and CRM software ACT! and Salesforce, and other data manipulation tools to prepare and analyze data. 
  • Strong Access experience is required.  
  • SQL server experience a plus
  • Use existing and also 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 attorney clients, internal paralegals, lien resolution specialists and project managers, 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
  • Work with existing IT resource to determine strengths and divide workflow in order to maximize capabilities.
Primary Qualifications:
  • Expertise in working with large sets of data in systems and spreadsheets
  • Strong MS Excel, Access, SQL skills
  • Moderate to advanced VBA for Excel
  • Ability to work with data import toolsets (training available on specifics)
  • Experience with Customer Relationship Management software, including Salesforce 
  • Ability to manage and motivate others.
Personal Attributes
  • Strong detail-orientation
  • “Accounting” mentality.  “Everything must tie out or it isn’t right”
  • Self-motivated and directed
  • Ability to act decisively and implement solutions
  • Ability to anticipate, take initiative and “take charge”
  • Excellent analytical, evaluative and problem-solving abilities
  • Ability to expand job responsibilities, suggest improvements, and collaborate with others to generate ideas and implement process improvements.
this job portal is powered by CATS