SQL Application Support Specialist - Healthcare EHR

Benefits:

• Dental insurance
• Health insurance
• Paid time off
• Vision insurance

Benefits/Perks

• Medical, Dental, and Vision Insurance
• Life Insurance
• Disability Insurance
• 403b
• PTO
• Paid Holidays
• Flexible Spending Account
• Employee Assistance Program

Company Overview
Mental Health Resource Center is a not-for-profit Florida corporation that provides a wide range of mental health and behavioral health care services to the community such as 24-hour emergency services, inpatient psychiatric services for children, adolescents, and adults as well as outpatient services such as medication management, case management, and counseling.

Job Summary
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 systems functionality including the systems 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 organizations fax, telephony, email, financial, payroll, and HR applications.

Responsibilities
Configuration, Maintenance, Reporting and Support:

• 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 organizations financial, payroll and HR applications including quarterly updates and assisting the software vendors with troubleshooting.

Training:

• Assists in Role Specific Billing Training as needed (System and Procedural Updates)
• Maintains Billing Training support documentation and materials

On-Call - IT Hotline:

• During normal business hours: 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.

Qualifications

• In order to be considered, candidates must have a High School diploma or equivalent required. Associates or Bachelors degree in Information Technology or Healthcare preferred.
• SQL certifications preferred.
• Minimum one year of experience writing reports in SQL and supporting system applications.
• Experience in a healthcare EHR environment is required.
• Proficiency in Microsoft Office programs and use of the Internet.
• Proficiency in electronic records and billing software demonstrated within three months of employment.

Position Details
This position is a Full Time position.

Renaissance Behavioral Health Systems and Mental Health Resource Center are Equal Opportunity Employers.
Background screening and clearance through the Florida Care Provider Background Screening Clearinghouse is required for all positions: https://info.flclearinghouse.com