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

2018-1056 ETL Developer (PA-II)

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

Website Central Services

Under supervision of the ETL 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 an enterprise data warehousing and decision support effort. The developed system will be the centerpiece of the campus reporting and analytics strategy, facilitating decision making at all levels. The incumbent works in collaboration with the KFS team, Accounting and Fiscal Services, Budget Office, Office of Institutional Research, Office of 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