The Financial Payroll Analyst will provide financial support to the PATH budget &finance and HR team in the Department of Pathology and Cell Biology. The position will be responsible for performing and managing financial payroll transactions, conducting in-depth financial analyses, budget payroll reconciliations, financial reporting, auditing, and generating complex analysis financial payroll reports as well as dissemination of important financial data, payroll guidelines, and policies. The analyst will need strong oral and written communication skills.
The incumbent will also be expected to attend job-related trainings and meetings to stay updated on changes in internal and external policies and procedures.
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 payroll and budget 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 and payroll 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.
Answering ad hoc account and transaction inquiries
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 based on payroll needs.
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.
Assist and act as a key partner to the PATH HR Payroll Specialist
Financial and Operational Analysis (50%)
Analyze budget patterns, project expenditures and prepare an approved budget
Monitor and communicate budget expenditures to faculty, department directors and admin staff
Identify 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.
Conducts account and variance analysis, budget analysis, and monitors grant and other funding activities; assists in grant budget reconciliations;
Clears suspense, overdrafts, and liquidation of open commitments. Supports processing of Labor Accounting transactions
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%)
Prefer 5 years of related experience, Advance degree or certification in accounting or finance, and experience working in a fast-paced environment.
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: 500761
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.