Funds Flow & Health Finance Info Sys Analyst

University of California, San Francisco•San Francisco, CA

2d•Hybrid

About The Position

The Information Systems Analyst develops, operates, and supports data and analytics solutions for UCSF Health Finance. The role combines data analysis, database querying and development, business and systems analysis, reporting, data integration, and production support to address financial and operational needs. It has significant responsibility for 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 analyst works 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, sustainable financial outputs. The position also contributes to broader Health Finance initiatives, including enterprise data warehouse and data lake capabilities, provider productivity, business intelligence, and financial system integration. The role is onsite in San Francisco, California, once a week. Certain employment terms, including pay and benefits, are subject to negotiation with the appropriate union.

Requirements

Bachelor's degree in a related area and/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, including investigating data or system issues, identifying potential causes, and developing 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.
Strong written and verbal communication and interpersonal skills, including effectiveness with technical and non-technical stakeholders.
Ability to learn new technologies and business processes, work independently and collaboratively, manage multiple priorities, and meet deadlines.

Nice To Haves

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 with recurring production processes requiring data validation, reconciliation, quality control, and deadline management.

Responsibilities

Perform and support recurring clinical funds flow production, including data preparation, execution of methodologies and business rules, validation, reconciliation, exception analysis, journal file generation, and troubleshooting.
Investigate discrepancies in funds flow calculations and underlying data, collaborating with stakeholders to resolve issues.
Test and validate changes to source data, calculations, business rules, mappings, and related systems.
Maintain recurring production schedules and procedures for timely, accurate funds flow outputs.
Develop, modify, test, and maintain SQL queries, stored procedures, data extracts, reports, data transformations, and analytical solutions.
Analyze and integrate clinical billing, revenue cycle, financial, provider, human resources, and other enterprise data.
Participate in developing and maintaining data models, data warehouse and data lake solutions, interfaces, and data flows to downstream Finance systems.
Troubleshoot data and application issues and work with IT resources to identify root causes and sustainable solutions.
Perform financial, reimbursement, revenue cycle, and operational analyses; develop and validate outputs involving collections, reimbursement, charges, payments, denials, accounts receivable, RVUs, financial class, payer/plan, provider, and specialty.
Support periodic reimbursement and collection analyses and investigate variances or unexpected results.
Review data quality, reconcile data, analyze exceptions, and research and resolve source-data and mapping issues.
Develop and maintain provider, specialty, payer, financial, and other reference mappings and business rules, 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 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 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.