Data Analyst

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. This position reports to two General Counsel/Principals and will work with another IT professional with current systems responsibilities. The position supports other Paralegals (Lien Resolution Specialists and Client Service / Project Managers and also liaises with our Qualified Settlement Fund accounting staff located in our Denver, CO office. 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.

Job Summary:

The position is responsible for receiving law suit settlement and claimant data from law firms and claims administrators and processing that data into a form that is ready for import and manipulation into various information systems, namely Access and Salesforce. Additionally, this position will update internal information systems and spreadsheets as new and changed information is received from various parties related to multiple settlements.

Duties:

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 now Salesforce, and other data manipulation tools to prepare and analyze data.

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