Reporting to the Principal Investigator (PI) and working closely with the current administrator of the BioElectronic Systems Lab, the Project Coordinator provides high-level expense management to the Principal Investigator and group researchers. The Coordinator will oversee all procurement for the group. Produces and analyzes reports necessary for government grant proposals, including budgets, and conflict tables. Advises students on account issues, housing issues, and defense planning, as well as ensure research needs are met. Works independently and under minimal supervision, insuring accuracy of work product and timeliness of submission to meet critical deadlines. Additionally, the Project Coordinator will have the ability to suggest and make changes that will streamline processes.
(30%) Manages procurement operations for the group: Manages the procurement of supplies and minor equipment, both through PCard and tracks receipt of orders (packing slips) on shared group Wiki database. Manages the procurement and tracking of major capital assets and complex fabricated assets through requisitions in ARC Reconciles PCard transactions on a monthly basis in ARC. Manages procurement, vendors, and lab requisitions, liaising with vendors and lab members to source competitive quotes, complete sole source Justifications when necessary, and execute purchasing agreements. Works on procurement independently and under minimal supervision in a timely and accurate manner.
(30%) Provides extensive managerial support for the financial operations of the group: Analyzes and takes required relevant action regarding financial information for TBERS as well as subcontractor and vendor invoices using ARC Database. Creates custom reports based on data from Financial Database, FDS, and reconciles them will planned spending. Meets with senior leadership monthly to present financial reports and advise on planned spending. Serves as backup to group administrator on labor accounting (salary allocations, cost transfers, combo code creation, etc.) In PAC, as well as budget analyses and planning, using group's Excel shadow ledger.
(20%) Provides support for government grant proposals and progress reports: Produces and analyzes justifications for new grant proposals and outlines budget parameters for collaborators at other institutions and senior managers and leaders.Manages confidential data and sensitive information, including proposals and progress reports as necessary. Evaluates detailed statements for progress reports and audits (Internal and external) as necessary.
(10%) Student and Postdoc advising: Liaises between students and Student Financial Services to troubleshoot account issues. Advises students on thesis defense planning. Serves as mediator between postdocs and department on housing issues (housing applications and housing supplement payment status
(10%) Performs other related projects and assignments.
Bachelor's degree 2-4 years related experience, excellent communication, interpersonal and organizational skills. Must be able to work independently with minimal supervision. Quantitative skills are essential for this position. Must be able to work interactively and collaboratively with faculty, research staff, University offices, and external granting agencies. Must be very in Microsoft Office, especially Excel, and other related software required. Must be flexible in terms of working hours, priorities, and deadlines.
Proficiency in a corporate or enterprise database management systems such as PeopleSoft if desirable.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 505210
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.