Scheduling Analyst-Hybrid Schedule

Job Type: Officer of Administration Bargaining Unit: Regular/Temporary: Regular End Date if Temporary: Hours Per Week: 35 Standard Work Schedule: full-time Building: Salary Range: $78,000-$83,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 Reporting to the Assistant Registrar, Class Scheduling, the Scheduling Analyst serves as chief support and back-up for the Assistant Registrar, Class Scheduling for room scheduling related activities for Columbia University. The incumbent acts as a resource to management regarding room utilization reports, analysis, policies and procedures. Working closely with the Assistant Registrar for Classroom Scheduling, this position is responsible for supporting classroom policies and procedures and supporting the continued operation, development and upgrade of the scheduling software (EMS), including all technical requirements, updates, feed adjustments, and error resolution. This position functions as a key liaison, service provider, and subject matter expert to academic departments and users of EMS across campus. Responsibilities Responsible for the daily maintenance, development and upgrade of EMS, including developing scheduling procedures to maximize effective space utilization; leading continuing efforts to improve scheduling and calendaring applications; maintaining the front- and back-ends of EMS software which require a working knowledge of SQL in order to trouble-shoot technical issues. Works closely with University Events Management (UEM) team on maintenance and performance of the EMS database and its connections to Course Management. Provide guidance, service and act as a subject matter expert to academic departments and users of EMS across campus. Performs maintenance of the scheduling software application including configuring the application to change room features and assignment codes; assign and maintain user privileges; create new menu options; develop and update table configurations and procedures and forms. Ensures that integration with other systems is functioning properly; identifies potential problems and troubleshoots, working closely with UEM and CUIT staff. Is responsible for making sure that Registrar classrooms and their attributes are synced and available in all systems and posted to the Registrar website. Serves as chief support and back-up for the Associate Registrar for room scheduling related activities for Columbia University. The Scheduling Analyst is responsible for collecting, answering, and referring phone and e-mail inquiries when the Assistant Registrar is out of the office. The incumbent acts as a liaison to college departments, faculty, and divisions regarding room utilization reports, analysis, policies and procedures. The Scheduling Analyst is responsible for documenting room scheduling procedures and policies on an on-going basis. Under the guidance of the Assistant Registrar for Classroom Scheduling, this position interacts with departments and other school contacts on matters of classroom space, departmental space priorities, and ad hoc classroom requests. Other administrative support items include handling confidential phone calls and messages, and interacting with various University departments and offices, as well as with individuals outside the University. The incumbent oversees the creation and classroom placement of recitations and discussion sections in the scheduling system and assists with the creation of the final exam schedule. Is responsible for supporting the future development and continued operation of our classroom policies and procedures. This position is responsible for developing training manuals for the use of scheduling software and conducts training and support for campus staff. May supervise work-study students as needed. Handle project assignments and performs other related duties as assigned. Minimum Qualifications Bachelor's degree or equivalent, plus a minimum of three years related experience required. Preferred Qualifications Experience with Student Information Systems (SIS) a plus. Background in academic administration or previous experience in a registrar's office is desirable. Experience with scheduling software desired. Other Requirements Proficiency with Excel and SQL required. Excellent data management and data analysis skills required. Computer literacy required. Keen professional communication skills required. Excellent written, organizational, communication, and interpersonal skills required. Must have strong problem-solving skills. Must be self-motivated, detail-oriented, and possess patience, tact, and an ability to function effectively with a broad constituency. Proven ability to work independently, and work under tight deadlines required. Ability to be creative and comfortable with computer databases required. Equal Opportunity Employer / Disability / Veteran Columbia University is committed to the hiring of qualified local residents.