Advertised Summary Job Description: Reporting to the Assistant Director of Budget & Financial Planning at the School of Nursing, the Financial Analyst will act as a liaison between the Office of Finance and Administration and other University administrative offices to provide exceptional, first-class quality service to all customers.
Responsibilities will include the following:
Financial Reporting -Prepare quarterly financial reports of non-federal, unrestricted projects and analyze budget-to-actual variances on a quarterly basis. -Complete data analyses utilizing pivot tables, formula-based calculations (SUMIFs, V-Lookups, etc.) and other advanced functions within Microsoft Excel. -Process journal entries to correct expense allocations. -Assist in preparing the annual operating budget and the annual fiscal year-end close activities. -Assist in developing automated/streamlined processes in order to eliminate duplications and coordinate related data requirements. -Perform other related projects as needed and assigned.
Payroll -Process salary allocations and cost transfers via the Accounting & Reporting at Columbia (HR PAC) portal.
Accounts Payable and Procurement - Provide back-up support to the Accounts Payable & Procurement team members. - Process accounts payable transactions via the Accounting & Reporting at Columbia (ARC) portal; complete monthly reconciliations of procurement card transactions; and conduct spot audits. - Training: Develop training courses and materials for School of Nursing faculty and staff on Accounts Payable and Procurement policies, and coordinate and lead these trainings on a regular basis.
General Minimum Qualifications: Requires a bachelor's degree or equivalent in education and experience, plus three (3) years of related experience.
Additional Specific Minimum Qualifications: The Financial Analyst must have a working knowledge of basic accounting principles. The successful candidate will have advanced knowledge of Microsoft Office (Excel, Word, PowerPoint, and Access). Strong interpersonal, organizational and problem-solving skills are necessary for this role. The incumbent will also have the proven ability to manage multiple projects and tasks to meet strict deadlines, be detail-oriented, and be able to work independently.
Preferred Qualifications: Some experience with the following Columbia University financial tools is desirable for this position: Accounting & Reporting at Columbia (ARC & PAC). Prior experience working in higher education finance is also preferred. Knowledge of SQL is a plus.
As a member of the National Collegiate Athletic Association (NCAA) and the Council of Ivy Group Presidents (Ivy League), it is imperative that members of the Columbia University community, in all matters related to the intercollegiate athletics program, exhibit the highest professional standards and ethical behavior with regard to adherence to NCAA, Conference, University, and Department of Intercollegiate Athletics and Physical Education rules and regulations.
Columbia University is an Equal Opportunity/Affirmative Action employer.
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It... seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.