Systems Specialist - Housing

University of Oklahoma•Norman, OK

20d•Onsite

About The Position

Reporting to the Systems Manager, the Systems Specialist is an advanced end user who is responsible for system upkeep and end-user customizations in StarRez, a proprietary, SQL-based, relational database housing management system. The Systems Specialist serves as a report writing specialist and is responsible for annual system setup and maintenance. Additionally, the Systems Specialist is responsible for the setup and maintenance of student-facing online portal processes.

Requirements

Bachelor's degree.
Will accept 48 months of related experience in lieu of the Bachelor's degree.

Nice To Haves

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

Responsibilities

Responsible for general system maintenance tasks required each semester such as updating billing rates, reports, dashboards and email templates.
Responsible for ad hoc updates of student profile and classification data, item statuses, etc. that cannot be automated.
Write, update, and format scheduled and ad hoc reports in StarRez for internal and external stakeholders using SQL.
Responsible for daily system maintenance and reporting (resolving duplicate records, coding issues).
Maintain user data and access control, modify security settings and groups as directed.
Setup, test, and maintain portal processes that are integrated with the student housing database software and ensure forms are optimized for student use.
Configure, test, and maintain database automation processes/workflows.
Manage data integration scheduled tasks, troubleshoot as needed.
Create and update training materials and present trainings for Housing and Residence Life staff.
Perform ad hoc bulk data imports; audit and maintain data integrity in StarRez.
Develop and maintain testing plans, process documentation, implementation and integration documentation in collaboration with housing staff.
Setup, 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 as they arise in a timely manner.
Position will be expected to work required overtime during peak periods of the year - in anticipation of application opening, assignments, move-in and move-out.
Position is considered essential and may be required to work during inclement weather or campus closures.