Financial Analyst - Academic & Clinical Finance

New York, New York, 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 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. 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.