Funds Flow & Health Finance Info Sys Analyst

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.

About UCSF

The University of California, San Francisco (UCSF) is a leading university dedicated to promoting health worldwide through advanced biomedical research, graduate-level education in the life sciences and health professions, and excellence in patient care. It is the only campus in the 10-campus UC system dedicated exclusively to the health sciences. We bring together the world's leading experts in nearly every area of health. We are home to five Nobel laureates who have advanced the understanding of cancer, neurodegenerative diseases, aging and stem cells.

Pride Values

UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence - also known as our PRIDE values.

In addition to our PRIDE values, UCSF is committed to equity - both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available here.

Join us to find a rewarding career contributing to improving healthcare worldwide.

Equal Employment Opportunity

The University of California is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected status under state or federal law.

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

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%.)

%

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%.)