Clinical Informatics Specialist

Job Summary

Clinical Informatics Specialist (University of California, Davis; Sacramento, CA):
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 counsel 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.

• 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.

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

• Salary or Pay Range: $ - $
• 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 (HSP
  165)
• Union Representation: HX-Healthcare Professionals
• Benefits Eligible:
  Yes
• This position is hybrid (mix of on-site and remote work)

Outstanding benefits and perks are among the many rewards of working for the University of California. UC Davis offers a full range of benefits, resources and programs to help you bring your best self to work, as well as to help you and your family achieve your health, wellness, financial and career goals. Learn more about the benefits below and eligibility rules by visiting either our handy Benefits Summary for UC Davis Health Employees or Benefits Summary for UC Davis Employees and our Benefits Page.

• 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…