Patient Programs Database Specialist - The Grove ( Irvine , CA )

Job Description:

This position reports to the Supervisor of the Patient Assistance Department. The position will develop, run and update MS Access database objects. Additional duties will include processing and updating Excel reports to Patient Assistance team and field teammates. ESSENTIAL DUTIES AND RESPONSIBILITIES• Processes returned checks from multiple sources.• Processes AKF HIPP Report, and posts premium payments.• Run queries to accumulate data for weekly and monthly departmental reports.• Maintains and updates weekly team newsletter.• Updating excel spreadsheets for the AKF, TKT and Drug Replacement Programs.• Developing, and upgrading the Patient Assistance Department databases.• Documenting tables, queries, forms, etc., on the Patient Assistance Department databases.• Maintenance of databases by performing backups, restores, and weekly preventive maintenance.• Updates SSN and clinic information in databases.• Back up for system support when supervisor is not available.• Cross train on all other positions within the department to provide support when needed.• Assist team to identify and resolve problem accounts• Pull data for CQI projects as it relates to the Patient Assistance Department• Presentations utilizing power point• Special projects as needed.• Other duties as assigned by Manager.