Mental Health Resource Center, Inc. · 3 weeks ago
SQL Application Support Specialist - Healthcare EHR
Mental Health Resource Center is a not-for-profit organization providing a range of mental health services. They are seeking a SQL Application Support Specialist to support, analyze, configure, and test the EHR system’s functionality, ensuring compliance with billing and coding requirements.
Health CareMental HealthNon ProfitTherapeutics
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 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
Qualification
Required
High School diploma or equivalent required
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
Preferred
Associates or Bachelor's degree in Information Technology or Healthcare preferred
SQL certifications preferred
Benefits
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
Company
Mental Health Resource Center, Inc.
MHRC provides a wide range of behavioral health services for adults, adolescents, children, and families.
Funding
Current Stage
Growth StageCompany data provided by crunchbase