Systems Specialist - Housing

Reporting to the Systems Manager, the Systems Specialist is an advanced end user responsible for system upkeep, end-user customizations, and report writing in StarRez, a proprietary SQL-based relational database housing management system. This role includes annual system setup, maintenance, and managing student-facing online portal processes.

Responsibilities

• Perform general system maintenance tasks each semester, such as updating billing rates, reports, dashboards, and email templates.
• Update student profile and classification data, item statuses, and other ad hoc changes that cannot be automated.
• Write, update, and format scheduled and ad hoc reports in StarRez for internal and external stakeholders using SQL.
• Conduct daily system maintenance and reporting, resolving duplicate records and coding issues.
• Maintain user data and access control, modifying security settings and groups as directed.
• Set up, test, and maintain portal processes integrated with the student housing database software, ensuring forms are optimized for student use.
• Configure, test, and maintain database automation processes and workflows.
• Manage data integration scheduled tasks and troubleshoot as needed.
• Create and update training materials and present trainings for Housing and Residence Life staff.
• Perform ad hoc bulk data imports and audit and maintain data integrity in StarRez.
• Develop and maintain testing plans, process documentation, and implementation and integration documentation in collaboration with housing staff.
• Set up, test, and implement new software or additional functionality of current software systems.
• Coordinate with OU IT and software vendors to troubleshoot and correct system issues in a timely manner.
• Work required overtime during peak periods, including application openings, assignments, move-in, and move-out.
• Serve as an essential position, potentially required to work during inclement weather or campus closures.

Requirements

• Bachelor’s degree.
• Equivalency/Substitution: 48 months of related experience in lieu of the Bachelor’s degree.

Qualifications

• Bachelor’s degree in MIS, Computer Science, or related field OR an equivalent combination of education and job-related work experience.
• 36 months of data analysis and script writing experience.
• Previous professional experience with housing assignment software and working knowledge of Roompact or similar tools.
• Previous professional experience in application development.

Pay

Targeted salary: $41,000 annually, based on experience.

Schedule

Monday – Friday, 8:00 a.m. to 5:00 p.m. (may include some weekends). Position is considered essential and may require work during inclement weather or campus closures.

Benefits

Benefits eligible: Yes.