Financial Analyst
Location: San Francisco
Posted on: June 23, 2025
|
|
Job Description:
Location: Hybrid, mostly remote, Monday to Friday, 8-5. There
may be some occasional in person training or meetings or to meet
other business needs at 1855 Folsom St in San Francisco. Period of
performance: Immediate to an estimated 3-6 months, extension
possible. Candidates must be fully dedicated to the UCSF's job
duties. Candidate must have the following: - At least 5-10 years
experience in the Accounting and Finance field - Great
communicator, MUST be fluent in written & spoken English - Strong
excel and data analysis skills - Knowledgeable with positive
attitude, be professional CANDIDATES MUST ANSWER THE FOLLOWING
QUESTIONS AND HAVE THE ANSWERS IN THE BEGINNING OF THE RESUME: 1.
?This role involves managing multiple complex financial programs
and collaborating with various departments. Describe a situation
where you managed a cross-departmental project or financial
program. How did you approach leadership, problem-solving, and
decision-making, especially when handling competing priorities or
addressing complex issues? 2. In this role, you'll be responsible
for analyzing payment transactions and reconciling financial data.
Walk us through a time when you analyzed a large set of financial
data or reports to identify trends, discrepancies, or areas for
improvement. What tools and methods did you use in Excel to ensure
accuracy and provide actionable insights? 3. How do you use Pivot
Tables to summarize large sets of financial data? Can you give an
example of how you've used them to analyze transaction data,
reconcile payments, or generate financial reports? 4.Can you
explain how you would use the INDEX/MATCH function combination to
pull financial data from different tables or worksheets? How would
you apply this to reconcile payment transactions or perform audits?
5. How would you use Excel to perform a financial reconciliation,
such as comparing bank statements or payment receipts to the
general ledger? What tools or formulas would you use to ensure
accuracy and policy compliance?
Keywords: , Woodland , Financial Analyst, Accounting, Auditing , San Francisco, California