Job Description

The key job responsibilities of the Clinical Data Analyst (CDA) include managing research customer requests for data sets, working with the client to understand data needs, developing clear specifications of requirements, building complex queries, writing Structured Query Language (SQL) code , and translating those needs into data extract, documentation, and code. This may include the implementation of tools that are applied to clinical information that would allow clients to accomplish their research aims. The CDA. works closely with clinicians across all hospital/healthcare departments to understand and effectively extract data from data management systems. The incumbent will apply sound programming principles and standardized procedures to all requests to ensure reproducibility. The incumbent will support requests from various research domains. The incumbent must provide excellent customer service, troubleshoot system issues, and validate results.

The CDA will build code against UCSF's APeX or other electronic healthcare systems. This role must demonstrate clear communication with clients and team members. Other responsibilities include validating data, providing output in a clear understandable format and overall maintaining strong customer relationships with clients.

Department Overview

The University of California, San Francisco (UCSF) Department of Information Technology Academic Research Systems group is chartered to provide data services and infrastructure that support clinical researchers' computing and analytic requirements. Its services include providing data sets from clinical systems to researchers, the development support and maintenance of UCSFs secured environment (RAE and REDCap).

Responsibilities

of time

Essential Function (Yes/No)

Key Responsibilities

(To be completed by Supervisor)

30
YesWorks with business, technical, and clinical personnel to develop and implement complex clinical informatics programs. Manages multiple requests at one time, provides excellent customer services, troubleshoots system issues and validates results..
30
YesCollaborates closely with healthcare clinicians, researchers and IT applications and technical teams totranslate data extraction requests into clear programming requirments and specifications. Works closely with clinicians across all hospital / healthcare departments to understand and effectively extract operations workflow and patient experience objectives into technical requirements.
10
YesPerforms quality assurance testing of complex scope, runs SQL (Structured Query Language) queries for enhanced medical data access, and writes and maintains appropriate documentation of design and deployment processes, workflows, and results.
20
YesAs necessary, provides support, troubleshooting, problem solving, and instruction for clinical informatics users and participates in curriculum development for user training.
10
Collaborate with multidisciplinary teams to develop and maintain a centralized code repository and standardized data definitions for commonly requested EMR data, promoting data consistency, reusability, and efficient analytics workflows.
100%
(To update total %, enter the amount of time in whole numbers (without the % symbol - e.g., 15, 20) then highlight the total sum (e.g., 1%) at the bottom of the column and press F9. The total sum should add up to 100%.)

Qualifications

REQUIRED QUALIFICATIONS

• Bachelor's degree in health care information technology, computer science, or related area, and/or equivalent combination of experience/training.
• Certification: EPIC CLARITY DATA MODEL
• Minimum 5 years of related experience required
• Knowledge of the EPIC clarity data model, including patient, encounter, provider, diagnosis, procedure, medication, laboratory, and billing domains.
• Knowledge of EPIC cogito reporting architecture and associated reporting tools.
• Understanding of data lineage, provenance and movement of data from EPIC production systems into CLARITY.
• Understanding of healthcare privacy, security and regulatory requirements, including HIPAA and institutional policies governing protected health information.
• Advanced SQL programming skills for complex querying, joins, subqueries, and common table expressions.
• Broad and/or in-depth knowledge of 1-2 areas of focus in clinical informatics specialty areas. Knowledge of controlled terminology, clinical workflows, user interface optimization, clinical decision support, rules development, data integration and mining, clinical ontologies, and adoption of technology.
• Thorough knowledge of all relevant clinical informatics software and technology, and the complex concepts, principles, policies, methodologies, and industry standards and practices involved with patient care and electronic medical data management in the UC health care system.
• Detail-oriented, with proven ability to effectively manage time, see projects through to completion, organize competing priorities, and effectively address complex, urgent issues as they arise.
• Strong interpersonal skills, with the ability to collaborate productively, work in a team environment, and to train and support clinical informatics users at all professional and technical levels throughout the medical center.
• Strong problem-resolution skills, with the ability to quickly diagnose problems, and develop, test, and implement appropriate and effective solutions in a timely manner.
• Strong analytical skills and knowledge in documentation and reporting, with the ability to select and run queries, collect and analyze system performance data, and produce substantive reports and analyses.
• Ability to work with senior staff and managers in clinical information technology, health care management, and business analytics, serving as a technical resource and providing advice and counsel on issues of functionality, efficiency, cost-effectiveness, policy, and performance.

REQUIRED CERTIFICATION

• EPIC CLARITY DATA MODEL

Salary Information

The final salary and offer components are subject to additional approvals based on UC policy.

Your placement within the salary range is dependent on a number of factors including your work experience and internal equity within this position classification at UCSF. For positions that are represented by a labor union, placement within the salary range will be guided by the rules in the collective bargaining agreement.

To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html