Clinic System Administrator

Primary Purpose

Under the direction of the Associate Dean, Information Technology, will serve as the first line of support for clinical applications, including axiUm and Epic. This role involves direct interaction with faculty, staff, and students; overseeing all clinic processes; managing user administration; and ensuring system integrity. The position requires strong technical skills in data management, reporting, programming, and application administration, as well as the ability to support system maintenance, security, and documentation.

Under the direction of the Associate Dean, Information Technology, will serve as the first line of support for clinical applications, including axiUm and Epic. This role involves direct interaction with faculty, staff, and students; overseeing all clinic processes; managing user administration; and ensuring system integrity. The position requires strong technical skills in data management, reporting, programming, and application administration, as well as the ability to support system maintenance, security, and documentation.
University of the Pacific recognizes that diversity, equity, and inclusion is foundational to the success of our valued students and employees. We prioritize policy and decision-making that demonstrates awareness of, and responsiveness to, the ways socio-cultural forces related to race, gender, ability, sexuality, socio-economic status, etc. impede or propel students, faculty, and staff.

• EHR system (axiUm and Epic) main support:
  First line support, including but not limited to, user interaction (faculty, staff, and students), all clinic processes (Statements, fee schedule, scheduler/Rotations, importing of new students into clinic system, etc.), and reporting.
• EHR main support system maintenance and security, including updates, troubleshooting, and resolving application issues promptly. Part of the Information Technology clinic coverage.
• Manipulate and analyze data for reporting and operational needs; consult with users to identify current operating procedures. Develop scripts/programs for our EHR to automate tasks and improve efficiency
• Analyze requests for programming changes for our EHR and other applications created by the school; develop some of the changes and interface with application system analysts, web developers, and outside system programmers; ensure appropriate changes are made.
• Prepare, organize, and maintain documentation and training working with the vendors and members of the IT team for all applications, database systems, software, hardware, and processes.
• Manage user accounts, permissions, and audits for our EHR. Support system maintenance, updates, and security compliance.
• Extract and transform data from axiUm (Oracle Server) for analytics; document source-to-target mappings, Design semantic layers (datasets, views) aligned to common KPIs. Prepare migration-ready models anticipating Epic Clarity/Caboodle structures.
• Build and maintain dashboards (e.g., access, quality, productivity, billing, no-shows, throughput, clinical outcomes, compliance) from axiUm; plan for Epic equivalents. Translate stakeholder questions into metric definitions, visuals, and self-service datasets and implement robust scheduling, versioning, and alerting for recurring reports.
• Assist in the transition from axiUm to Epic, including data migration and process alignment.
• Remain up to date on new technologies and tools applicable to this position.
• Perform all other duties as assigned by the Associate Dean, Information Technology.

• Microsoft Office Suite including Word, Excel, Access and Outlook.
• Advanced functions in Excel (i.e. Pivot Tables/charts, XLOOKUP, index/match)
• Technical and analytical reporting.
• Knowledge of at least one programming language (Python, R, etc.)

• Three (3) years' experience in application administration or a related role.
• Databases:
  Microsoft SQL Server (axiUm), Epic Clarity (Oracle/SQL Server), and Caboodle (SQL Server).

• Bachelor's degree in computer science or a related field.

• Position is full-time, 8 hours per day, 5 days per week.
• Occasional assignments on weekends and/or evenings.
• Travel may be required.

• Epic reporting experience (Clarity, Caboodle, Cogito, Reporting Workbench, Slicer Dicer);
  Cogito/Clarity certification a plus.
• axiUm reporting tools experience (e.g., SSRS, Crystal Reports), and knowledge of axiUm table structures.
• Data modeling (star schemas), semantic modeling in Power BI/Tableau; DAX or LOD expertise.
• Familiarity with HL7/FHIR concepts, Epic Bridges, interface message patterns, and downstream data quality implications.
• Python or R for analysis/automation; experience with dbt (nice to have).
• Source control (Git), CICD for BI content, and development of lifecycle in regulated environments.
• Cloud analytics familiarity (e.g., Azure SQL/Databricks, AWS RDS/Redshift);
  Power BI Service or Tableau Server…