DATA SYS ANL 3

Job Summary:

The Clinical Revenue and Research Data Analyst is a skilled data and information management professional with expertise in data analysis, SQL query development, Tableau, and programming languages such as Python. This role requires experience or a strong interest in leveraging AI and other emerging technologies to enhance data insights and operational efficiency. This position will play a key role in supporting the Department of Medicine (DOM) clinical enterprise through data analysis and data management. The analyst is responsible for delivering accurate, reliable, and well-structured data to a diverse group of stakeholders. This includes validating data across multiple sources, identifying inconsistencies, and streamlining data request processes to improve accessibility and usability.

The Clinical Revenue and Research Data Analyst will report to the Project and Product Manager for the Department of Medicine Portals Team and the Director of Research Administration & Revenue Management. This person will provide support for three main areas: clinical revenue, research analytics, and financial internal controls. 

The incumbent must be proficient in designing queries and managing a diverse set of data to answer business questions. The incumbent will work collaboratively with stakeholders to assess high-priority business questions, evaluate available data sources, help design and implement reports and visualizations to answer these questions, and perform data validation to ensure accuracy. The individual is expected to leverage AI (e.g., custom GPTs) and API-based solutions to design and operationalize intelligent, automated data workflows, and to drive scalable improvements across departmental data processes.

The Clinical Revenue and Research Data Analyst will support the department’s clinical mission by investigating questions related to clinical revenue and physician productivity. They will also gather data and develop charts and reports to enable the department to evaluate the success of the department’s research mission. Finally, the Clinical Revenue and Research Data Analyst will play a key role in strengthening the department’s internal controls. Come be a part of our team and use your analytic skills in support of a great mission to advance healthcare worldwide!

Department Description:

The Department of Medicine (DOM) is the largest department in the School of Medicine (SOM) at UCSF. The DOM has an annual budget of $726M across three sites with ~3,000 employees and trainees. The DOM comprises 22% of all UCSF faculty, 26% of the SOM’s faculty, and 20% of the SOM budget. The DOM has consistently ranked among the top departments of medicine in the country. 

% of timeEssential Function (Yes/No)Key Responsibilities (To be completed by Supervisor)

10

YesApplies professional and broadly defined business analysis and data / information administration and data use concepts to manage and perform complex assignments.

15

YesIndependently analyzes complex information requirements and documents them using formal data definition techniques and naming standards. Gathers, analyzes, prepares and summarizes information from subject matter experts and technical personnel. Researches relevant problem-domain literature and information standards and develops recommendations for data management resource plans including approaches, trends, sources and uses.

30

Yes

The Clinical Revenue and Research Data Analyst will play a key role in supporting the DOM clinical enterprise by providing analytic and project support related to clinical revenue management:

• Provide existing data sources for DOM-wide clinical revenue management 
• Assist in validating PRISM reports on clinical revenue and transforming them into actionable data for Division Managers to use 
• Analyze provider productivity in selected Divisions to understand which providers are earning < 80% the division average for wRVUs per session 
• Support for miscellaneous clinical revenue questions/problems that arise, and project management support to keep track of outstanding issues with FPRMO
• Assist with the development/coordination of resources to improve education/training on documentation/billing. 
• Compile and manage data necessary to evaluate the state of DOM research at regular intervals.
• Assist with ad-hoc requests to answer questions about the department’s research mission from Division Chiefs, the Associate Chairs of Research and other stakeholders

• Assist with the development and validation of PRISM reports related to the research mission.

15

YesThe Clinical Revenue and Research Data Analyst will provide analytic