Funds Flow & Health Finance Info Sys Analyst

Job Description

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.

Responsibilities

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

Qualifications

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.

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