Financial Aid and Fellowships Analyst

• Job Type : Officer of Administration
• Regular / Temporary : Regular
• Hours Per Week : 35
• Salary Range : $72,000 to $82,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.

Position Summary

Columbia Engineering is committed to pushing the frontiers of knowledge and translating our discoveries to meet the needs of society.

These aspirations have been fundamental since our early origins. Over the years, our faculty and students have made remarkable contributions to technological and social progress, and today, we carry on our tradition of innovation as engineering transforms nearly every aspect of life, from the purity of the water we drink, the quality and accessibility of our healthcare, and the sustainability of the natural and built environments, to our ability to connect with others anywhere in the world.

The Columbia Engineering Finance team is looking for an organized and detail-oriented professional to assist the Senior Manager of Budget and Finance in streamlining the fellowship funding process for our graduate student population.

The incumbent will be responsible for developing operating procedures relevant to graduate aid in general and fellowships specifically.

The individual will utilize reporting tools to track and reconcile institutional and external financial aid awards and assist with managing the review and reconciliation of periods of enrollment details, outside scholarship payments, and other financial aid program awards

Responsibilities

40%) Maintain internal and external fellowship intake information from both academic departments and PhD students in order to accurately track the total funding package for graduate students and fellows.

Collects funding letters each term, and codifies the funding for each fellow and the necessary support from the School, department, and or PI.

Liaise with funding agencies to better understand the parameters for funding and document these processes for SEAS and the departments.

Works with internal departments to consolidate the list of fellows at the start of the year or at the start of each term as needed.

Process tuition, fees, and stipend funding for Dean's office fellows.

Collaborate with the academic departments as a subject matter expert on PhD fellowship funding. Assist with any questions regarding funding amounts and processes.

25%) Generate, analyze, and distribute financial aid / institutional funding reports as necessary, contributing to account reconciliation efforts.

Reconcile discrepant student balances against periods of enrollment and work with departments to resolve these accounts.

Ensure that financial aid is aligned with department allocations and charged to the relevant funding sources.

15%) Assists with updating the budgets for graduate and undergraduate student aid on a quarterly basis or as needed in the budget tool.

Review the department submissions for funding for various department sources to see if they align with past and current trends.

15%) Works to document and create effective standard operating procedures for our institutional aid funding materials. Works with supervisor and SEAS finance leadership to develop tracking templates and tools (spreadsheets / databases / funding guidelines) and a repository of information relevant to our funding process.

Provides training support to department staff on student funding guidance.

5%) Performs other tasks, duties, and responsibilities as assigned.

Minimum Qualifications

Bachelor's degree and / or equivalent work experience required.

2 years minimum experience required; excellent interpersonal and communication skills required.

Must be detail-oriented with excellent quantitative, and analytical computer skills.

Ability to work independently in a dynamic environment with changing priorities and multiple responsibilities required. Strong organizational, interpersonal, oral, and written skills required

A positive, forward-thinking, mission-oriented attitude and sense of humor is a must.

Equal Opportunity Employer / Disability / Veteran

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