Clinic System Administrator

Under the direction of the Associate Dean, Information Technology, this role serves as the first line of support for clinical applications, including axiUm and Epic. Responsibilities include direct interaction with faculty, staff, and students; overseeing clinic processes; managing user administration; and ensuring system integrity. Strong technical skills in data management, reporting, programming, and application administration are required, along with the ability to support system maintenance, security, and documentation.

Responsibilities

• Serve as the first line of support for EHR systems (axiUm and Epic), including user interaction (faculty, staff, and students), clinic processes (statements, fee schedules, scheduler/rotations, importing new students), and reporting.
• Maintain and secure EHR systems, including updates, troubleshooting, and resolving application issues promptly.
• Manipulate and analyze data for reporting and operational needs; consult with users to identify current operating procedures.
• Develop scripts/programs to automate tasks and improve efficiency within the EHR.
• Analyze requests for programming changes to the EHR and other applications; develop changes and interface with system analysts, web developers, and outside programmers.
• Prepare, organize, and maintain documentation and training for applications, database systems, software, hardware, and processes in collaboration with vendors and the IT team.
• Manage user accounts, permissions, and audits for the EHR; support system maintenance, updates, and security compliance.
• Extract and transform data from axiUm (Oracle Server) for analytics; document source-to-target mappings and design semantic layers aligned to common KPIs.
• 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; implement robust scheduling, versioning, and alerting for recurring reports.
• Assist in the transition from axiUm to Epic, including data migration and process alignment.
• Stay updated on new technologies and tools applicable to the role.
• Perform additional duties as assigned by the Associate Dean, Information Technology.

Requirements

• Bachelor’s degree in computer science or a related field.
• Three (3) years of experience in application administration or a related role.
• Knowledge of Microsoft Office Suite (Word, Excel, Access, Outlook) and advanced Excel functions (PivotTables, XLOOKUP, index/match).
• Technical and analytical reporting skills.
• Proficiency in at least one programming language (Python, R, etc.).
• Experience with databases: Microsoft SQL Server (axiUm), Epic Clarity (Oracle/SQL Server), and Caboodle (SQL Server).

Preferred Qualifications

• Epic reporting experience (Clarity, Caboodle, Cogito, Reporting Workbench, SlicerDicer); Cogito/Clarity certification is a plus.
• Experience with axiUm reporting tools (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 is a plus.
• Source control (Git), CI/CD for BI content, and development lifecycle in regulated environments.
• Cloud analytics familiarity (e.g., Azure SQL/Databricks, AWS RDS/Redshift); Power BI Service or Tableau Server administration basics.
• Experience in an academic health/dental or ambulatory care setting.
• 3+ years in analytics/reporting with EHR data (healthcare or dental strongly preferred).
• Hands-on SQL (complex joins, CTEs, window functions, performance tuning).
• Proven delivery of Power BI or Tableau dashboards end-to-end (requirements → deploy).
• Experience with reporting or database schema (Oracle Server), including key domains such as patients, appointments, procedures, providers, and billing.
• BI/Visualization: Power BI (preferred) or Tableau.
• ETL/ELT: SQL-based pipelines; SSIS/Azure Data Factory or equivalent.
• Scripting: Python (pandas) for data prep/validation/automation.
• Version Control: Git (branching, pull requests, release tags for reports/datasets).
• Security: RLS, workspace/app permissions, PII masking, audit logging.
• Experience and sensitivity in working with people of diverse backgrounds and cultures.
• Demonstrated experience advancing social justice, equity, and inclusion in a university setting.
• Ability to engage and integrate culturally responsive practices and knowledge in work.

Schedule

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

Pay

$36.93–$48.94 per hour. We consider factors such as scope and responsibilities of the position, candidate’s qualifications, internal equity, as well as market and organizational considerations when extending an offer.

Physical Requirements

• Work is primarily general office/administrative with frequent use of a computer keyboard, mouse, and phone.
• Requires sitting for the majority of the working day; occasional standing, walking, bending, and reaching.
• Occasional lifting of up to 25 lbs.