Assistant Director, Admissions Systems

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Salary Range: Commensurate with Experience

Position Summary

Reporting to the Director of Admissions and Financial Aid at the Graduate School of Architecture, Planning and Preservation (GSAPP), the Assistant Director of Admissions Systems maintains and updates digital platforms and databases serving the Admissions Office of the school with approximately 750 students and 3,500 applicants. The position ensures data integrity across the school and university systems and digital platforms, establishes and maintains consistency in data management, oversees data migration, tracks changes and updates to records, provides regular reconciliation and analytical reports and updates related to online platforms and website pages as needed.

Responsibilities

Admissions Cycle (45%)

• Takes lead on Program updates to the online admissions application form, and test and troubleshoot application system
• Programs event registrations and other submission forms in the admissions system
• Assists with application processing as needed
• Prepares access to admissions applications to appropriate faculty members for review
• Closes degree program applications and prepare/update application forms for next cycle
• Tracks and reports on application activity throughout and post cycle, including preliminary data analysis
• Codes and generates regular queries and reports on applications, admissions, enrollment, and yield, including comparative reports/analysis of current against past admissions cycle
• Tracks and reports on Financial Aid disbursements

Website and digital platform updates (30%)

• Program or implement system and website updates including academic calendar dates, admissions and deadlines, prospective and admitted student pages, appointment forms, among others
• Content updates and maintenance of additional platforms such as Google Groups or similar tools and digital resources and guides for prospective, admitted, and enrolled students
• Manages online info sessions for prospective students
• Programs content updates for automatic system email communications for prospective and admitted students

Reconciliation of data across School and University systems (15%)

• Exports admitted applications from Slate to SIS (CU mainframe)
• Manages data migration, test and troubleshoot data feeds for SIS
• Matches applications to existing records
• Imports PID & UNI information to applicant records from SIS to Slate
• Tracks and reports on admissions declines, leave of absence, withdrawals, and deferral requests and make adjustments to enrollment records across platforms
• Imports graduation lists and dates to Slate, match with applicant records, and update status
• Consolidates records including correcting student records (updating SSN, names, etc.)
• Prepares and provides Associate Deans with regular reconciliation and analytical reports on enrolled students, financial aid disbursements, and others as needed.  This includes interpreting financial statements and university produced reports to facilitate the resolution of error
• Prepares and distributes routine and non-routine financial reports and analyses using university-wide reporting tools

Enrollment Cycle (5%)

• Processes enrollment deposit refunds and reporting on deposit returns (including special students)
• Promise to Register enrolled students in SIS
• Ensures automated communications are sent to incoming deferral students
• Completes PCI training and maintain annual PCI compliance
• Generates regular enrollment reports

Perform additional duties as assigned (5%)

Minimum Qualifications

Bachelor’s degree or equivalent and/or its equivalent.  3-5 years of related experience required.  Must have excellent interpersonal and organizational skills and be able to work with a highly diverse, international student body.  Must possess mature judgement and have the ability to handle confidential and/or sensitive issues with tact and discretion.  Required computer skills include knowledge of desktop publishing, web design, Slate database management and SQL, and Microsoft Office, Excel and Adobe Creative Suite. 

Preferred Qualifications

Preferred Skills:

Experience in an academic setting.  Some background in architecture/design or a related field is desirable. 

Prior experience with Slate and advanced Excel.

Equal Opportunity Employer / Disability / Veteran

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