SQL Application Support Specialist

Join to apply for the SQL Application Support Specialist role at Mental Health Resource Center, Inc.

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.

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

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

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.

• Assists in the configuration and maintenance of the Smart Care 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, 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 system 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.

• 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…