Assistant Director, Grants and Administration

• Job Type: Officer of Administration
• Regular/Temporary: Regular
• Hours Per Week: 35
• Salary Range: $85,000 - $100,000

Position Summary

Reporting to the Director of Administration and Finance (DAF), the Assistant Director plays a central role in supporting the Columbia Astrophysics Laboratory (CAL) through comprehensive grants and financial administration. Working closely with faculty, staff, and central administrative offices, the Assistant Director ensures smooth and compliant proposal management and assists with the administration and operations of CAL's wide portfolio of astrophysics research grants. This role is ideal for an individual with strong organizational and communication skills who thrives in a fast-paced, team-based academic setting and is committed to supporting cutting-edge research in astrophysics.

This position is critical for ensuring the timely and accurate submission of grant proposals, maintaining compliance with institutional and sponsor requirements, and supporting principal investigators in advancing CAL's world-class research. The incumbent oversees a broad portfolio of pre-award activities-including proposal development, budget preparation, submission coordination-and post-award activities, including compliance monitoring, financial reporting, and award lifecycle management. Additionally, the incumbent assists with the coordination of related grant-funded appointments that are essential to research operations. These include onboarding and payroll for postdoctoral researchers and staff, recruitment coordination, and visa support.

The Columbia Astrophysics Laboratory is a thriving hub for world-class astrophysics research and a vital link between the Physics and Astronomy Departments. CAL functions as a collaborative research space and an administrative center supporting large-scale experimental projects while easing operational burdens for researchers. CAL's success rests on focusing on diverse research areas, including gravitational waves, dark matter, cosmic structure formation, galaxy and black hole evolution, star formation, gas and element distribution, exoplanet and habitability studies, and astrochemistry.

Responsibilities

Pre-Award Activities

• Provide Principal Investigators (PIs) with pre-award financial administration support.
• Serve as a liaison between the PIs and the Sponsored Projects Administration (SPA). Initiate in SPA's internal review system, RASCAL, as well as through the submission portals of various agencies.
• Proactively research, identify, and communicate funding opportunities to Principal Investigators to support ongoing and future research initiatives.
• Provide support and review for PIs during the development and finalization of proposal budgets, current and pending support forms, and other submission materials.
• Review notices of award, agreements, contracts, and MOUs to ensure they align with the proposal scope, mission, and university policies.

Post-Award Activities

• Oversee aspects of the award lifecycle, including project setup, budget monitoring, progress reporting, no-cost extensions, carryovers, and closeouts.
• Maintain accurate financial data in university systems (e.g., FinSys) for newly awarded projects and ongoing accounts.
• Review and coordinate subcontract agreements and amendments in collaboration with Columbia's sub-award team.
• Partner with Sponsored Projects Finance (SPF) in the preparation and submission of sponsor financial reports in compliance with institutional and sponsor requirements.
• Maintain records in accordance with internal procedures, demonstrating compliance with sponsor and sponsor agreements, and University regulations concerning project expenditures, equipment, and other fiscal concerns.
• Perform calculations for salary distributions and post-award management. Process and approve payroll accounting transactions as needed. Partner with A&S HR on clearing suspense as needed.
• Perform and update monthly budgeting, projecting, and reconciling of lab finances.

Grant Funded Appointments & Financial Operations

• Assist DAF with quarterly and annual departmental budget submissions and revisions.
• Assist DAF in identifying opportunities to streamline and improve processes, providing input for automating processes, and actively implementing changes, as needed.
• 
  Serve as backup to the DAF for purchasing, accounts payable, expense reviews, and approvals, including travel reimbursements, check requests, purchase orders, requisitions, service agreements, subcontracts, and P-Card transactions.
• Process financial transactions (ITFs, journal vouchers, payroll changes/allocations, etc.).
• Serve as the primary point of contact with ISSO on visa matters.
• Provide additional support to faculty and staff with appointments, maintaining accuracy and confidentiality in all processes.
• Prepare reports and process financial transactions, P-Card activity, and budget entries, to support the Director of Administration and Finance.
• Manage highly sensitive and confidential data with discretion. Prepare ad hoc reports for the DAF.

Minimum Qualifications

• 
  

  Bachelor's Degree or equivalent, and a minimum of 3 years of related experience.

  
  

Preferred Qualifications

• Demonstrated background in research administration, with a focus on STEM-related projects and compliance requirements.
• Understanding of federal research compliance requirements (e.g., Uniform Guidance, NSF, NASA).
• Working knowledge of Columbia's proprietary systems (ARC, PAC, FinSys, RASCAL, etc.)
• Experience in higher education or non-profit.

Other Requirements

• Excellent written, verbal, and interpersonal communication skills.
• Ability to maintain high confidentiality and professionalism with a client focus.
• Working knowledge of enterprise Financial and Human Resources Information Systems, Microsoft Office, and relational databases.
• Strong multi-tasking, prioritization, and organization skills.
• Attention to detail, research, critical thinking, analytical, and problem-solving skills.
• Self-starter, a fast learner who can work independently under limited supervision.
• Ability to navigate and work well in an interactive team environment.

Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.