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 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.
Responsibilities
Configuration, Maintenance, Reporting and Support:
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 organization’s 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 Bachelor’s 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 environment is preferred.
- 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.
Renaissance Behavioral Health Systems and Mental Health Resource Center are Equal Opportunity Employers.
Thank you for your interest in joining the team at Mental Health Resource Center and Renaissance Behavioral Health Systems. We offer a variety of opportunities in the behavioral health and social services fields. We have locations in Jacksonville and throughout Florida. Employees work together and support one another in a friendly, team-oriented atmosphere that encourages professional growth. We offer an ideal workplace for individuals dedicated to providing care and services that reflect our core values of compassion, integrity, and excellence.
Mental Health Resource Center, Inc. (MHRC) is a nonprofit organization that provides a wide range of behavioral health and social services to the community. Included in MHRC’s service array are 24-hour emergency services and inpatient psychiatric services for children, adolescents, and adults. Outpatient services include medication management, care coordination, case management, intensive case management team services, counseling, psychosocial rehabilitation, an adult therapeutic family program, state hospital liaison services, mental health court, multidisciplinary forensic teams (MFT), jail-based diversion services, a Co-Responder Program with the Jacksonville Sheriff’s Office, the Link-to-Life suicide prevention program, and services that assist individuals in obtaining benefits such as Social Security Income, Social Security Disability Income, Medicaid, food stamps, and housing. In addition, UF Health Jacksonville contracts with MHRC to manage the hospital’s adult inpatient psychiatric unit.
MHRC also operates eight Florida Assertive Community Treatment (FACT) programs for adults with severe and persistent mental illness, located in Clearwater, Gainesville, Jacksonville, Kissimmee, Rockledge, Tampa, and Winter Haven, as well as a FACT Lite program providing Linking, Advocating, Treating, Transitioning, Empowering & Recovery Support (LATTERS) services in Jacksonville. The two FACT teams located in Jacksonville serve residents of Duval, Clay, and Nassau counties.
Renaissance Behavioral Health Systems and Mental Health Resource Center encourage all applicants to take advantage of opportunities for hire, and if internal applicants, transfers, promotions, and advancement, regardless of their race, color, religion, sex, sexual orientation, gender identity or expression, age, handicap, disability, marital status, national origin, veteran status, or genetic information. RBHS and MHRC are Equal Opportunity Employers and Drug Free Workplaces.
(if you already have a resume on Indeed)
Or apply here.
Medical, Dental, & Vision Insurance
Paid Time-Off
Paid Holidays
Life & Disability Insurance
403(b)
Flexible Spending Account
Employee Assistance Program





