Review Services Coordinator
Apply Now - Review Services Coordinator
Overview
The Review Services Coordinator position at HIA will focus on managing tasks for acute review services with a primary emphasis in data management and transformation. The Review Services Coordinator will assist with planning, preparing, and overseeing acute review projects in an efficient and timely manner.
* This can be a remote/work from home position but may require occasional travel to corporate office in Pawleys Island, S.C.*
Required Skills and Experience
- Substantial experience with ETL data transformation (extract, transform and load data, while ensuring its integrity)
- Experience with use of transformation tools such as OpenRefine, ASAP Utilities or Microsoft SQL
- Advanced Microsoft Excel skills (using functions and formulas, pivot tables, analyzing data, etc.)
- Proficiency with additional Microsoft applications, especially Teams and OneNote
- I-10-CM/PCS/CPT knowledge base preferred
- Demonstrates strong and effective communication skills, both orally and in writing
- Must be detail-oriented, organized, able to prioritize tasks and consistently meet deadlines
- Independent, focused individual with established work ethic
- High Speed Internet accessibility via Cable (no Satellite or wireless cell based)
- High level of interpersonal skills to handle sensitive and confidential situations and documentation
Job Requirements
Review Projects
• assists with review prep calls, taking notes of client objectives for each audit
• creates project in audit database (Particle) and associated folders on secure portal (Nucleus)
• schedules review kickoff call with client and project lead
• manages contact list in Particle and assigns roles for access to secure portal
• creates/manages Microsoft Team and OneNote Notebooks for each client and updates with new policies
Pull Lists – Acute Reviews
• checks files for accuracy of content, codes, missing information upon receipt, runs pivot tables
• formats data as necessary to obtain sample (uses data transformation utilities available)
• selects sample based on client parameters (focused, random, by coder, DRG, etc.)
• loads data into template and imports into audit database
Large Client Projects / Interim Projects
• tracks progress in spreadsheets for HIA and client weekly status updates
• prepares and imports pull lists for monthly interim projects
• assists with importing rebuttals, notifications to team lead
• may assist with running customized reports
Additional Tasks
• Runs Outstanding Tracking Report and sends to consultants for project completion or close out
• Assists with chart replacements during current projects (wrong patient type, combined accounts)
• Creates monthly interim projects in audit database
• Prepares and distributes client reports – as requested by manager
• Assists with scheduling internal HIA coder QA reviews, importing chart samples
• Downloading files from secure portal to Sharepoint as needed (scanned record projects)
• Monitors remote access by consultant and facility, works with IT for follow up on outstanding access
