Funds Flow & Health Finance Info Sys Analyst

UCSF•San Francisco, CA

4d•$120,000 - $175,000•Hybrid

About The Position

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 role 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 supports 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 also participates in broader Health Finance data and analytics initiatives, including enterprise data warehouse, data lake, provider productivity, business intelligence, and financial system integration efforts. EIA Health Finance is an Information Technology team that develops and supports 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, and supports custom applications and processes such as clinical funds flow, provider productivity, financial reporting, and other enterprise finance solutions. It also supports enterprise data lake and warehouse capabilities, system integration, data quality, business rules, reporting, reconciliation, and analytics for financial operations and decision-making.

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.
Demonstrated experience using SQL or comparable data-querying tools to extract, analyze, validate, and reconcile data.
Analytical and problem-solving skills, including 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.
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 the ability 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.

Nice To Haves

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

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.
Test and validate changes to source data, calculations, business rules, mappings, and related systems; maintain recurring production schedules and procedures.
Develop, modify, test, and maintain SQL queries, stored procedures, data extracts, reports, data transformations, and related analytical solutions.
Analyze and integrate information from clinical billing, revenue cycle, financial, provider, human resources, and other enterprise data sources.
Participate in developing and maintaining 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, identify root causes with other IT resources, and implement sustainable solutions.
Perform financial, reimbursement, revenue cycle, and operational analyses, including analyses involving collections, reimbursement, charges, payments, denials, accounts receivable, RVUs, financial class, payer or plan, provider, and specialty.
Support periodic reimbursement and collection analyses and investigate variances or unexpected results.
Perform data quality review, reconciliation, and exception analysis; research and resolve source-data and mapping issues with business and technical stakeholders.
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 evaluating, testing, documenting, and implementing 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.