It is the desire of the Lab Operations/Charge Integrity/Lab Finance teams to hire a Sr. Financial Analyst (SFA) professional to build a database for use in analytics of the VUH Reference Lab testing. The database will serve to document critical data elements such as the vendor name, description of test, CPT codes and units billed and cost information. The SFA will reside in the Office of Finance - Clinical Operations and work collaboratively with Charge Integrity, Lab Operations and the Office of Finance Clinical Operations.
This is a full-time/exempt term position lasting six months to one year.
Currently reference labs are sent out by VUMC labs and invoiced directly for billing in Cerner. There is currently not a process in place to track the costs associated with these tests. Although the VUMC lab has contracts in place with ARUP and Mayo, there are numerous boutique labs utilized where contracts are not in place. The database build will allow for tracking of costs to net reimbursement to allow for strengthened oversight of pricing and minimize margin losses on high volume tests. This costing data will also be utilized to update EAP build in eStar for transition to Beaker to allow for parent/child explosion of CPT codes. Once costing data and EAP builds are completed, a standardized SOP will be developed that will allow for all costing data to be maintained and updated in EPSi, the Decision Support system, to assist in margin analysis, expense analysis and targeted programs.
Scope of Work
The SFA would build a database consisting of data extracted from the invoices from the outside vendors and the testing they currently perform for us. Data points within the database would include:
Vendor name and info
Test Panel they perform for VUMC patients
CPT codes including those in each of the Test Panels (Parent/Child explosions)
Pricing either by test/panel or by cpt code
Testing would be matched up with the reimbursement we receive for the testing
Quantity billed of each test or cpt code
When available the Sample Date and Report Date (Result Date)
Once the database is built it will allow us to have visibility into the profitability of the testing by test and vendor. It would provide information upon which to base contract negotiations. It will provide the Revenue Cycle team with cost data upon which to base pricing and the Lab information needed for contract negotiations.
Skill set needed
The ability to create a complex database
The ability to interpret data with attention to detail
Comfortable with invoicing and the ability to interpret invoices
(Perhaps someone who has processed payments and invoices but not necessary)
A Term position is a staff position that exists for a period longer than six months but is not expected to last beyond one year. Although a position may exist for a specified or indefinite period, staff who accept term positions are not guaranteed employment for the entire period; they are employed for indefinite periods within the limit of the appointment. There are no guarantees of continued employment, either within the term or when the term ends.
Vanderbilt University Medical Center is home to Vanderbilt University Hospital, The Monroe Carell Jr. Children’s Hospital at Vanderbilt, the Vanderbilt Psychiatric Hospital and the Vanderbilt Stallworth Rehabilitation Hospital. These hospitals experienced more than 61,000 inpatient admissions during fiscal year 2015. Vanderbilt’s adult and pediatric clinics treated nearly 2 million patients during this same period. Vanderbilt University Hospital and the Monroe Carell Jr. Children’s Hospital at Vanderbilt are recognized again this year by U.S. News & World Report’s Best Hospitals as among the nation’s best with 18 nationally ranked specialties. Vanderbilt University Medical Center is world renowned because of the innovation, work ethic and collegiality of its employees. From our health care advances to our compassionate care, Vanderbilt owes its accomplishments and reputation to staff and faculty who bring skill and drive and innovation to the medical center day after day. World-leading academic departments and comprehensive centers of excellence pursue scientific discoveries and transformational educational and clinical advances across the entire spectrum of health and disease.As t...he largest employer in middle Tennessee, we welcome those who are interested in ongoing development in a caring, culturally sensitive and professional atmosphere. Most of us spend so much of our lives at work, we want to be part of maintaining a workplace in which people support one another and encourage reaching for excellence. Many high-achieving employees stay at Vanderbilt because of the professional growth they experience and because of their appreciation of Vanderbilt’s benefits, public events and discussions, athletic opportunities, beautiful setting and, above all, sense of community and purpose.Vanderbilt and its employees share a set of mutual expectations that have been created with productivity, legality, fairness and safety always in mind. We believe that our investment in training and compensating employees multiplies in value when we enable individuals to deliver their best performance for the benefit of us all.