Job Description

Under the general direction of the Assistant Director of Housing Services, provide a broad range of administrative, analytical, and operational functions in support of the Database department. Major duties include analysis of data, importing data, data cleanup, data validation, testing web applications and reporting errors. Prepare training manuals for the Housing Services database management and end users. Troubleshooting and resolving end-user issues. Prepare analytical reports and graphs using Crystal Reports, SSRS and other ad hoc reporting tools as directed by Senior Management. Perform data entry tasks during peak periods and in the absence of the Data Entry Assistant. Act as first level technical support for Housing Services for troubleshooting technical issues and contact the correct support. Assist two database managers with tasks. Create, maintain, audit, and reconcile analytical reports generated from Housing Services databases using various ad-hoc reporting tools (Active Reports, SSRS, Crystal Reports, etc.). Assist Senior Management with the usage and application of databases, and resolution of database inquiries. Cross train and assist in other Housing Services areas during peak or vacation periods including assisting with customer service on telephones, email, and in person.

The target salary range for this position is between the posted minimum and $26.82 hourly.

Job Qualifications

General knowledge of data processing (principles and terminology) and the ability to work with hardware and software vendors.
Required

General knowledge of database structure including relational databases and data types, primary key to function key relationships.
Required

Skill in typing with speed and accuracy.
Required

Operate a 10-key by touch with speed and accuracy.
Required

Experience writing SQL queries in SQL Management Studio.
Required

Experience developing reports using an ad hoc reporting to including Active Reports, SSRS, Crystal Reports.
Required

Skill in analyzing information, situations and procedures to define problems and formulate conclusions.
Required

Demonstrated working knowledge in customer service
Required

Organizational skills to manage workflow and establish a harmonious and productive environment.
Required

Skill in analyzing operating procedures and recommending necessary changes consistent with accepted accounting and departmental business practices.
Required

Working knowledge of Microsoft Office (Including Word, Excel, and Access).
Required

Skill in speaking concisely and logically, using grammatically correct language to convey information and explain policies and procedures.
Required

The ability to work overtime
Required

Ability to establish and maintain cooperative working relationships with staff, coworkers, and other University personnel and interact diplomatically with a diversified public.
Required

Skill in analyzing information, situations and procedures to define problems and formulate conclusions.
Required

Experience in writing routine business correspondence, operating procedures, performance evaluations and presentation materials using grammatically correct language.
Required

Demonstrated working knowledge in financial management, as well as computerized billing and receivable systems.
Preferred

Experience with Business Objects Business Views and Universes.
Preferred

Experience with StarRez Housing Management System
Preferred

Experience with Delphi Multi-Property Catering System
Preferred

Experience with Opera Property Management System
Preferred

Working knowledge of basic accounting and collections practices and principles. Working knowledge of internal cash handling and controls.
Preferred

Ability to write and understand SQL queries.
Preferred