System Analyst II

SCP Health•Dallas, TX

1d•$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
athenaIDX ETM Agent automation
HCO, SIU, & API interface connections
DBMS and SQL queries
PCX uploads and reports
Colab and X12 remit files
Athena, Optum, KAV vendor case management

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.
Special Projects: 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.