Database Administration & Business Intelligence is responsible for the design, development, maintenance, and overall architecture of institutional databases, data warehouses, and tools for business intelligence.

Key Responsibilities Include:

·        Participates in defining and communicating a strategic approach to databases and business intelligence with regards to the functionality for staff and faculty and the business needs of the institution.

·        Consults with users to clarify system intent, define specifications, identify problems, suggest changes, and determine the design of the systems necessary to support the need.

·        Manages the development of databases and business intelligence systems from specifications, considering factors such as database structure, computer storage capacity and speed, extent of peripheral equipment, and intended use of the data.

·        Designs and implements procedures to effect the extraction, manipulation, and reloading of data in order to build and maintain an enterprise data warehouse and/or departmental data marts for use with end-user reporting tools, online analytical processor (OLAP) tools, and data mining tools.

·        Establishes test and implementation plans in accordance with established standards and coordinates all phases of testing from unit test to end-user acceptance testing.

·        Analyzes test results to correct or direct correction of systems.

·        Establishes database backup/recovery procedures in association with the Information Technology Services department.

·        Establishes and maintains (in association with the Security team) a system for providing user access levels to allow only the appropriate users to retrieve data.

·        Revises or directs revision of existing systems to increase operating efficiency or adapt to new requirements.

·        Compiles documentation of system development and subsequent revisions.

·        Provides or oversees training and support to end users of the systems for which the position is responsible.

·        Prepares comprehensive project plans and project status reports for management.

·        Assigns, coordinates, and reviews work of department personnel.