Assistant Manager, Electronic Health Record

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

1. 3+ years supporting a production EHR or comparable transactional database in healthcare or human services.
2. SQL proficiency including stored procedures, ETL, and job monitoring; Crystal Reports proficiency; advanced Excel and proficient Word.
3. Privacy and compliance — Working knowledge of HIPAA, 42 CFR Part 2 substance-use record protections, CMIA, minimum-necessary access, and breach notification.
4. Information security — Role-based access review, MFA and credential hygiene, encryption in transit and at rest, secure file transfer for payer exchange, audit-log review.
5. Revenue cycle — Claim lifecycle literacy: ICD-10 and CPT/HCPCS, service code and authorization setup, denial-reason interpretation.
6. Data governance — Ownership of a data dictionary and metric definitions, duplicate-record management, and reproducible extract logic.
7. Requirements and project management — Requirements gathering from non-technical stakeholders, scoping and sequencing upgrade work, and clear status reporting.
8. Scripting and version control — Source control for SQL and report definitions, plus PowerShell or Python automation.
9. Backup and disaster recovery — Documented and tested recovery procedures with defined RPO/RTO and a clinical downtime process.
10. Problem-solving under deadline — Methodical troubleshooting and composure during month-end close, go-lives, and outages; occasional after-hours availability for upgrades.
11. Audits- Preparation and assistance during annual Hope Services audits

Preferred Skills

• Netsmart Avatar / myAvatar experience, including form modeling; InterSystems IRIS or Caché.
• Web-based reporting; SSRS or Power BI.
• Scriptlink
• HL7 v2 or FHIR interface troubleshooting; 837/835 EDI and Medi-Cal or Regional Center billing.
• Behavioral health, developmental disability, or nonprofit human services background.
• Vendor and SLA management; outcome and quality measure reporting.

 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.