Want to know if this job is worth applying to?
San Jose, California, United States
Onsite
This position is responsible for the configuration, integrity, and daily operation of Hope Services' Netsmart Avatar EHR and its supporting databases and reports. The job involves project management, end user training, form modeling, ticket management, SQL and report development, billing error correction, and staff support.
Essential Functions
The following responsibilities represent the essential functions of the position: An employee in this classification is responsible for carrying out the following functions:
1. EHR system administration. Updates, upgrades, and release testing; user provisioning and role-based access; defect tracking and escalation to vendor support.
2. EHR form modeling. Build and modify all Avatar forms — field logic, validation, workflow routing — from clinical and program requirements, with testing before release.
3. SQL and database engineering. T-SQL development, stored procedures, query tuning, ETL and data warehouse services on SQL Server; query and maintain InterSystems IRIS.
4. Billing error correction. Daily monitoring and correction of Avatar billing errors; fix root causes in configuration rather than repeat manual corrections.
5. Month-end billing. Own accuracy, reconciliation, and on-time submission of month-end billing and payer claim files; track denials with Finance.
6. Reporting. Create and modify all Crystal Reports used with Avatar; maintain and migrate legacy Access reports; build management dashboards and advanced Excel analysis.
7. Data quality and controls. Design checks, reconciliations, and exception reporting that assure quality of data and services to internal and external customers.
8. Audit and regulatory reporting. Prepare data, extracts, and system walkthroughs for annual, payer, and accreditation audits; produce required state and funder reporting.
9. Staff support and training. Escalation point for EHR and software issues; deliver training, quick guides, and a super-user program after each release.
10. Connectivity. Manage database connectivity across the counseling center network — ODBC, client installs, remote access — and maintain test environments.
11. Documentation and change control. Maintain data dictionary, report specs, and SOPs; follow request-test-approve-release with a rollback plan for every production change.
12. Communication and customer service. Communicate clearly with clinical, finance, and executive audiences; observe, evaluate, and document accurately.
13. Independence and teamwork. Work independently and on a team; relate appropriately to persons served and their families; represent the department in community settings on request.
14. Program knowledge. Working knowledge of rehabilitation service models, program development, and governing legislation and regulations.
15. Management fundamentals. Familiarity with supervision, planning, fiscal management, fair employment practices, safety, health, and client rights; able to cover for the EHR Manager.
16. Other duties as assigned.
Qualifications Required
Bachelor's degree in Information Systems, Health Informatics, or related field plus four years of supervisory experience working with people with disabilities in a rehabilitation environment, or an approved equivalent combination of experience and education.
Required Knowledge and Skills
Preferred Skills
Environmental Conditions
An enclosed office environment. Time spent sitting, using a computer station, concentrating intensely for long periods, using the telephone, and completing paperwork. Time spent in meetings, in travel to various work site locations in three counties. Some exposure to outdoor weather conditions.
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
