EHR Systems Supervisor - SQL, Reporting & Training

Hope Services; San Jose (CA); On-site; USD 76,000 - 93,000; Full time

Job summary

Hope Services in Silicon Valley seeks an EHR Administrator to manage the Netsmart Avatar system and related databases. You will oversee daily operations, form modeling, billing corrections, and end-user training while supporting staff across clinical, finance, and governance functions.

You will lead data quality checks, regulatory reporting, and dashboard development, ensuring secure access, testing, and rollout of upgrades in a healthcare/nonprofit setting.

Qualifications

• 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.
• 3+ years supporting a production EHR or comparable transactional database in healthcare or human services.
• SQL proficiency including stored procedures, ETL, and job monitoring; Crystal Reports proficiency; advanced Excel and proficient Word.
• Privacy and compliance — HIPAA, 42 CFR Part 2 protections, CMIA, minimum-necessary access, breach notification.
• Information security — Role-based access review, MFA, encryption, secure file transfer, audit logs.
• Revenue cycle — Claim lifecycle, ICD-10/CPT-HCPCS, service codes, denials.
• Data governance — Data dictionary ownership, duplicate-record management, reproducible extracts.
• Requirements and project management — Gather requirements, scope upgrades, report status.
• Scripting and version control — SQL/report source control; PowerShell or Python automation.
• Backup and disaster recovery — Documented DR with RPO/RTO and downtime procedures.
• Problem-solving under deadline — Troubleshooting for month-end closes and outages.
• Audits - Preparation and assistance during Hope Services audits

Responsibilities

• EHR system administration: updates, testing, provisioning, access management, and vendor escalation.
• EHR form modeling: build/modify Avatar forms with validation and routing.
• SQL and database engineering: T-SQL development, ETL, and data warehouse services.
• Billing error correction: monitor and fix Avatar billing errors; address root causes.
• Month-end billing: reconciliation and timely submission; track denials with Finance.
• Reporting: create/modify Avatar Crystal Reports; migrate legacy Access reports; dashboards.
• Data quality and controls: checks, reconciliations, and exception reporting.
• Audit and regulatory reporting: data extracts for audits and state/funder reporting.
• Staff support and training: end-user training and quick guides; super-user program.
• Connectivity: manage database connectivity across network and remote access.
• Documentation and change control: data dictionary, specs, SOPs; rollback plans.
• Communication: liaise with clinical, finance, and exec audiences; accurate documentation.
• Independence and teamwork: work solo or with team; interact with served individuals and families.
• Program knowledge: rehab service models and governing regulations.
• Management fundamentals: supervision, planning, fiscal management, safety, rights; cover for EHR Manager.
• Other duties as assigned.

Skills

SQL proficiency

Crystal Reports

Advanced Excel

HIPAA knowledge

Information security

Revenue cycle

Data governance

Requirements & project mgmt

Scripting & automation

Backup & disaster recovery

Problem solving

Audits prep

Education

Bachelor's degree in Information Systems, Health Informatics, or related field

Tools

Netsmart Avatar / myAvatar

InterSystems IRIS / Caché

SSRS / Power BI

HL7 v2 / FHIR interfaces

EDI (837/835)

Scriptlink

Job description

Hope Services in Silicon Valley seeks an EHR Administrator to manage the Netsmart Avatar system and related databases. You will oversee daily operations, form modeling, billing corrections, and end-user training while supporting staff across clinical, finance, and governance functions.

You will lead data quality checks, regulatory reporting, and dashboard development, ensuring secure access, testing, and rollout of upgrades in a healthcare/nonprofit setting.