Clinical Informatics Specialist 4

Job Summary

Develop, design, and implement complex robust data transformations to meet business requirements for customers across the health system. Lead special projects, development of data marts, automation of data acquisition, and integration of complex data from various sources. Design, develop, and implement scripts and tools necessary to monitor and improve delivery of data across the UC Davis Enterprise. Promote and coordinate emerging analytic technologies to improve current processes enterprise-wide. Perform coding and configuration to meet documented needs, utilizing standard procedures and techniques. Identify and investigate data sources for purposes of data collection, automation, and validation. Develop documentation that supports operation procedures. Contribute to the development of test plans and participate in post-implementation reviews. Ensure the requirements for high availability of the reporting tools are implemented and periodically validated. Ensure the accuracy, timeliness, and completeness of reporting tools. Plan, execute, and support testing activities. Prepare support documentation and assist in training activities. Design, architect, and implement re-usable solutions for complex reporting system data loads and extracts. Prepare technical specifications illustrating data flow, ETL, and data model changes. Design, develop, and implement appropriate alerts for ETL failures. Create processes and procedures for addressing data load failures. Implement reporting system and ETL changes as a result of EMR and other upgrades. Provide council to leadership and stakeholders on how data can be best curated to provide business value. Interpret and present complex data to executive leadership. Act as a resource within the department regarding analytical approaches, data sources, and global health system perspectives to strategic issues. Analyze processes and design methods to integrate and interface new products into existing or new systems. Interface with business analysts and customers to clarify requirements. Understand sources of quality improvement data and communicate to others. Comply with UC Davis Health data management policies, practices, and procedures. Maintain appropriate meta-data documentation. Make appropriate use of Data Governance and Meta-data management system. Regularly track and report project progress and status. Escalate and resolve issues with other team members. Participate in project planning. Participate in team meetings.

Minimum Qualifications

• Bachelor's degree or foreign equivalent in Computer Science, Clinical Informatics, Statistics or related field
• Three (3) years of experience as a Database Administrator, Applications System Analyst, or related occupation
• Clinical data management in healthcare software systems; Extract, Transform, and Load (ETL) applications, architecture, and design; Epic EMR system; Structured Query Language (SQL); query tuning and optimization in MS-SQL Server or Oracle; database processes, technologies, and ETL Tools (SQL-Server MS SQL-Server Integration Service (SSIS); data modeling and architecture principles; translating customer requirements into technical specifications and documentation; developing and using logic and flow diagrams to describe the functional processes of a system that both end-users and programmers can understand
• Working in a structured Software Development Lifecycle methodology.

Key Responsibilities

• 50% - ETL Development and maintenance
• 20% - Business Analysis
• 20% - Support Data Governance
• 10% - Project Management

POSITION INFORMATION

• Salary or Pay Range: $102,400.00 - $202,400.00
• Salary Frequency: Monthly
• Salary Grade: 251
• UC Job Title: CLIN INFORMATICS SPEC 4 HX
• UC Job Code: 006361
• Number of Positions: 1
• Appointment Type: Staff: Career
• Percentage of Time: 100
• Shift (Work Schedule): M-F
• Location: UCDHAS Building (HSP165)
• Union Representation: HX-Healthcare Professionals
• Benefits Eligible: Yes
• This position is hybrid (mix of on-site and remote work)

Benefits

• High quality and low-cost medical plans to choose from to fit your family's needs
• UC pays for Dental and Vision insurance premiums for you and your family
• Extensive leave benefits including Pregnancy and Parental Leave, Family & Medical Leave
• Paid Holidays annually as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
• Paid Time Off/Vacation/Sick Time as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
• Continuing Education (CE) allowance and Education Reimbursement Program as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
• Access to free professional development courses and learning opportunities for personal and professional growth
• WorkLife and Wellness programs and resources
• On-site Employee Assistance Program including access to free mental health services
• Supplemental insurance offered including additional life, short/long term disability, pet insurance and legal coverage
• Public Service Loan Forgiveness (PSFL) Qualified Employer & Student Loan Repayment Assistance Program for qualified roles
• Retirement benefit options for eligible roles including Pension and other Retirement Saving Plans. More information on our retirement benefits can be found here

Physical Demands

• Standing - Frequent 3 to 6 Hours
• Walking - Frequent 3 to 6 Hours
• Sitting - Frequent 3 to 6 Hours
• Lifting/Carrying 0-25 Lbs - Occasional Up to 3 Hours
• Pushing/Pulling 0-25 Lbs - Occasional Up to 3 Hours
• Bending/Stooping - Occasional Up to 3 Hours
• Squatting/Kneeling - Occasional Up to 3 Hours
• Keyboard use/repetitive motion - Occasional Up to 3 Hours

Mental Demands

• Sustained attention and concentration - Frequent 3 to 6 Hours
• Complex problem solving/reasoning - Frequent 3 to 6 Hours
• Able to organize & prioritize - Frequent 3 to 6 Hours
• Communication skills - Frequent 3 to 6 Hours
• Numerical skills - Occasional Up to 3 Hours
• Constant Interaction - Occasional Up to 3 Hours
• Customer/Patient Contact - Occasional Up to 3 Hours
• Multiple Concurrent Tasks - Frequent 3 to 6 Hours

Work Environment

UC Davis is a smoke and tobacco free campus effective January 1, 2014. Smoking, the use of smokeless tobacco products, and the use of unregulated nicotine products (e-cigarettes) will be strictly prohibited on any UC Davis owned or leased property, indoors and outdoors, including parking lots and residential space.

Special Requirements

Please contact your recruiter with questions regarding which activities apply by position

Misconduct Disclosure Requirement

As a condition of employment, the final candidate who accepts a conditional offer of employment will be required to disclose if they have been subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct; received notice of any allegations or are currently the subject of any administrative or disciplinary proceedings involving misconduct; have left a position after receiving notice of allegations or while under investigation in an administrative or disciplinary proceeding involving misconduct; or have filed an appeal of a finding of misconduct with a previous employer.

A Culture of Opportunity and Belonging

We believe in growing through every challenge, continually striving to improve, and welcoming new perspectives that strengthen our community. We recognize that a vibrant and innovative organization values both individual strengths and shared purpose. The best ideas often emerge when people with different experiences come together.

Background Check

To view the University of California’s Anti-Discrimination Policy, please visit: https://policy.ucop.edu/doc/1001004/Anti-Discrimination

Misconduct Disclosure Requirement

To learn more about our background check program, please visit: https://hr.ucdavis.edu/departments/recruitment/ucd/selection/background-checks

Application Instructions

If you are interested in applying for this position, please follow the instructions provided in the application materials. The application deadline is August 29, 2026 at 11:59pm.