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.
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 r

Skills
SQL, Data Analysis, Negotiation, Quality Control, ERP, Documentation