Systems Specialist - Housing

UNIVERSITY OF OKLAHOM; Norman (OK); On-site; USD 37,000 - 45,000; Full time

Job summary

UNIVERSITY OF OKLAHOMER? in Norman, OK seeks a Systems Specialist to manage StarRez, write SQL reports, and maintain housing data. The role supports annual setup and student portal processes, reporting, and system maintenance.

Requires a Bachelor's degree or 48 months of related experience. Strong data analysis, SQL reporting, and experience with housing software are expected. Overtime may be required during peak periods.

Qualifications

• Bachelor's degree or 48 months of related experience in lieu of degree.
• Department prefers data analysis and script writing.
• Experience with housing assignment software such as StarRez or Roompact.
• Experience with application development is a plus.

Responsibilities

• Write, update, and format scheduled and ad hoc reports in StarRez using SQL.
• Perform general system maintenance and update records and templates.
• Configure and maintain portal processes integrated with housing software.
• Coordinate with IT and vendors to troubleshoot system issues promptly.
• Create training materials and lead trainings for Housing staff.
• Conduct bulk data imports and maintain data integrity.

Skills

SQL reporting

Data analysis

System maintenance

Education

Bachelor's degree

48 months related experience in lieu of Bachelor's degree

Tools

StarRez

SQL

Roompact

Job description

Pay Range: Targeted Salary: $41,000 annually, based on experience

Benefits Eligible: Yes

Work Schedule: Monday - Friday, 8:00 a.m. to 5:00 p.m. (may include some weekends); Position is considered essential and may be required to work during inclement weather or campus closures.

Travel: May be required

Position Introduction

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.

Duties include but are not limited to:

• 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.

View full job description

Required Education and Experience

• Bachelor's degree.

Equivalency/Substitution

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

Department Preferences

• Bachelor's degree in MIS, Computer Science, or related field OR an equivalent combination of education/job-related work experience.
• Department preference for 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.

Hiring Contingent Upon a Background Check

Yes