Salary Range: commensurate with university standard
Reporting to the Assistant Director, Budget and Financial Analysis, the incumbent independently maintains, updates and reconciles complex financial and budgetary activities within the Zuckerman Institute. The role is responsible for providing a wide range of financial analysis and performing various daily cash management activities in collaboration with the Assistant Director, Budget and Financial Analysis. The Finance and Accounting Associate will gain in depth knowledge of Columbia Universityâ€™s Chart of Accounts structure and how it relates to the Zuckerman Institute administration, research and platform programs. Specific duties include, but are not limited to:
Manages the financial administration for billing and collection; works with Scientific Platform departments in internal and external billings and collections; prepares and processes journal entries for billings using the Instituteâ€™s service and billing module- iLab. Prepares and processes external billings to other education institutions. Analyzes service revenue to ensure appropriate recognition. Develops expertise and ownership in the instituteâ€™s billing and collections platform- iLab.
Prepares and analyzes customized monthly/quarterly financial reports such as revenue and expense projections for platform revenue and collection reports for external billing.
Provides support with key financial activities such as annual budgeting process and reforecasting through budget tool transactions for sponsored project and unrestricted funds;
Performs reconciliation and trend analyses to project and manage revenue and expenses to budget plan and accruals;
Identifies, researches and independently resolves discrepancies discovered in the budget to actual reconciliation process;
Serves as an integral part of the monthly, quarterly, and annual closing process to ensure that financial information has been recorded accurately. Works with the Assistant Director, Budget and Financial Analysis to prepare monthly, quarterly, fiscal year end transactions and audit requests;
Prepares and processes journal entries inter-company transfers by analyzing general ledger accounting records.
Assists the Assistant Director in the development and implementation of finance operations policies and procedures; ensures the Institute stays current and complies with a complex set of University financial policies.
Assists in the preparation of necessary financial reports for the Zuckerman Instituteâ€™s Leadership to support decision making; organizes information for presentation materials, as required.
Other responsibilities as assigned by supervisor including special projects.
Serve as backup for other team members by collaborating on cross training.
Bachelor degree and/or its equivalent and a minimum of 2 yearsâ€™ related work experience required. Bachelorâ€™s degree in Accounting or Finance Preferred. Strong financial and analytical skills, including expertise in Excel, and advanced skills including Pivot Tables, V-LOOK UPS and SUMIF formulas; strong attention to detail. Must be adept at problem solving and using judgement in situations requiring initiative. Must be able to work in a fast - paced environment with shifting priorities, using positive relationship management and interpersonal skills to engage with the community. Not for Profit and grants experience a plus, especially in a higher education setting.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 515706
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.