Job Description - Administrator, Data Warehouse
Description View created on 07/22/2014

Administrator, Data Warehouse

FLSA Status: Exempt
Pay Grade: 24
Job Title ID: 14055
Job Series/Job Family: Effectiveness & Accountability Series / Institutional Research & Effectiveness Family

Reports To

Vice President, Effectiveness and Accountability

Job Purpose

To administer, develop, implement, and maintain the Office of Institutional Effectiveness and Accountability (OIEA) data warehouse system.

Description of Duties and Tasks

Essential duties and responsibilities include the following. Other duties may be assigned.

  1. Coordinates with IT database administrators, systems administrators, and OIEA staff regarding data warehouse development, migration of data through manual or ETL processes, revision and update of data marts and cubes, procedure development, troubleshooting, system configuration, security administration, and account setup.
  2. Installs, deploys and upgrades data warehouse systems applications; maintains documentation, and performs routine systems administration maintenance activities.
  3. Develops data models and data maps for data warehouse system.
  4. Develops processes and applications for migration/transformation of data from College-wide systems to the data warehouse system.
  5. Develops and maintains data marts, data cubes, queries, and reports.
  6. Provides assistance to end users and programmers regarding data warehouse related problems and issues.
  7. Initiates processes and documentation of OIEA data warehousing system; develops procedures to ensure security and integrity of data.
  8. Manages end-user accounts and accessibility; provides technical expertise to end-users who create complex queries and reports.
  9. Coordinates, schedules, and tests upgrades to the data warehouse system.
  10. Researches and evaluates software, system upgrades and enhancements, and provides technical recommendations.
  11. Keeps current with the latest technology; regularly attends technical training in order to maintain technical expertise.

Knowledge

Must possess required knowledge and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.

Required

Skills

Must possess required skills and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.

Required

Computer Skills

Required

Physical Requirements

Work Experience

Required

Preferred

Education

Required

Other

Required

Safety