Job Number 1707007


Administrator, Data Warehouse



This position is past the Close Date, no more applications will be accepted.
Position Information
Location Highland Business Center
Hours 40 hours/week as assigned; Generally Monday-Friday 8 am - 5 pm
Salary Professional 4/124 ($51,137.00 - $73,053.00)
FLSA Status Exempt
Reports To Vice President, Effectiveness and Accountability
Criminal Background Check
General Statement of Job

To administer, develop, implement, and maintain the Office of Institutional Research and Analytics (OIRA) data warehouse system.

Description of Duties and Tasks
Essential duties and responsibilities include the following. Other duties may be assigned.

  1. Responsible for SAS system configuration and maintenance.
  2. Develops and maintains data marts, data cubes, queries, and reports.
  3. 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.
  4. Installs, deploys, and upgrades data warehouse systems applications; maintains documentation, and performs routine systems administration maintenance activities.
  5. Allocates system storage and planning storage requirements for the database and file storage systems.
  6. Develops data models and data maps for data warehouse systems.
  7. Develops processes and applications for migration/transformation of data from collegewide systems to the data warehouse system.
  8. Provides assistance to end users and programmers regarding data warehouse-related problems and issues.
  9. Initiates processes and documentation of OIRA data warehousing system; develops procedures to ensure security and integrity of data including data encryption.
  10. Manages end-user accounts and accessibility; provides technical expertise to end-users who create complex queries and reports.
  11. Coordinates, schedules, and tests upgrades to the data warehouse system.
  12. Researches and evaluates software, system upgrades and enhancements, and provides technical recommendations.
  13. Keeps current with the latest technology; regularly attends technical training in order to maintain technical expertise.
  14. Performs database administration and maintenance including database backups, performance monitoring and tuning.

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.

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.

Technology Skills

Required Work Experience

Preferred Work Experience

Required Education

Preferred Education

Special Requirements
Licenses/Certifications; Other

Physical Requirements

Safety

Information for This Posting Only

ACC Benefits Overview

Disclaimer

The above description is an overview of the job. It is not intended to be an all-inclusive list of duties and responsibilities of the job, nor is it intended to be an all-inclusive list of the skills and abilities required to do the job. Duties and responsibilities may change with business needs. ACC reserves the right to add, change, amend, or delete portions of this job description at any time, with or without notice. Employees may be required to perform other duties as requested, directed, or assigned. In addition, reasonable accommodations may be made by ACC as its discretion to enable individuals with disabilities to perform the essential functions.

Austin Community College provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.

As required by the US Department of Education, employees are required to report violations under the Title IX and, under the Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act (Clery Act), select individuals are required to report crimes. If this position is identified as a Campus Security Authority (Clery Act), you will be notified, trained, and provided resources for reporting.