Reporting to the Executive Director of Finance and Operations, the Assistant Director of Operations and Finance will be responsible for managing the accounting and related reconciliation functions of the Fu Foundation School of Engineering & Applied Science (SEAS). The Assistant Director of Operations and Finance performs and oversees project reconciliations, payroll reconciliations, approves payroll cost transfers and manages post award accounting and reporting for all SEAS departments, institutes, and centers to ensure compliance with SEAS and University policies and procedures. This position will develop project reconciliation controls and administrative procedures to ensure reporting accuracy for academic and administrative departments. The Assistant Director of Operations and Finance monitors departmental funds and works with Department Administrators and Business Managers to review project reconciliations for policy compliance and GAAP accounting. This will entail project reconciliations for revenues and expenses; fund analysis and the researching of transactional data to ensure sufficient project funding and accurate reporting. This position will be responsible for providing guidance and training of University policy to all departmental finance and administrative staff. Ensures the timely reporting of all monthly financial information.
(35%) Payroll responsibilities: Reconcile and analyze payroll against internal ledgers; monitor departmental payroll suspense and provide guidance and assistance to departments. Prepare, review and approve Payroll (PAC) cost transfers and salary distributions. Prepare, review and reconcile CTV payments. Responsible for SEAS effort reporting in accordance with compliance requirements and policy. Serves as the School???s Primary Effort Coordinator (ECERT). Review, monitor and report on PI -Quarterly Attestations. Prepare and analyze monthly suspense reports and assist with the proper allocation of salaries across all funds. Prepare NIH_GRA Rate Calculation. Analyze and provide oversight of recharge centers.
(45%) Post Award Sponsored Projects responsibilities: Prepare monthly financial management reports for senior leadership and departments. Analyze trends in expenditures and F&A. Coordinate with departments to maintain compliance with, government agency and non-government post-award reporting. Monitors and assists departments in complying with OMB Uniform Guidance, including mandatory quarterly PI review of sponsored project accounts. Manage post award sponsored projects overdrafts and close outs. Monitor and assist in the reconciliation of ARC financial statements for all grants and sponsored programs against internal ledgers. Monitors expenditures of restricted funds for compliance, including cost sharing. Review and monitor overruns, accounts receivable and cash balance issues for grants. Review and develop monthly and quarterly reports on expenditures for grants and sponsored programs from federal, industrial and private agencies. Coordinate with the department and Controller???s Office cleaning overruns and balance sheet issues in preparation of the year end close. Responsible for ICR calculation and distribution. Quarterly reporting on MWBE_SBA. Monitor special projects and/or departments (AMAZON/GISS). Assist with the annual USNWR survey.
(15%) Additional responsibilities include reconciling and managing unrestricted Funds for general operating projects. Create and prepare compliance report of procurement card transactions. Analyze projects and prepare journal vouchers to correct financial accounting records. Assisting with responding to all audit requests. Laisse with the Controller???s Office and respond to requests. Respond to audit findings and monitor management corrective action plan. Reviews and approval purchase orders, purchasing requisitions; process financial invoices including travel/expense reimbursements. Responsible for monitoring account receivables and collections. Monitor endowment funds for appropriate utilization in accordance with terms. Works collaboratively with academic departments and centers. Provides guidance and makes recommendations for improving analysis and financial reporting. Collect and analyze data for trends, create financial management reports for senior leadership and departments. Review and make recommendations to achieve the goals of the school. The AD will also collaborate closely with the SEAS Facilities on space activity. May participate in development of budgets, monitoring, and approve expenditures.
(5%) Perform additional related duties as assigned.
Bachelor's degree in Accounting or related field and/or the equivalent. A minimum of 4-6 years related experience with demonstrated working knowledge GAAP (generally accepted accounting principles) and practices of payroll reconciliation . Must be detail-oriented with strong analytical and organizational skills. Experience with PeopleSoft. Must be able to identify priorities within multiple assignments in a high-pressured, short-deadline environment, and be able to work with diplomacy and efficiency in such an environment. Must be able to demonstrate excellent interpersonal, written and oral communication skills, including active listening skills. Strong proficiency in Microsoft Office (Word, Excel) essential. In addition, the successful candidate must be able to work well with all levels of employees, and have a passion for excellent customer service and commitment to exception quality
Demonstrated ability to work in a high pressured, fast-paced environment. Excellent organizational, verbal and written communication skills. Ability to proactively and assertively anticipate issues and address them as they arise. Track record of taking personal ownership/responsibility for delivering on departmental and organizational commitments. Demonstrated ability to work effectively partnering with others. Proven ability to apply good judgment, maintain confidences and manage confidential information and material. Ability to be precise and attentive to detail. Strong word processing, data base management and spreadsheet skills, preferably with MS Office (Word, Excel, Power Point) required. Degree in Human Resources, Finance or Accounting preferred. Must have proficiency with client/server HRIS applications, preferably PeopleSoft. Kronos experience strongly preferred.
Columbia University will require COVID vaccination for all Columbia University members who will have any on-campus presence. Individuals may claim exemption from the vaccine requirement for medical or religious reasons. More information regarding the University???s COVID vaccination requirement and exceptions may be found at the University???s ???COVID-19 Vaccine Information??? webpage: https://covid19.columbia.edu/ . Compliance with these measures is mandatory.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
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.