Associate Director - Cost Analysis (Hybrid Schedule)
Location: New York, New York
Internal Number: 541934
Job Type: Officer of Administration
Hours Per Week: 35
Salary Range: $125,000 - $145,000
The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.
The Research Policy & Indirect Cost Group (RPIC) is responsible for overseeing compliance with university policies and Federal regulations that govern the post-award financial administration of sponsored programs. In the last fiscal year, Columbia University generated over $300M million in indirect cost revenues and nearly $1 billion in sponsored research; continued growth is anticipated. Reporting to the Senior Director, Research Policy & Indirect Cost, the Associate Director, Cost Analysis serves a critical role in all aspects of the development and subsequent government audit of indirect cost rates, fringe benefit rates, and other special rate studies and analyses, (e.g., cost-sharing, department research).
The Associate Director, Cost Analysis is responsible for understanding and incorporating all the appropriate federal rules and regulations concerning the charging and recovery of indirect costs (Facilities & Administrative - F&A), and other compliance requirements established by Sponsors.
The incumbent helps develop and implement analytical methodologies and metrics to ensure the highest level of compliance with Federal and other donor requirements.
The incumbent is extensively involved in the critical tasks associated with the Indirect Cost proposal, preparation, and submissions to the federal government including responsibility for associated studies, analyses, and reviews in support of the proposal.
Specific duties include, but are not limited to:
System Software Implementation and Ongoing Maintenance:
Assist in the implementation of two external software systems that will be used in the development of the optimal proposed indirect cost rates ??? Maxiumus??? WebSpace and CRIS.
Post-system implementation, will include responsibility for the overall operation and maintenance of software, ensuring data is updated as necessary; using reporting functionalities to provide space and usage data as needed; and working with Maximus on system enhancements, fixes, and updates as required.
Indirect Cost Proposal:
Includes but is not limited to major functions associated with conducting and/or reviewing space studies, space tours, and equipment inventories; review of various departmental financial data; creation of various financial and attribute tables; FTE studies; Utility analyses; Interest analyses; Library studies; projections, and various cost share studies. Includes collaboration with various university departments and related organizations.
Works closely with Facilities to manage space data requirements for space study and other space-related allocations. Collects and forwards all required space changes that are identified during the space study phase of the proposal.
Assists in training and communications to Departmental Administrators for performing the University???s Space Survey; provides guidance on using the system to functionalize research space; reviews the adequacy of the University???s space functionalization data which is the basis for allocating building and equipment depreciation and O&M costs to research.
Assists with responses to audit requests related to the Department of Health and Human Services (DHHS) on audits of F&A proposals, DS -2, and Fringe Benefits proposals including providing supporting documentation, working with various departments when necessary to obtain supporting documentation for audit requests in the amount of time stipulated by the auditors; and performing follow-up actions with administrative officials and/or auditors as needed.
Maintains intricate and detailed indirect cost stepdown spreadsheet models supporting the University???s indirect cost allocations; Reconciles data to university financial statements and details how the facilities and administrative costs were allocated to each of the respective cost pools, the basis for submission of the F&A rate.
Reviews and functionalizes ARC accounts to ensure MTDC base accuracy; works with various departments across the University to appropriately classify expenses for allocation purposes.
Performs account and cost grouping analyses in accordance with Federal guidelines.
Advises the Senior Director of potential non-compliance issues in accordance with the CAS requirements.
Buildings and Equipment:
Equipment located in the research space is an integral piece of the F&A proposal. Works closely with Managers/Capital Assets on bi-annual equipment inventory and fixed equipment.
Maintains the University???s building componentization and depreciation database for the indirect cost study and financial statements reporting.
Works directly with external Consultants in gathering required data for inclusion in the indirect cost model.
Analysis & Reporting:
Runs, modifies, creates, utilizes, and maintains numerous databases, queries, and reports in support of all costing functions and sponsored project operations.
Includes modifications to design of financial models and tools including detailed analysis of results and reconciliation to the Columbia University financial statements.
Manages the preparation and submission of the Schedule of Expenditures of Federal Awards (SEFA) for the annual Uniform Guidance Audit;
Maintains and updates standard reports required for the HERD survey, reporting to entities such as US News and World Report, The Times Higher Education, and additional submissions; supervises the development of customized reports.
Guides university departments in the development of service center rates.
Conducts service activity rate calculation reviews which include:
Learning the operations of the various departmental service activity funds across campus, Providing assistance and guidance to departments,
Writing queries and preparing related costing reports and calculations,
Detailed analysis of rate calculations for reasonableness, accuracy,
Adherence to Federal and University policies.
Performs other duties as assigned.
Candidates must possess a Bachelor's degree, with five years of professional work experience requiring the utilization of accounting and financial skills in a complex business, academic, higher education, or government environment.
Degree in Accounting; advanced degree desirable
Demonstrated knowledge of sponsored projects/research administration/grants management and accounting business processes.
Expert technical skills for extensive use of Microsoft Office and other systems; experience with Peoplesoft or other financial and administrative applications required.
Must be comfortable working with large data sets, databases, and computerized financial systems.
Ability to document clearly and concisely procedures and processes related to the costing functions.
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 organizational, analytical, critical thinking, interpersonal, written, and oral communication skills.
Strong analytical and problem-solving skills.
Ability to work independently and to exercise good judgment and discretion in the Performance of all work assignments while maintaining compliance with Federal and University policies.
Ability to work in an integrated team environment.
Highly developed and effective verbal and written communication skills.
Strong interpersonal skills that reflect courtesy, diplomacy, and a collaborative approach to developing and maintaining effective work relationships.
Ability to counsel and train individuals and departments.
In addition, the successful candidate must work well with all levels of employees, be flexible, and have sound judgment with an open and collaborative style that encourages teamwork and cooperation beyond the immediate team to the broader organization.
Must have a passion for excellent customer service and commitment to exceptional quality.
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.