Reporting to the Department Administrator, the Sr. Financial Analyst performs a wide range of financial activities within the Department and supports all departmental personnel. The Sr. Financial Analyst participates in the development, monitoring, and review of the Pharmacology operating and grant budgets; gathers and summarizes data from various sources to perform reporting and analysis; assists with monthly, quarterly and year-end closing and reporting activities; assists with project reconciliations and documentation; administers Departmental accounting structure; ensures allocation of salary and non-salary expenses to correct funding sources; and acts as the Department's primary resource on matters related to procurement and accounting transactions. He/she works closely with the Department Administrator and Administrative Coordinator, focusing on both grant funding and Department level (non-grant) funding.
Review and approve all types of financial transactions in institutional financial system, including expense vouchers, purchase orders, P-card transactions, funding transfers, and revenue entries. Follow up on transactions with Dean's Office, as necessary, to ensure any additional approvals and processing steps are completed.
Review transactions submitted by others to ensure compliance with institutional policy, grant/funding source requirements, and accounting best practices. Will approve appropriate transactions (as noted above), assist with training new departmental personnel, and serve as back-up approver for Department Administrator.
Act as a departmental resource on all types of procurement transactions, including preparation of purchase requisitions/POs, invoice payments, check requests, and other mechanisms. Together with the Department Administrator, advise Department's administrative support personnel on procurement policy and procedure. May coordinate/initiate procurement transactions, especially complex purchases such as those with specific funding requirements or high dollar values.
Work closely with Department Administrator to prepare and submit the Department's annual operating budget, and to monitor budgetary compliance and update projections throughout the year using Budget Tool, FDS, and other financial systems. Act as a Departmental point person to the VP&S Finance office.
Maintain the Department's accounting structure and carry out accounting functions within it. With the Department Administrator, request creation of new chartfields and maintain listing of departmental chartstrings. Monitor fund balances and take corrective measures (such as clearing overruns) when needed, flagging concerns for follow-up or escalation where appropriate.
With the Department Administrator, maintain labor distribution schedules for faculty and other employees. Process salary distribution and cost transfer transactions. May review or approve transactions submitted by others. Set up charging for new personnel; verify funding availability, create combocodes, and coordinate charging with other departments as needed. Ensure transactions are cleared from suspense regularly.
Interact with Principal Investigators (PIs), lab managers, and other lab personnel on matters related to procurement and expenses for research labs. Together with the Department Administrator, provide guidance to lab managers and point people within research units; assist with management of service contracts and other agreements; and monitor expenses and financial activities for compliance, including PI approval of expenses where required.
Work closely with the Department Administrator to ensure faculty members' funding portfolios (grants, contracts, gift funds, endowments, and discretionary funds such as start-up funding) are properly managed. Attend and participate in meetings with PIs as needed. Act as a departmental point of contact and resource to the Administrative Coordinator.
Create reports and perform analyses on regular and ad hoc bases to summarize trends, identify exceptions, and explore what-if scenarios. Examples include variance analyses and projection of funding source run rate.
Assist with the coordination between the Department and the Pre-Award Core to ensure that PIs receive seamless and comprehensive support.
Assist the Department Administrator with a range of other financial and administrative tasks within the Department to ensure appropriate support and cross-coverage.
Bachelor's degree in Accounting or Finance, plus three years of related experience; or an equivalent combination of relevant education and experience.
Experience working in an academic medical center or scientific research environment.
Familiarity with Columbia financial systems or similar institutional IT systems.
Grants management experience.
Excellent oral/written communication, interpersonal, and organizational skills. Strong follow-up skills and ability to keep track of a long and complex to-do list in the face of tight deadlines and competing priorities.
Strong analytical skills. Ability to perform detailed analyses and track impact of numerous variables. Demonstrated ability to assess and resolve problems and to work in a collaborative, interdisciplinary setting.
Very strong Excel skills, including familiarity with data analysis features such as pivot tables. Familiarity with general software related to position including Word and Outlook.
Knowledge of fund accounting and grant management policies and procedures.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 501893
About Columbia University
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.