OHIO University is seeking a qualified applicant for a Data Analyst within the University Planning & Space Management department.
Established in 1804, OHIO University is the oldest public institution of higher learning in the state of Ohio and the first in the Northwest Territory. Located in the scenic Appalachian foothills, its classic residential campus in Athens, Ohio, is one of the most attractive in the nation.
This position will assist with updating space, building and capital planning databases for accuracy and data integrity as well as assisting with usability and availability of data for campus planning and space utilization purposes. Coordinate with multiple campus and external constituents to submit reports related to capital planning, facilities, space, building and property data. Develop building space utilization analysis and space efficiency reports for office Planners/Programmer as required.
Space/Building Data Management:
a. Coordinate University building/space drawing (small scales) updates, review student work to ensure adherence to standards
i. Ensure that drawings are received from ADC and other entities in a timely manner.
b. Ensure that space data is extracted from small scale drawings and other documents, and space database is updated
c. Ensure all Real Estate transactions match University survey standards and are properly recorded in the University GIS system.
d. Coordinate with various departments across the institution to provide space / building data and track updates.
i. Registrar’s Office (Astra & PeopleSoft)
ii. Voinovich ( GIS )
iii. Facilities Management & Safety ( GIS )
iv. Budget Planning & Analysis
v. Space designates across campus
e. Update/verify space data (ongoing with projects/changes, plus annual survey)
f. Respond to various requests for reports and documentation concerning the functional use of facilities and space to assist the University in short and long term planning.
g. Periodic space / building on site reviews to validate availability of space.
h. Supervises student interns who assist with the development of small scales and field verification of space / building data.
Reporting: Includes independent reporting responsibilities, as well as coordination/ collaboration with other departments to ensure accurate and timely submission.
• Capital Plan: Quarterly executive reports, annual update planning and reports
• Space/Facilities/Land: State Reporting, National Science Foundation/Research, Space allocations for Budget process, Sustainability Reports, Board and University Facts, Ad hoc.
• Assists with coordinating Board of Trustees presentations and information.
Legal Property Descriptions and Easement Updates: Ensure archived Real Estate Data is properly digitized and recorded in the University GIS system. Coordinate to order new or updated surveys
Archive Function: Ensure that closeout drawings and real estate documents are properly organized and archived for University stakeholder access.
Capital Planning Database Updates
• Collect, validate and import project information from various departments on campus to update the Capital Planning Database:
• Annually for the Capital Improvement Plan
• Quarterly for transitioned projects
• As needed when project re-prioritization occurs
• Understand how all capital project systems function, the data each system holds and how the data from each system relate
Applicants must have the following:
1. Ability to utilize Excel and other database systems in order to:
a. Analyze, organize and combine large data sets from multiple systems
b. Distill complex data into a digestible format
c. Extract data from multiple systems
i. For space update process ( GIS , AutoCAD)
ii. For the purposes of reporting:
1. Capital Project (Executive Reports, etc.)
2. HEI (State of Ohio) Facilities/Space
3. Budget office
4. Academic/Research ( NSF , etc.)
5. Unit Planning and reports
2. Ability to document work flow, systems procedures and methodology used:
a. When tracking data through a process (as with space data derived from drawings)
b. When working with/combining large data sets, to meet reporting requirements or ad-hoc requests.
3. Ability to create comprehensive reports and to effectively communicate the results of the reporting (written and visual) in response to multiple inquiries from internal and external constituents seeking data,
4. Familiarity with and ability to understand planning process and capital projects (specifically the processes involved with planning and implementation and how these processes integrate).
5. Ability to understand how each system works, the data each system holds and how the data from one system relates to the other systems
a. And to build process improvements into a system, where possible.
6. Ability to work collaboratively to ensure the gathering and dissemination of information across multiple user groups.