UCSF

Public health sciences university in San Francisco

Clinical Revenue and Research Data Analyst

Data AnalysisConfirmed live in the last 24 hours

Full-timeSan Francisco, CA, USA$110k - $140kIn-person

About the Job

Requirements

A bachelor's degree in a related area and a minimum of three years of experience, or an equivalent combination of experience and training.
At least five years of experience in data analytics, data management, or a related area.
Thorough knowledge of data management systems, practices, and standards.
Thorough knowledge of business intelligence functions, analytics, industry standards, and best practices.
Strong organizational skills.
Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems.
Strong data analysis and querying skills using Microsoft Excel and SQL.
Ability to work with people from diverse backgrounds, communicate effectively, interact interpersonally, and provide service-oriented support.
Ability to communicate technical information to technical and non-technical personnel at various organizational levels.
Strong problem-solving skills, ability to learn effectively and meet deadlines, critical thinking skills, and attention to detail.
Ability to prepare data models independently.
Ability to use AI tools or willingness to learn.
Familiarity with data model patterns in one or more common business or academic domains.
Familiarity with logical data design, data mapping, or data conversion.
Familiarity with data quality and governance issues and requirements.
Ability to work independently and as part of a team.

Responsibilities

Apply professional and broadly defined business analysis, data and information administration, and data-use concepts to manage and perform complex assignments.
Independently analyze complex information requirements and document them using formal data definition techniques and naming standards.
Gather, analyze, prepare, and summarize information from subject matter experts and technical personnel.
Research relevant problem-domain literature and information standards, and develop recommendations for data management resource plans, including approaches, trends, sources, and uses.
Provide existing data sources for department-wide clinical revenue management.
Assist in validating PRISM reports on clinical revenue and transforming them into actionable data for division managers.
Analyze provider productivity in selected divisions to identify providers earning less than 80% of the division average for work relative value units per session.
Support miscellaneous clinical revenue questions and problems, and provide project-management support to track outstanding issues with FPRMO.
Assist in developing and coordinating resources to improve education and training on documentation and billing.
Compile and manage data needed to evaluate the state of the department's research at regular intervals.
Assist with ad hoc requests from division chiefs, associate chairs of research, and other stakeholders about the department's research mission.
Assist in developing and validating PRISM reports related to the research mission.
Provide analytic support related to departmental research metrics, such as the volume of awards and proposals.
Compile and monitor overdrafts across the department and all fund groups, including sponsored projects, operating funds, gifts, and the default payroll account.
Coordinate outreach to department finance analysts overseeing projects in deficit and gather information and resolution plans.
Develop comprehensive financial risk analysis for the department's UCSF Health divisions.
Support financial compliance and risk management by initiating other queries as necessary.
Collaborate with stakeholders to assess high-priority business questions, evaluate available data sources, design and implement reports and visualizations, and validate data for accuracy.
Leverage AI tools, including custom GPTs, and API-based solutions to design and operationalize intelligent, automated data workflows and scalable improvements to departmental data processes.
Investigate questions related to clinical revenue and physician productivity, and gather data and develop charts and reports to evaluate research outcomes.

Desired Qualifications

Strong skills in financial risk management.
Ability to use Tableau or willingness to learn.
Thorough knowledge of university rules and regulations, processes, protocols, and procedures for budget, accounting, fund management, and/or personnel management.
Experience working at an academic medical center.
Prior experience supporting research in an academic environment.

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.

Required Qualifications:

Bachelor's degree in related area and minimum three years experience / or equivalent combination of experience / training.
Minimum of 5 years’ experience in data analytics, data management, or related
Thorough knowledge of data management systems, practices, and standards.
Thorough knowledge of business intelligence functions, analytics, industry standards and best practices
Strong organizational skills
Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems
Strong skills in data analysis and queries using Microsoft Excel and SQL
Demonstrated ability to work with others from diverse backgrounds. Demonstrated effective communication and interpersonal skills. Demonstrated service orientation skills.
Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization
Demonstrated strong problem-solving skills. Able to learn effectively and meet deadlines
Critical thinking skills and attention to detail
Ability to prepare data models unassisted.
Ability to use AI tools (or willingness to learn)
Familiarity with data model patterns in one or more common business or academic domains
Familiarity with logical data design and data mapping or data conversion
Familiarity with data quality and governance issues and requirements
Self-motivated and works independently and as part of a team.

Preferred Qualifications

Strong skills in financial risk management
Ability to use Tableau (or willingness to learn)
Thorough knowledge of University rules and regulations, processes, protocols and procedures for budget, accounting and fund management, and / or personnel management
Experience working at an academic medical center
Prior experience supporting research in an academic environment

% of time	Essential Function (Yes/No)	Key Responsibilities (To be completed by Supervisor)
10	Yes	Applies professional and broadly defined business analysis and data / information administration and data use concepts to manage and perform complex assignments.
15	Yes	Independently 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	Yes	The Clinical Revenue and Research Data Analyst will provide analytic support related to departmental research metrics such as volume of awards and proposals:
30	Yes	The Clinical Revenue and Research Data Analyst will provide analytic support related to financial internal controls: Compile and monitor overdrafts across the department and all fund groups including sponsored projects, operating funds, gifts and the default payroll account. Coordinate outreach to department finance analysts who oversee projects in deficit and gather information and resolution plans. Develop comprehensive financial risk analysis for the department’s UCSF Health divisions. Support financial compliance and risk management by initiating other queries as necessary.

Budgeted Job Salary Range: 110,000-140,000

About the Company

UCSF

Public health sciences university in San Francisco

UC San Francisco is a public research university in San Francisco focused solely on health sciences, combining professional education with biomedical research and patient care. Its schools of dentistry, medicine, nursing and pharmacy train clinicians and scientists, while teams investigate cancer, immunology, genomics and neuroscience. UCSF Medical Center and Benioff Children's Hospitals connect clinical care with faculty research and training, and university clinics serve patients across Northern California. Founded in 1864, UCSF is the University of California campus dedicated to graduate and professional education and biomedical research, based in San Francisco.

Company size: 10,001+
Company stage: Not listed
Total funding: Not listed
Headquarters: Not listed
Founded: 1864

Recently Posted Jobs

Explore more opportunities at UCSF

See more jobs