Physician Compensation Data Analyst
Department Physician Support Services
Location La Crosse
Schedule/Shift 8 Hour Shift, Days
FTE 1 FTE
Benefit Eligible Yes
Temporary Position No
Job Details

This position is responsible for the design, analysis and reporting of clinic hospital, and health system financial data for the purpose of physician and associate staff salary administration. The position will compute provider production statistics and maintain databases.   The position will create methods for report generation, report scheduling, report distribution; data downloads and uploads, data manipulation, and data maintenance.  The position will understand and help execute the unique compensation plans for the physician staff.

Job Responsibilities
  • The position will interpret clinic and hospital financial data requests and design queries and reports to display the data to best support the salary administration process and to meet the end users' expectations.  A clear understanding of clinic and hospital functions, medical terminology, and a technical knowledge of the clinic and hospital financial systems and relational database products will be necessary to complete this function.

  • The position will download data from financial and clinical data systems into other software products. Once the data is in these products, the position will manipulate the information to prepare final reports and perform analyses.

  • The position will track clinic and hospital financial data requests, create methods to generate reports on a scheduled basis, ensure that report distribution is completed on a scheduled basis.  The position will work with the information systems department to create portals for reporting.

  • The position will design and maintain databases which receive data from other systems.  The position will create and maintain historical data bases containing billing, RVU, patient visit, and salary data.  An understanding of how relational databases work will be mandatory.

  • The position will develop an understanding of the physician compensation process and the various external regulations that govern it.  The position will support the department’s work with executive committee in all matters relating to salary administration

  • The position will respond to questions from department chairs and the medical and associate staff related to production and salary information.  It will investigate data irregularities and determines causes.  The position will also respond to questions from lay and medical management.

  • This position will identify billing errors.  It will work closely with Revenue Cycle Department to resolve billing and RVU discrepancies.

  • This position will present data reflecting analyses performed. It will ensure customers are satisfied with data and that data meets users' needs.

  • The position will validate data and confirm the accuracy of all reports produced. The creation of highly accurate reports is a fundamental requirement of the job.

  • The position requires viewing of clinical systems (e.g. Epic, lab, radiology, TEC) in order to validate information for reporting and establish financial systems. This can involve seeing patient specific information.

  • This position will perform other projects and duties as required.

  • Scope of the Job
    Age Specific Population Served Nonage Specific (N/A)
    OSHA Category Category III - No employees in this job title have a reasonably anticipated risk of occupational exposure to blood and/or other potentially infectious materials.
    Position Qualifications
    Education and Experience:
    Required Bachelor's degree in  Management of Information Systems (MIS) or Health Information Management or Computer Science or Business Administration 
    Desired  

    Work Experience:
    Required 3-4 years data management experience in health care information systems.
    Desired 5-7 years data management experience in health care information systems.
    Skills:
    Required Ability to...
    Computer Systems/Software/Applications database reporting tools such as Business Objects/Crystal Reports, Oracle Reports, Oracle SQL, and Microsoft Access
    Computer Systems/Software/Applications maintain proficiency in Microsoft Office Products (i.e. Word, Excel, PowerPoint, Illustrator, etc.)
    Communication communicate with ease on a professional level
    Communication express or exchange ideas by means of the spoken word, communicating orally with others
    Comprehension understand, remember, and apply oral and/or written instructions or other information
    Mathematics compute, analyze, and interpret numerical data for reporting purposes
    Organization organize and prioritize own work schedule on short-term basis (longer than one month)
    Reasoning/Decision Making make decisions which have moderate impact on immediate work unit
    Desired Ability to...
    License and Certifications
    Required
    Desired
    Physical Requirements/Demands of the Position
    Sitting Continually (67-100% or 8 hours)
    Static Standing
    Walking/Standing
    Driving
    Stooping/Bending
    Squatting
    Kneeling/Half Kneel
    Climbing Stair
    Climbing Ladder
    Reaching - Shoulder Level
    Reaching - Below Shoulder
    Reaching - Above Shoulder
    Repetitive Actions - Pinch Forces Pounds of force:
    Repetitive Actions - Grip Forces Pounds of force:
    Repetitive Actions - Fine Manipulation Frequently (34-66% or 5.5 hours)
    Balance - Right Leg
    Balance - Left Leg
    Lifting - Floor to Waist Number of lbs:
    Lifting - Waist to Overhead Number of lbs:
    Lifting - Other Number of lbs:
    Carrying - Long Carry (>50 feet) Number of lbs:
    Carrying - Short Carry Number of lbs:
    Carrying - Right Carry Number of lbs:
    Carrying - Left Carry Number of lbs:
    Carrying - Push/Pull (Static Force) Number of lbs:
    Other:
    Number of lbs:
    Environmental Conditions
    Not substantially exposed to adverse environmental conditions (as in typical office or administrative work).

    Physician Compensation Data Analyst

    Equal Opportunity Employer