SQL Application Support Specialist

Mental Health Resource Center•Jacksonville, FL

About The Position

Renaissance Behavioral Health Systems , a comprehensive mental health center and Joint Commission accredited organization, is seeking a SQL Application Support Specialist to work at our corporate headquarters in Jacksonville, Florida. The SQL Application Support Specialist will help to support, analyze, configure, test, and update the EHR system’s functionality including the system’s clinical, billing, accounts receivable, scheduling, and state reporting infrastructure with the overall goal of maximizing revenue capture. Responsibilities will include the configuration of system rules and tables; maintenance of interfaces for billing, payments, clearing houses, and state managing entities; creation or maintenance of accurate and effective SQL reports and scripts; and other system logic necessary to support compliance with payor contracts, billing and coding requirements, audit rules, and internal policies. Additionally, the SQL Application Support Specialist will provide support for the organization’s fax, telephony, email, financial, payroll, and HR applications.

Requirements

In order to be considered, candidates must have a High School diploma or equivalent required.
Minimum one year of experience writing reports in SQL and supporting system applications.
Proficiency in Microsoft Office programs and use of the Internet.
Proficiency in electronic records and billing software demonstrated within three months of employment.
This position is a Full Time position.

Nice To Haves

Associates or Bachelor’s degree in Information Technology or Healthcare preferred.
SQL certifications preferred.
Experience in a healthcare environment is preferred.

Responsibilities

Assists in the configuration and maintenance of the SmartCare system modules including SQL tables.
Interact with pertinent personnel to identify data needs, create, test and maintain accurate and effective SQL reports and scripts in support of billing and state reporting functions
Assists in the development and maintenance of the Dynamic Form Architecture (DFA) and interoperability for the EHR system for existing and future functionality adoption.
Testing of new or revised EHR functionality including the development and update of test plans, testing, troubleshooting and final acceptance.
Maintains the updates of all internal and external documentation related to reporting, claims configuration and policy changes
Fully supports internal audits and responds timely to any resulting action plans.
Accountable for outstanding customer service to all external and internal customers.
Assists in the accurate and timely loading of the following (including annual updates): Payor contracts, Providers, Fee schedules, Code Set Mapping, and Specialized Rules and Alerts.
Serves our staff as a support team resource for our information systems.
Supporting functions of the software, including but not limited to; AR Month End close processing, Quality Control and Audits, generation and distribution of SQL reports and review of Census.
Ensures the timeliness of adding new users, staff transfers and termination requests of users from our systems and systems access.
Maintains email group management and support for our internal and external email systems.
Reviews and updates calendar reminders for contract renewals, knowledgebase administration and process/procedural reviews
Performs periodic site visits, virtual or physical, to conduct user group discussions, workflow design reviews and/or provide updates on system changes.
Specialist will provide support for the organization’s financial, payroll and HR applications including quarterly updates and assisting the software vendors with troubleshooting.
Assists in Role Specific Billing Training as needed (System and Procedural Updates)
Maintains Billing Training support documentation and materials
Resolves user problems as reported via the IT Hotline.
As scheduled by IT management, receives and resolves IT Hotline calls on nights, weekends and holidays.
Resolves, if possible, otherwise consults with or refers problems to other IT technical staff.
Utilizes remote PC administration tools to resolve user problems.
When required, travels to facilities to resolve system or application related issues.