Financial Analyst - Academic & Clinical Finance

Columbia University

New York (NY)

Sur place

USD 70 000 - 80 000

Plein temps

Il y a 3 jours
Soyez parmi les premiers à postuler

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

Columbia University in the City of New York is seeking a Financial Analyst to support Academic Finance and Clinical Finance within the Department of Medicine. The role partners with division leadership and works across Pre- and Post-Award, Dean's Office, Controller's Office, and HR.

You will prepare reports, manage month-end entries in ARC, monitor grants and clinical funds flow, and support budgeting and forecasting while maintaining detailed financial data and faculty salary analyses.

Qualifications

  • Bachelor's degree or equivalent in education and experience.
  • Advanced proficiency in Microsoft Excel with complex formulas and reporting.
  • Strong analytical, quantitative, and problem-solving skills.
  • Exceptional attention to detail and data accuracy.
  • Strong organizational, communication, and interpersonal skills.

Responsabilités

  • Prepare financial reports related to research and sponsored activity for divisions and Department leadership.
  • Upload month-end journal entries in ARC, including allocations for space, capital campaigns, education and research support, IT, and HR.
  • Maintain and update the Department's space database monthly.
  • Monitor grants and clinical trials with the Pre- and Post-Award team, including spending reviews and cost transfers.
  • Monitor endowment, gift, and unrestricted fund balances and expenditures.
  • Maintain Chair and Department of Medicine commitment tracking, including startup packages and Schedule F commitments.
  • Compile and analyze faculty non-clinical salary support for annual effort reporting and compensation planning.
  • Prepare monthly and quarterly P&L statements for division leadership.
  • Upload month-end entries in ARC for tax, malpractice, and rent allocations.
  • Monitor clinical expenses and chartstrings, prepare corrections and chartfield requests.
  • Maintain physician clinical effort (cFTE) and productivity data for the clinical compensation plan.
  • Compile and report clinical activity data from Epic, including CPT utilization and payer mix.
  • Support NYP clinical funds flow reporting and pass-through reconciliations.
  • Participate in annual budget process and quarterly forecast updates.
  • Support year-end close activities including accruals and reconciliations.
  • Prepare ad hoc financial analyses for divisions and leadership.
  • Assist with special projects and other duties.

Connaissances

Analytical skills
Advanced Excel
Budgeting
Communication

Formation

Bachelor's degree or equivalent

Outils

ARC
Epic
Reporting tools

Description du poste

  • Job Type: Officer of Administration
  • Regular/Temporary: Regular
  • Hours Per Week: 35
  • Salary Range: $70,000.00 - $80,000.00

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.

Position Summary

Reporting to the Chief Financial Officer and the Associate Director of Clinical Finance, the Financial Analyst supports both the Academic Finance and Clinical Finance teams within the Department of Medicine. The incumbent collaborates closely with Divisional Administrators and Department leadership and serves as a liaison with the Pre- and Post-Award team, Dean's Office, Controller's Office, and Human Resources.

Responsibilities
Academic Finance
  • Prepare financial reports related to research and sponsored activity for divisions and Department leadership.
  • Prepare and upload month-end journal entries in ARC, including allocations for space, capital campaigns, education and research support, information technology, and human resources.
  • Maintain and update the Department's space database on a monthly basis.
  • Partner with the Pre- and Post-Award team to monitor grants and clinical trials, including spending reviews, chartstring corrections, and cost transfers.
  • Monitor endowment, gift, and unrestricted fund balances and expenditures.
  • Maintain Department Chair and Department of Medicine commitment tracking, including faculty start-up packages and Schedule F commitments.
  • Compile and analyze faculty non-clinical salary support, including grant-funded salary support, for annual effort reporting and compensation planning.
Clinical Finance
  • Prepare monthly and quarterly divisional clinical profit and loss (P&L) statements and variance analyses for Division Administrators and Department leadership.
  • Prepare and upload month-end journal entries in ARC, including tax, malpractice, and rent allocations.
  • Monitor clinical expenses and chartstrings, prepare corrections, and submit chartfield requests.
  • Maintain physician clinical effort (cFTE) and productivity (wRVU) data in support of the clinical compensation plan, including quarterly cFTE updates and wRVU incentive calculations.
  • Compile, analyze, and report clinical activity data from Epic, including CPT utilization, payer mix, APP billing activity, and provider template utilization.
  • Support NewYork-Presbyterian (NYP) clinical funds flow reporting, including physician effort reporting and pass-through reconciliations.
General Finance Responsibilities
  • Participate in the annual budget process and quarterly forecast updates, including preparation and processing of budget entries.
  • Support fiscal year-end close activities, including accruals, reconciliations, and year-end journal entries.
  • Prepare ad hoc financial analyses and reports for divisions and Department leadership.
  • Assist with special projects and perform other duties as assigned.
Minimum Qualifications
  • Bachelor's degree or equivalent in education and experience, plus a minimum of two years of related financial, accounting, budgeting, or analytical experience.
  • Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, data analysis, and reporting.
  • Strong analytical, quantitative, and problem-solving skills.
  • Exceptional attention to detail and commitment to data accuracy.
  • Strong organizational, communication, and interpersonal skills, with the ability to manage multiple priorities and meet deadlines.
  • Ability to work independently and collaboratively in a fast-paced academic healthcare environment.
Preferred Qualifications
  • Two years of related experiencein academic medicine, higher education, healthcare finance, or a related environment.
  • Experience with sponsored projects, grants management, or clinical finance operations.
  • Familiarity with Columbia University's ARC financial system, Epic, and reporting tools.
  • Familiarity with emerging technologies and productivity tools, including AI-assisted applications such as Microsoft Copilot, with the ability to evaluate outputs for accuracy and appropriately handle confidential information.
Other Requirements
  • Successful completion of applicable compliance and systems training requirements
Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Sr Analyst, Clin Finance/Ops
Sr Analyst, Clin Finance/Ops

Columbia University in the City of New York • New York (NY)

Sur place
USD 100 000 - 125 000
Financial Analyst
Financial Analyst

Columbia University in the City of New York • New York (NY)

Sur place
USD 66 000 - 75 000
Financial Analyst
Financial Analyst

Columbia University Irving Medical Center • New York (NY)

Sur place
USD 66 000 - 75 000
Finance Analyst: Academic & Clinical Medicine
Finance Analyst: Academic & Clinical Medicine

Columbia University • New York (NY)

Sur place
USD 70 000 - 80 000
Finance Coordinator
Finance Coordinator

Columbia University Irving Medical Center • New York (NY)

Hybride
USD 80 000 - 92 000
Senior Financial Analyst - Clinical Trials & Budgeting
Senior Financial Analyst - Clinical Trials & Budgeting

Columbia University in the City of New York • New York (NY)

Hybride
USD 100 000 - 120 000
Finance Coordinator: EH&S Budget & Analytics
Finance Coordinator: EH&S Budget & Analytics

Columbia University Irving Medical Center • New York (NY)

Hybride
USD 80 000 - 92 000
Senior Grants Manager - General Medicine
Senior Grants Manager - General Medicine

Columbia University • New York (NY)

Sur place
USD 100 000 - 120 000
Director, Financial Management
Director, Financial Management

Columbia University • New York (NY)

Hybride
USD 145 000 - 165 000
Senior Financial Analyst - CICET
Senior Financial Analyst - CICET

Columbia University in the City of New York • New York (NY)

Sur place
USD 100 000 - 120 000