• University of California Office of the President
  • Oakland, CA, USA
Full Time Information Technology

Job Description



Location: Oakland


Job ID: 18187


Job Posting


For UCOP internal applicants, please login to the internal candidate gateway at:




At the University of California (UC), your contributions make a difference. A world leader producing Nobel and Pulitzer prize recipients with over 150 years of groundbreaking research transforming the world. Choose a career where you can leverage your knowledge, skills and aspirations to inspire and support some of the greatest minds in the world, and those who will follow in their footsteps. Working at the University of California is being part of a unique institution, and a vibrant and diverse community. At the University of California, Office of the President, we propel our mission through impactful work locally, in government centers and systemwide. We are passionate people, serving the greater good.


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 headquarters to the 10 campuses, six academic medical centers and three national laboratories and enrolls premier students from California, the nation and the world.




UC is a leader in advocating for the purpose and importance of public higher education. By providing timely, accurate, consistent, and reliable information about UC and the environment in which it operates, Institutional Research and Academic Planning (IRAP) illustrates UC's progress, challenges and outcomes in support of its mission.




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. The Business Systems Analyst reports to the Director of Data Infrastructure, Management and Reporting and supports the work of the Data Management team. The Director is responsible for the technical delivery of multiple robust and dynamic reporting and analytics environments as well as the development and maintenance of data transformation rules and file submission and processing for the UC Data Warehouse (UCDW).


Under the direction of the Director, the incumbent will support the development of technical solutions. For assigned projects, the incumbent will work with analysts within IRAP, throughout UCOP and the campuses to gather and document requirements for various technical solutions and will frequently serve as the primary interface with the technical team performing the work, lead testing and training and create relevant documentation. The incumbent will apply advanced technical project practices and concepts while leading such projects, which requires an understanding of complex data warehousing issues where trade-offs between the 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 of 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.






Initiates, designs or modifies highly complex systems and procedures where standardized policies or procedures may or may not exist. Creates highly technical specifications for systems with broad impact at OP. Develops unit integration and acceptance testing plans and scenarios. May lead cross-functional teams to address complex business or systems issues.




Initiates, facilitates, implements and documents work process changes. Prepares and approves or obtains approval for business process and procedural documentation. Initiates and oversees changes in processes and procedures. Sets the technical requirements for complex specifications.




Applies advanced business analysis concepts to identify, evaluate and define highly complex systems scope and objectives based on advanced knowledge of applicable business practices, processes and systems and industry standards to meet end-user needs. Works at the highest technical level of various phases of systems analysis. Considers the business implications of applying technology to the current and future business environment.




Performs highly complex analysis of business and user needs, documentation of requirements and translation into proper system and process requirement specifications. Provides advanced support and training on new applications. Mentors experienced Business Systems Analysts and may lead a team of business analyst professionals.


Required Qualifications


  • Advanced knowledge of business and process analysis functions.
  • Advanced knowledge of related areas of IT.
  • Knowledge relating to the design of processes and software across the organization.
  • Advanced skills and methodologies associated with process and software design, modification and implementation.
  • Demonstrated skills needed to develop process and system implementation plans.
  • Demonstrated experience with process analysis, systems analysis, process architectures and systems analysis methodologies and practices including traditional waterfall, Agile, Agile Scrum, UML, UML Enterprise, et cetera.
  • 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.
  • Self-motivated and works independently and as part of a team. Able to learn effectively and meet deadlines. Demonstrates problem solving skills.
  • Advanced knowledge of business processes and procedures.
  • Demonstrated testing and test planning skills.
  • Demonstrated effective communication and interpersonal skills. Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization. Interpersonal and communications skills to work with both technical and non-technical personnel at various levels in the organization.




  • Bachelor's degree in related area and / or equivalent experience / training.




  • Must pass a background check.




Salary: $105,600 - $145,000 commensurate with experience.


Benefits: For information on the comprehensive benefits package offered by the University visit:






Please be prepared to attach a cover letter and resume with your application.




The first review date for this job is May 27, 2021. The position will be open until filled.




Background Check Process: Successful completion of a background check is required for this critical position.


Smoke Free Work Environment: The University of California, Office of the President, is smoke & tobacco-free as of January 1, 2014.




The University of California, Office of the President, is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age or protected veteran status.


The University of California, Office of the President, strives to make this job board accessible to any and all users. If you have comments regarding the accessibility of our website or need assistance completing the application process, please contact us at: or email the Human Resource Department at:


To apply, visit




Copyright ©2017 Inc. All rights reserved.

Education Requirements

Bachelor's Degree