The position will be responsible for financial transactions, performing in-depth financial analyses, payroll transactions, budgeting, reporting, auditing, and generating complex financial reports as well as dissemination of important financial data, guidelines, and policies. The analyst will need strong oral and written communication skills. Experience with sponsored projects and post-award grants management skills strongly preferred. The position will report to the Sr. Financial Manager for the Department of Pathology and Cell Biology.
The incumbent will also be expected to attend finance trainings and meetings to stay updated on changes in internal and external policies and procedures as well as assisting Finance leadership with scheduling and facilitating Department Finance Meetings.
An ideal candidate must be able to quickly learn and understand critical institutional drivers and perform predictive analysis, inclusive of the development of metrics and dashboards for senior leadership. Perform analysis of financial reports and data, and prepare subsequent narrative analysis for management inclusive of recommendations. Develop detailed financial models to aid in annual budgeting, payroll reconciliations, projections, and reporting. Utilize knowledge of the university's financial accounting systems. This individual should have the ability to work independently to achieve departmental goals, deadlines, and desired outcomes/results. In addition, they are expected to collaborate and engage key stakeholders of the financial planning, payroll, and analysis process.
The incumbent on a regular and continuing basis develops knowledge of the formal and informal departmental goals, standards, policies and procedures which may include some familiarity of other departments within the school/division. Exhibits sensitivity to the interrelationship of both people and functions within and outside the department. Have an insatiable desire to solve business puzzles/challenges.
Key Administrative Responsibilities:
Answering ad hoc account and transaction inquiries
Assist Department Finance leadership with standardization of forms and templates as well as dissemination of standardized information to Divisional and Departmental parties and assist with the automation of Departmental dashboards, financial statements, and other frequently-used templates.
Implement monthly and quarterly reconciliation financial accounts (including Departmental payroll) and prepare reports for a variety of monthly and quarterly non-sponsored meetings. Utilize similar data gathering and reconciliation processes during budget season to ensure accurate budgeting and forecasting for future years.
This position will interact extensively with the PATH HR team, departmental research team, senior leadership, and faculty, as well as personnel within the PATH Business Office.
Recommends budget adjustments, and other cost improvement measures.
Develops complex financial models and reports for forecasting, trending, and results from the analysis.
Reviews and evaluates current internal/external financial/payroll processes and makes recommendations for improvements for automating and streamlining routine tasks.
Aids the department by organizing and prioritizing tasks required for achieving deadlines, department deliverables to include goals & objectives.
Takes the lead role when meeting with internal stakeholders by understanding the objective, drafting agendas, effectively communicates with meeting participants and makes the necessary preparations to make the meeting and outcomes productive and value-added.
Assist and act as a key partner to the PATH HR Payroll Specialist
Financial and Operational Analysis (50%)
Analyzes budget patterns, project expenditures and prepares approved budgets
Determines and advises on appropriate salary and additional compensation allocations for faculty and staff, in partnership with Research, Finance, Administration and Human Resources
Clears suspense, overdrafts, and liquidation of open commitments. Processes Labor Accounting transactions in a timely fashion.
Conducts account and variance analysis, budget analysis, and monitors grant and other funding activities; assists in grant budget reconciliations and committed effort reconciliations
Monitors and communicates budget expenditures to faculty, department directors and admin staff
Identifies budget issues, provide alternative solutions and resolve problems as required
Assist in preparing year-end reporting of Divisional financial performance
Prepare and refine financial forecasting models in support of evolving programs and strategy decisions
Review costs and perform a cost-benefit analysis on all areas within the Division as needed.
Process Management (30%)
Prepare monthly financial statements and analyses of variances
Assist in the year-end financial close-out process
Communicate with internal and external administrative offices to ensure established procedures are followed
Keep abreast of laws, regulations and internal policies that apply to departmental financial transactions and projects
Serve as a liaison between the department and the School's Finance team
Assist with the preparation, process and reconcile all affiliate institution agreements and transfers for the Department
Transactional Activity (15%)
Perform reconciliations and audits to ensure that transactions are complete and accurate
Other duties as assigned (5%)
Requires a bachelor's degree or equivalent in education and experience, plus three years of related experience.
Prefer 5 years of related experience, Advance degree or certification in accounting or finance, and experience working in a fast-paced environment.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 504009
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.