UCSF

Public health sciences university in San Francisco

Funds Flow & Health Finance Information Systems Analyst

Data Analysis +1Posted on Nov 10

Full-timeSan Francisco, CA, USA$120k - $175k

About the Job

Requirements

A bachelor's degree in a related area, or equivalent experience or training.
At least 3 years of experience in information systems, data analytics, or related work.
Experience using SQL or comparable data-querying tools to extract, analyze, validate, and reconcile data.
Analytical and problem-solving skills to investigate data or system issues, identify potential causes, and develop appropriate solutions.
Knowledge of business and process analysis concepts and applying information systems and data solutions to business needs.
Working knowledge of relational database concepts, data structures, data integration, data mapping, and data quality principles.
Ability to validate analytical results and perform structured testing of data, reports, processes, or applications.
Ability to develop clear and concise technical and functional documentation, procedures, requirements, and training materials.
Written and verbal communication and interpersonal skills to work effectively with technical and non-technical stakeholders.
Ability to learn new technologies and business processes, work independently and collaboratively, manage multiple priorities, and meet established deadlines.

Responsibilities

Perform and support recurring clinical funds flow production processes, including data preparation, execution of established methodologies and business rules, validation, reconciliation, exception analysis, journal file generation, and troubleshooting.
Investigate discrepancies in funds flow calculations and underlying data, and collaborate with Finance, Revenue Cycle, operational, and technical stakeholders to resolve issues.
Perform testing and validation associated with changes to source data, calculations, business rules, mappings, and related systems.
Maintain recurring production schedules and procedures to support accurate and timely delivery of funds flow outputs.
Develop, modify, test, and maintain SQL queries, stored procedures, data extracts, reports, data transformations, and related analytical solutions supporting funds flow and Health Finance requirements.
Analyze and integrate information from clinical billing, revenue cycle, financial, provider, human resources, and other enterprise data sources.
Participate in development and maintenance of data models, data warehouse and data lake solutions, interfaces, and data flows between source applications, analytical repositories, and downstream Finance systems.
Troubleshoot data and application issues, working with other IT resources to identify root causes and implement sustainable solutions.
Perform financial, reimbursement, revenue cycle, and operational analyses for Finance and other business stakeholders.
Develop and validate analytical outputs involving collections, reimbursement, charges, payments, denials, accounts receivable, RVUs, financial class, payer or plan, provider, specialty, and other relevant financial or operational dimensions.
Support periodic reimbursement and collection analyses and investigate variances or unexpected results using available financial, clinical, and revenue cycle data.
Perform data quality review, reconciliation, and exception analysis to identify conditions that may affect funds flow and other financial outputs.
Collaborate with business and technical stakeholders to research and resolve source-data and mapping issues.
Develop and maintain provider, specialty, payer, financial, and other reference mappings and business rules used in funds flow and related analytics, including provider specialty classifications and MGMA specialty mappings where applicable.
Gather and analyze business and user requirements and translate them into data, reporting, system, and process specifications.
Assist with evaluation, testing, documentation, and implementation of changes to existing financial and analytical processes.
Develop and maintain standard operating procedures, technical and functional documentation, data definitions, validation procedures, training materials, and other knowledge resources.
Identify opportunities to improve process efficiency, data quality, reliability, and maintainability.
Participate in Health Finance data and analytics projects involving business intelligence, provider productivity, financial reporting, enterprise data platforms, and system integrations.
Develop or support reports and analytical products and provide technical and analytical assistance to Finance and operational users as assigned.

Desired Qualifications

EPIC Cogito Certification.
Familiarity with provider productivity measures, including RVUs or wRVUs, provider specialty classifications, or MGMA data.
Experience with financial data, ERP or general ledger systems, or financial system interfaces.
Experience working with recurring production processes requiring data validation, reconciliation, quality control, and deadline management.

This position requires working onsite in San Francisco, CA once a week.

Certain terms and conditions of employment for this position, including the rate of pay, benefits, etc., are currently subject to negotiation with the appropriate union.

The Enterprise Information Analytics (EIA) Health Finance team is seeking an Information Systems Analyst to develop, operate, and support data and analytics solutions for UCSF Health Finance. The position combines data analysis, database querying and development, business and systems analysis, reporting, data integration, and production support to address financial and operational business needs.

The incumbent will have significant responsibility for supporting clinical funds flow processes, including recurring production activities, data preparation and validation, reconciliation, provider and specialty mapping, financial and reimbursement analysis, business-rule maintenance, reporting, journal file generation, troubleshooting, testing, and process documentation.

The position works collaboratively with Finance, Revenue Cycle, operational stakeholders, and IT teams to translate business requirements into data and technology solutions; identify and resolve data quality and process issues; and support accurate, timely, and sustainable financial outputs. The incumbent will also participate in broader Health Finance data and analytics initiatives, including enterprise data warehouse, data lake, provider productivity, business intelligence, and financial system integration efforts.

Department Overview

Enterprise Information Analytics (EIA) Health Finance is an Information Technology team specializing in the development and support of data, analytics, reporting, and custom technology solutions for UCSF Health's financial and operational functions. The team partners with Finance, Revenue Cycle, clinical operations, and other enterprise stakeholders to translate business requirements into reliable and actionable data solutions.

EIA Health Finance develops and supports custom applications and processes, including clinical funds flow, provider productivity, financial reporting, and other enterprise finance solutions. The team collaborates in the development and maintenance of enterprise data lake and data warehouse capabilities supporting provider productivity and other financial and operational measures and integrates information across clinical, revenue cycle, human resources, financial, and other enterprise systems.

The team consumes, transforms, and produces data used by ERP and other Finance functions and supports data quality, business rules, system integration, reporting, reconciliation, and analytics used for financial operations and decision-making.

REQUIRED QUALIFICATIONS

Bachelor's degree in a related area and/or equivalent experience/training.
Minimum 3 years of experience in information systems, data analytics, or related work
Demonstrated experience using SQL or comparable data-querying tools to extract, analyze, validate, and reconcile data.
Demonstrated analytical and problem-solving skills with the ability to investigate data or system issues, identify potential causes, and develop appropriate solutions.
Knowledge of business and process analysis concepts and the application of information systems and data solutions to business needs.
Working knowledge of relational database concepts, data structures, data integration, data mapping, and data quality principles.
Demonstrated ability to validate analytical results and perform structured testing of data, reports, processes, or applications.
Ability to develop clear and concise technical and functional documentation, procedures, requirements, and training materials.
Strong written and verbal communication and interpersonal skills, with the ability to work effectively with both technical and non-technical stakeholders.
Demonstrated ability to learn new technologies and business processes, work independently and collaboratively, manage multiple priorities, and meet established deadlines.

PREFERRED QUALIFICATIONS

EPIC Cogito Certification
Familiarity with provider productivity measures, including RVUs/wRVUs, provider specialty classifications, or MGMA data.
Experience with financial data, ERP/general ledger systems, or financial system interfaces.
Experience working with recurring production processes requiring data validation, reconciliation, quality control, and deadline management.

% of time	Essential Function (Yes/No)	Key Responsibilities (To be completed by Supervisor)
35		Funds Flow Operations, Validation & Support Performs and supports recurring clinical funds flow production processes, including data preparation, execution of established methodologies and business rules, validation, reconciliation, exception analysis, journal file generation, and troubleshooting. Investigates discrepancies in funds flow calculations and underlying data and collaborates with Finance, Revenue Cycle, operational, and technical stakeholders to resolve issues. Performs testing and validation associated with changes to source data, calculations, business rules, mappings, and related systems. Maintains recurring production schedules and procedures to support accurate and timely delivery of funds flow outputs.
25		Data Analysis, Development & Integration Develops, modifies, tests, and maintains SQL queries, stored procedures, data extracts, reports, data transformations, and related analytical solutions supporting funds flow and Health Finance requirements. Analyzes and integrates information from clinical billing, revenue cycle, financial, provider, human resources, and other enterprise data sources. Participates in development and maintenance of data models, data warehouse/data lake solutions, interfaces, and data flows between source applications, analytical repositories, and downstream Finance systems. Troubleshoots data and application issues and works with other IT resources as needed to identify root causes and implement sustainable solutions.
15		Financial, Reimbursement & Revenue Cycle Analytics Performs financial, reimbursement, revenue cycle, and operational analyses for Finance and other business stakeholders. Develops and validates analytical outputs involving collections, reimbursement, charges, payments, denials, accounts receivable, RVUs, financial class, payer/plan, provider, specialty, and other relevant financial or operational dimensions. Supports periodic reimbursement and collection analyses and investigates variances or unexpected results using available financial, clinical, and revenue cycle data.
10		Data Quality, Mapping & Business Rules Performs data quality review, reconciliation, and exception analysis to identify conditions that may affect funds flow and other financial outputs. Collaborates with business and technical stakeholders to research and resolve source-data and mapping issues. Develops and maintains provider, specialty, payer, financial, and other reference mappings and business rules used in funds flow and related analytics, including provider specialty classifications and MGMA specialty mappings where applicable.
10		Business Analysis, Documentation & Process Improvement Gathers and analyzes business and user requirements and translates requirements into data, reporting, system, and process specifications. Assists with evaluation, testing, documentation, and implementation of changes to existing financial and analytical processes. Develops and maintains standard operating procedures, technical and functional documentation, data definitions, validation procedures, training materials, and other knowledge resources. Identifies opportunities to improve process efficiency, data quality, reliability, and maintainability.
5		Health Finance Projects, Reporting & User Support Participates in Health Finance data and analytics projects involving business intelligence, provider productivity, financial reporting, enterprise data platforms, and system integrations. Develops or supports reports and analytical products and provides technical and analytical assistance to Finance and operational users as assigned.
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%.)

Budgeted Job Salary Range: 120000 - 175000

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