For the latest information regarding technology support for the Coronavirus situation, please visit UCI TechPrep.

2016-1325 Business Intelligence/Data Warehouse Specialist (PA III)

  • Contract to Career
  • Irvine, CA
  • This position has been filled

Website Central Services

Under general supervision of the Data Warehouse manager, the incumbent serves as a member of the OIT Business Intelligence and Data Warehouse team, and participates in the design, development, deployment, documentation, ongoing maintenance and support of a significant enterprise data warehousing and decision support effort, focused on the campus’ HR/Payroll system (UCPath). The developed system will be the centerpiece of the campus reporting and analytics strategy, facilitating decision making at all levels. The incumbent works in close collaboration with the UCPath team, Human Resources, Accounting and Fiscal Services, Office of Institutional Research, and other campus offices.

This data warehouse effort incorporates operational and transactional data from a variety of sources to provide operational data stores and dimensionally modeled data repositories, in support of ad-hoc analysis, reporting, displaying of key performance indicators (KPIs), projections and what-if modeling at the campus, school and departmental levels.

Duties include documenting functional and technical requirements; developing, extending and maintaining dimensional database schemas; developing, implementing and maintaining extract-transform-load (ETL) processes, and ensuring that security and data integrity standards are met for all developed content.






External Recruitment: Open to current UCI employees and the general public.

Hiring Salary

Commensurate with experience

DOE, plus benefits

Scroll Up