Financial Analyst - Academic & Clinical Finance
-
Finance & Banking
Job Description & How to Apply Below
- 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 SummaryReporting 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.
- 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 chart field 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 New York-Presbyterian (NYP) clinical funds flow reporting, including physician effort reporting and pass-through reconciliations.
- 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.
- 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.
- Two years of related experience in 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.
- Successful completion of applicable compliance and systems training requirements
Columbia University is committed to the hiring of qualified local residents.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction