Division Administrator

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: 104,000-114,000

Position Summary

Reporting to the Associate Director (AD) and is responsible for the day-to-day administration of a large, active research division. Serves as the primary liaison between the PIs and LDEO Administration, and coordinates with Climate School and Morningside administrative offices as needed. Supervises Administrative Coordinator and/or Administrative Assistant to accomplish the following duties and responsibilities.

Responsibilities

Financial Management:

• Responsible for developing and updating the division budget on an ongoing basis using best available information from PIs. Responsible for processing expenditure corrections & other adjustments when PIs identify inaccuracies in quarterly financial statements.
• 
  Budget Development: Develops Divisional fiscal year budget and submits to Finance Office according to the annual budget calendar. Works with PIs to determine anticipated expenditures for existing projects and to develop proxy budgets.
• 
  Budget Monitoring: Monitors financial activity in ARC monthly. Identifies errors and alerts PI. Provides updates to Finance Office at least quarterly to incorporate new information. Conducts a detailed review of anticipated year-end expenditures at the end of Q2 for a meeting with the Directorate. Monitors PI institutional projects in ARC monthly.
• 
  Salary Budgeting: Works with PIs to plan/identify/approve salary assignments and enter that data into PAC for approval and processing. Identify and notify AD of gaps in funding/bridge funding request and assist in finding solutions/moving these requests forward.
• 
  Audits: Works with PIs, Division AD, and Directorate on projects/expenses flagged for audit.

Sponsored Research (Administration and Finance)

• 
  Pre-award: Interprets proposal announcements, coordinates budget & proposal preparation, and
  works with Office of Research to submit proposals on time.
• 
  Post-award: Responsible for ensuring project compliance with University policies & sponsor
  terms and conditions. Monitors financial statements monthly. Designs/develops/maintains
  internal spreadsheets for tracking and monitoring of all Sponsored and non-Sponsored Research
  reports, including subawards. Works with SPF on project reconciliation, confirms annual
  expenses, and final sponsored project closeouts. Manages/tracks subaward invoicing. Serves as
  coordinator for annual effort reporting certification.
• 
  Project Management: Responsible for assigning salaries to projects and keeping payroll suspense at or near zero each month. Informs PIs and AD of administrative problems and/or conflicts.

Human Resources :

• Coordinates the annual performance review process within the Division. Works with HR,
  Division AD, and the Directorate on recruitment, promotion, retention, and termination. Advises
  AD and PIs on type of appointment, leaves of absence, and salary/grade level where required
  and aids in drafting memos/confirming funding sources.

Planning and Development:

• Advises AD on division planning. Works with the AD and others
  to support Division, Observatory, and University initiatives. Assists AD with the management of
  division discretionary accounts and other division resources. Organizes divisional
  meetings/gatherings.

Space Management:

• Coordinates capital projects with AD, Facilities and PIs. Coordinates
  maintenance of departmental office equipment and public rooms. Coordinates and completes the
  Columbia University Space Inventory. Maintains/plans office space for division members.

Supervises small (1 to 3) administrative support staff.

Performs other duties as assigned.

Minimum Qualifications

Bachelor's degree or equivalent experience required and three to five years' experience in financial
administration, budget preparation and management related to the performance of federal contracts and grants;
strong communication and interpersonal skills required. Advanced degree (MPA, MBA) preferred. Familiarity
with standard office software required; should have advanced proficiency in Microsoft Excel. High level of
confidentiality is essential.

Preferred Qualifications

• Type preferred qualifications

Other Requirements

• Type other requirements and/or special indicators if CUIMC

Equal Opportunity Employer / Disability / Veteran

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