System Analyst II

SCP Health•Dallas, TX

4d•$63,275 - $93,663

About The Position

At SCP Health, what you do matters. As part of the SCP Health team, you have an opportunity to make a difference. At our core, we work to bring hospitals and healers together in the pursuit of clinical effectiveness. With a portfolio of over 8 million patients, 7500 providers, 30 states, and 400 healthcare facilities, SCP Health is a leader in clinical practice management spanning the entire continuum of care, including emergency medicine, hospital medicine, wellness, telemedicine, intensive care, and ambulatory care.

Requirements

SQL
Cache Terminal Scripting
Visual Basic
WINSCP
SFTP Scripting
Reflection
Windows Task Scheduler
PowerShell
HL7 format interpretation
athenaIDX
ETM Agent automation
HCO, SIU, & API interface connections
DBMS and SQL queries
PCX uploads and reports
Athena, Optum, KAV vendor case management
Dictionary Maintenance and Uploads
Project management for medium scale support and implementation projects
User acceptance testing

Responsibilities

Scripting/Automation Development, testing and monitoring of integrated RPA Solutions; utilizing automation/scripting tools such as: SQL, Cache Terminal Scripting, Visual Basic, WINSCP, SFTP Scripting, Reflection, Windows Task Scheduler, and PowerShell.
Interpret HL7 format and create the appropriate mapping of the HL7 data feed into athenaIDX, to accurately interface patient demographic needed for billing.
Assist testing and monitoring automation solutions using athenaIDX ETM Agent automation.
Testing and monitoring interface (HCO, SIU, & API) connections.
Develop and Test Integrated Letter & Statements Development, testing and monitoring of integrated letters for billing ; utilizing automation/scripting tools such as: SQL, Cache Terminal Scripting, Visual Basic.
Develop and Test TES application in athenaIDX
Design, Build and Test TES Edits
Build TES Edit Groups and Workfiles, Assign TES Edits
Test Edits in Test Environment
Create TES Edits in Live Environment
Develop and Test BAR application in athenaIDX
Create, Test and implement Claim Edits and holds
Create, Test and implement Claim logic
Create, Test and implement Statement holds and logic
Creation and Development of 835 files/ exchanges
Troubleshoot and open cases with our software vendor, Athena, for missing remit files.
Maintain and work with both Colab and X12 remit files.
Assist in creation, testing and implementing exchanges.
Routine Maintenance of RCS Systems
Write and execute DBMS and SQL queries; produce reports from queries and analyze data.
Develop and maintain patient statements, dunning tables, and associated processes.
Develop PCX uploads and reports.
Log and monitor internal and external cases with vendors (Athena, Optum, KAV)
Various Dictionary Maintenance and Uploads
Manage projects for medium scale support and implementation projects in support AthenaIDX.
Ensure good communication between RCS systems and business users with regards to application support.
Assist with user acceptance testing during upgrades, patches, etc.
Any other duties deemed necessary by management.