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.The University of California, Irvine is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy.Salary: Commensurate with experienceTotal Hours: 8-5, M-FContract Position. This is a one year contract appointment position with the possibility of additional year contract appointment extensions. Per the University of California (UC) recruitment policy, because this position has undergone competitive recruitment, this position can be converted to career status any time after hire, as conversion meets criteria set by UC recruitment policy and the needs of the Office of Information Technology department. Final candidate subject to background check.As a federal contractor, UC Irvine is required to use E-Verify to confirm the work status of individuals assigned to perform substantial work under certain federal contracts/subcontracts. Please attach your resume.Click here to see the Information Technology website.View Job Description for the position requirements.
Since 1965, the University of California, Irvine has combined the strengths of a major research university with the bounty of an incomparable Southern California location. UCI's unyielding commitment to rigorous academics, cutting-edge research, and leadership and character development makes the campus a driving force for innovation and discovery that serves our local, national and global communities.