Data Analyst

340B Data Analyst

Under the direct supervision of the 340B Director, the 340B Data Analyst shall perform analysis of 340B program to develop reports to guide decision making and track overall financial impact of 340B to the organization. In addition, the 340B data analyst shall perform chart reviews to locate chart notes, consultations, medications and referral orders to support 340B claims. Review invoices, pricing, prepare and maintain accounting documents and records. The data analyst will work with team members, clinic staff, outside medical staff, physicians, wholesalers, and other players in 340B to ensure all requirements are met.

It is the primary purpose of CHCCC to provide the highest quality of total care possible to the patient population it serves. Such a level of quality depends ultimately on the staff's desire and ability to work together, individually, and as a team. The employee is expected to be professional, punctual, maintain regular attendance, cooperative, organized, and enthusiastic at all times.

Essential duties and responsibilities include the following. Additional duties may be assigned with or without prior notice.

Uses 340B reports to identify patient charts that require review for chart notes, consultations, and medication documentation and referral orders.

Performs chart review, identifies presence or absence of required elements.

Works with Specialty offices or Referral Department to retrieve the missing consultation documentation.

Contacts pharmacies to obtain a copy of the prescription when the consultation documentation does not include medication referenced in 340B claims report.

Interact with multiple 340B program affiliates, including wholesalers, vendors, insurance providers, internal and contracted pharmacies, internal departments, medical providers, and regulators.

Works with office staff, medication case managers, and physicians to ensure medication reconciliation is completed to reflect medications from 340B claims report.

Works with office staff and physicians to ensure referral order is in chart for patients seen by and receiving prescription drugs from consulting specialist.

Faxes consultations and prescription slips to Athena for scanning into patient's EMR.

Work with the 340B team to verify 340B claims reports.

Review invoice pricing and 340B financial reports, prepare and maintain accounting documents and records.

Demonstrates professionalism and provides quality customer service using AIDET Standards.

Ability to work with high volume of claims data/records.

Effective organizational and time management skills with the proven ability to work independently and meet deadlines with precision, intention, and efficiency.

Identifies and addresses problems, questions, concerns, analysis, etc. in a timely manner so that proper actions can be implemented to prevent losses, maximize reimbursement, and meet deadlines, to facilitate the growth and stability of the organization.

Helps to develop reports, charts, and tables to guide 340B decision making

Assists in 340B oversight committee reports and other committee reports

Assists in 340B fiscal year end reports and reconciliation for finance

Cross analyzes financials reports and invoices in order to verify accuracy

Identifies trends in 340B space and propose solutions to those trends

Demonstrates adherence to and observes all safety policies and procedures.

Demonstrates cultural sensitivity and competence with patients.

Maintains and adheres to HIPAA, employee confidentiality, and privileged communications (patient, employee, and corporation).

Must be able to meet deadlines.

Must be detail oriented.

Perform other duties as assigned.

This job has no supervisory responsibilities.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or experience- accounting, finance, or data analysis background preferred

Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals. Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees of organization. Candidate should have effective professional communication and writing skills

Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.

Experience with word processing, spreadsheets, email, and keyboarding required. Microsoft Office, particularly Microsoft Excel, and Google Suite skills required.

Excellent command of Microsoft Excel

Possession of current, valid, California Driver's License (Class C).

Required to pass a criminal history background check and drug screen upon hire. Annual health examination; annual Tuberculosis skin test clearance or chest x-ray; proof of immunity to MMR, Varicella, and Hepatitis B; proof of Tdap vaccine; during current flu season, must provide proof of influenza vaccine or a signed declination form. If declined, a flu mask is mandatory during flu season. Health screening requirements are subject to change based on CDC recommendations and federal, state, and/or local public health ordinances.

While performing the duties of this job, the employee is regularly required to use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee frequently is required to sit. The employee is occasionally required to stand and walk. The employee must regularly lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

While performing the duties of this job, the employee is frequently exposed to moving mechanical parts. The employee is occasionally exposed to risk of electrical shock. The noise level in the work environment (office setting) is usually moderate.

Must be willing to have a flexible work schedule that may include evenings/weekends, and travel as needed.