Financial Analyst

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule: Mon - Fri (9am - 5pm)
• Building: Columbia University Medical Center
• Salary Range: $66,300.00 - $80,000.00

Position Summary

The Financial Analyst is responsible for overseeing and supporting the budget and financial reporting for the Departments of Otolaryngology, Surgery and Urology. Reporting to the Manager of Budget and Finance, the position will work with both faculty and administrative staff to ensure the departments operate in a fiscally sustainable manner.

Responsibilities

• Partner with the manager of budget and finance in financial management of Surgery, Otolaryngology, and Urology, and contribute to budget planning, monitoring financial entries, transaction audits, and daily operations.
• Support the department’s senior director of budget and finance, assistant director of budget and finance, senior financial analysts, and other financial analysts.

NYPH pass-through projects:

• Monitor large and complex NYPH pass-through transactions. Update the project schedule and prepare allocations.
• Track all new and pending lines, communicate with NYPH finance team, and report to the team.
• Prepare reconciliation templates for dean’s office if meetings are scheduled.

Malpractice Insurance:

• Work with HR to support onboarding officers to ensure classes are coded correctly.
• Communicate with CMO to receive credits for terminated physicians, short-term leave staff, and retiring members.
• Prepare other required paperwork and distribute annual malpractice insurance certificates to division assistants.

Financial Report Preparation:

• Routinely create monthly, quarterly, and annual transfers within Surgery and to outside departments. Also, generate similar reports for Otolaryngology, and Urology.

HeartSource financial management:

• Collaborate with HeartSource COO, generate financial reports, prepare internal transfer funds, and notify Cardiology for approval.

Invoicing:

• Get familiar with medical service agreements, produce monthly invoices.
• Monitor agreement negotiation, changes in rates, and extension execution.
• Help accounting with journal updates when payment.

Accounts Receivable:

• Track and oversee accounts receivable for MSAs, NYPH funds, and many other transactions with outside organizations.
• Monitor past due payments and communicate with the team. Reconcile bank accounts and submit transfer requests.

Ad hoc Reporting and Analysis:

• Prepare many one-off reports and analyses on demand as requested by supervisor and CFO.

Data entry

• Publish daily trial balance reports for Surgery, Otolaryngology, and Urology.
• Help team members with data entries in service corporation, malpractice insurance, telecommunication, and other shared allocations.

Data Download:

• Get familiar with routine downloads and submit to requesters for approvals
• Other related duties as assigned.

Minimum Qualifications

Other Requirements

Qualifications for Candidates include but are not limited to the following:

• Must have strong analytical abilities.
• Must be able to manage and analyze large and complex data sets with a high degree of accuracy.
• Must be able to manage a high-volume workload.
• Must have strong organizational skills and capable of working independently as well as collaboratively.
• Must be detail oriented and be able to handle competing priorities.
• Effective interpersonal and communication skills required; excellent customer service.
• Intermediate to advanced level Excel and Adobe professional skills. 

Equal Opportunity Employer / Disability / Veteran

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