Organizational Area: Institutional Research & Academic Planning
Location: Oakland, CA
Posting Salary: Salary commensurate with experience
Position Summary: The department of Institutional Research and Academic Planning (IRAP) is a central service unit of the Office of the President. IRAP provides timely, accurate, consistent and reliable information about UC and the environment in which it operates. Through evidence-based analyses, the department supports and guides enrollment planning, policy creation and revision, program and campus budget reviews, statewide higher education studies and UC operations. IRAP also produces the annual Accountability Report, which assesses UC's activities, achievements and operations through data-driven narratives and visualizations. To support these functions, IRAP in partnership with UCOP's Information Technology Services department is building a new UC Information Center Data Warehouse to replace UCOP's existing Corporate Data Warehouse. The public face of the UC Information Center is a Tableau-based public website with story boards, dashboards and interactive data tables. The incumbent is a key member of the IRAP-ITS team working to build this new data warehouse.
Under the general direction of IRAP Institutional and Academic Analytics Manager, the incumbent will support and help direct the development of the new UC Information Center Data Warehouse (ICDW). For assigned projects, incumbent will work with analysts within IRAP, throughout UCOP and the campuses. Incumbent will work to gather and document requirements for various components of the new data warehouse including incorporation of shadow systems into the new warehouse, serve as the primary interface with the IT team performing the work, lead the testing team and creating the relevant documentation. Incumbent applies advanced technical project practices and concepts while leading such projects. Requires an understanding of complex data warehousing issues where trade-offs between analyst's desires and technical realities are balanced appropriately.
The incumbent will work to specify and support development of a new data validation and testing framework to incorporate a number of data submissions, both from campus and data obtained from external providers, into the data warehouse. These data files are critical to IRAP's analyses. Data included here are complex longitudinal files for undergraduate students, graduate and professional students, faculty and staff. These longitudinal files are constructed from campus snapshot data submissions and incorporate a number of data feeds into a single analysis data set.
The incumbent will be responsible for modernizing the data submission, validation and loading processes for the more than 500 campus data files submitted to UCOP annually. The current system is a patchwork on legacy processes that have varying degrees of robustness. This will involve working with IRAP data analysts, ITS systems analysts and campus data providers to automate file processing, error checking and resolution.
Special Conditions of Employment:
Other Special Conditions of Employment:
Successful completion of a background check is required for appointment to this critical position.
Job Close Date:
Act as project manager for all requirements gathering activities, applying advanced business analysis concepts.
Ability to manage highly complex requirements activities to ensure a successful outcome within the identified project constraints.
Experienced in ensuring that IRAP's requirements are accurately identified, captured and tracked throughout the project lifecycle.
Able to define, organize and schedule requirements management activities in a way that is consistent with IRAP culture and standards.
Ability to execute planned requirements management activities while remaining flexible to changing requirements and project deadlines.
Responsible for the following databases: Student financial aid, Undergraduate longitudinal, Graduate longitudinal, Campus/ College/ Department/ Major/ Discipline reference table, Course, Alumni Employment Outcomes, National Student Clearinghouse, IPEDS, California Department of Education data files, among others.
Job Requirements Bachelor's degree in computer science, information technology or related area and/or 5 years of equivalent experience/training in a related field.
Advanced knowledge of business and process analysis functions that are relevant to migrating a legacy data warehouse.
Advanced knowledge of IT data warehouse modeling using star schema and other types of data models.
Knowledge of principles and procedures involved in handling sensitive student and employee data (for example, Family Educational Rights and Privacy Act, or FERPA and the California Information Practices Act, or IPA).
Advanced skills and methodologies associated with process and software design, implementation and modification especially for data validation and user acceptance testing processes.
Demonstrated experience developing processes and system implementation plans for data warehouse development projects.
Demonstrated experience with process analysis, systems analysis, process architectures and systems analysis methodologies and practices including SDLC (Software Development Life Cycle), Agile Unified Process (Agile, Scrum), e.g. Objected Oriented Methodologies, Joint Application Development among others.
Understanding and skill in complex process and systems requirement documentation standards, such as use case modeling, user story creations and narrative description.
Demonstrated ability to work with others from diverse backgrounds in a high pressure policy environment.
Self-motivated and works independently and as part of a team. Able to learn effectively and meet deadlines. Demonstrates problem-solving skills.
Experience with development case tools such as Toad for Data Analysis, SQL Developer, DB Visualizer, Golden and others.
Experience with Microsoft SharePoint, Microsoft Project, Microsoft Visio, Microsoft Office. Required
Advanced knowledge of business processes and procedures.
UC experience preferred, either at the systemwide level or at a UC campus. Preferred
About us The University of California, one of the largest and most acclaimed institutions of higher learning in the world, is dedicated to excellence in teaching, research and public service. The University of California Office of the President is the corporate headquarters to the ten campuses, five medical centers and three Department of Energy National Labs and enrolls premier students from California, the nation and the world.
The University of California is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, age or protected veteran status.
Copyright 2017 Jobelephant.com Inc. All rights reserved.
About University of California Office of the President
The Office of the President is the systemwide headquarters of the University of California, managing its fiscal and business operations and supporting the academic and research missions across its campuses, labs and medical centers.