Financial Analyst

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: $75,000 - $85,000

Position Summary

Reporting to the Senior Manager of Finance and Budget Ops in the Department of Orthopedic Surgery, the Financial Analyst will perform tasks related to managing and supporting the department???s financial activities.

Responsibilities

• Set up accounts and provide training for CU security accesses for all personnel in need. Serve as the go-to-person for policies regarding accesses (i.e., ARC, Concur, P-card)
• Reconcile all practice plans billing to CU bank activity ($48 mil practice plan), including bank reconciliations and accrual reporting
• Reconcile P-card for the finance team on monthly basis. Ensure all P-card transactions are pre-approved and reviewed before use to ensure compliance.
• Manage all space and equipment leases and purchases for all sites. Responsible for all department leases/purchases and training interfaces with CU Controllers office and Treasury for credit card machines, PAM and other set ups, and annual security trainings.
• Primary resource for team on all transaction processing ??? payables, NYOHA, CU NYP, vouchers, requisitions, and Purchase Orders. Act as the primary liaison with CU FPO finance departments, CU and NYP purchasing and A/P departments.
• Payroll transactions such as creating combo codes, clearing suspense accounts, ensuring all salaries paid monthly are correct and assisting with processing quarterly bonus payments, salary increases, and preparing salary and bonus letters
• Assist with CU roster preparation
• Manage monthly Service Corp reconciliation
• Manage the department???s use of chart fields in ARC to fully optimize reporting capabilities
• Entering budget transactions and updating budget monthly in COB under direction of Sr. Manager, Finance & Budget Ops
• Process all expenses on research accounts ??? works with Research Coordinators and Sr. Manager of Finance & Budget Ops to track all budgets and expense on sponsored projects and gifts including NYP funds. Ensure compliance with intent of funding agency
• Manage spending on all NYP gift accounts and summarizes NYP funds on monthly basis
• Manage all cash deposits, gifts and other income ??? including alerting physicians of donations when available
• Prepare monthly and quarterly reports by faculty member, division for clinical, research and gift activities
• Track annual expenses by provider to ensure compliance with University and Departmental cap
• Assist with rotation of monthly close process and budget updates. Assure all transactions have appropriate segments associated before month end; prepare all journal entries for upload into ARC.
• Performs related duties & responsibilities as assigned/requested

Minimum Qualifications

• Bachelor's degree in Accounting/Finance/Business or equivalent in education and experience, plus three years of related experience

Preferred Qualifications

• Experience in an academic/medical office
• Advanced knowledge of MS Office (Excel, Word and PowerPoint)
• Strong interpersonal and communication (oral and written) skills
• Experience in ARC system strongly preferred

Equal Opportunity Employer / Disability / Veteran

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