UC Merced
Left Button
BottomBottom Right
Center Image

Business Systems Analyst
Job Category:   Managerial/Professional
Unit:   Office of Institutional Planning & Analysis
Position Code:   SOIPA5098A
Status:   Filled
Closing Date:   This position is open until filled.
Salary:   $49,700-$97,900 Annual.
Location:   Merced
Background check:   Background check and fingerprinting may be required

The University of California, Merced is the newest campus of the ten-campus University of California system and the first American research university built in the 21st century. With close to 6,200 students, UC Merced has planned for additional student growth until we reach an enrollment of approximately 25,000 students. With undergraduate, graduate, and PhD programs, plans for a future medical school program, partnerships and community involvement, the UC Merced campus is continually evolving, requiring talented, knowledgeable and dynamic educators, researchers, management and staff.


The Business Systems Analyst III, as part of the Business Intelligence (BI) Team, will work collaboratively with business units and technical teams to gather reporting requirements, develop functional specifications, and facilitate adoption of BI applications and reporting tools (providing report development training, BI expertise, and user support). The Business Systems Analyst also will facilitate the development of the campus’data warehouse (DW), an integrated decision-support system (e.g., reporting, data marts, dimensional models, cubes, dashboards, scorecards), that uses BI and other programming tools.

This position also will provide support for the current data and reporting environment in the Office of Institutional Planning & Analysis (IPA), helping to transition to the new DW environment.

This position is open until filled with preference given to applications received by 02/28/2014.

Qualifications:   • Bachelor’s degree (master’s preferred) in information systems, computer science, or related field, plus minimum of three years of programming and/or SQL experience (multiple languages).

• Experience in higher education environment preferred.

• Minimum of five years of experience supporting the design and specification of data presentation and decision support systems with deep knowledge of reporting, analytics, and trending.

• Experience integrating data from multiple source systems.

• Knowledge and experience in data warehousing (ETL, ODS, Star Schemas, OLAP, Dimensional modeling, Balanced scorecards, etc.).

• Oracle or other relational database experience, as well as SQL/PLSQL.

• Experience with report building (preferably Cognos).

• Experience using DDL and DML, Oracle tools preferred.

• Business/systems analyst experience, including working with users to identify information systems and reporting needs, identifying potential solutions, designing, developing, documenting, testing and maintaining databases/applications.

• Ability to transform business need into a visual representation; ability to verify and reconcile data for accuracy and consistency.

• The Business Systems Analyst III must be able to communicate effectively, lead or facilitate meetings, identify potential solutions and take initiative, work independently as well as collaboratively within a team, and handle sensitive data professionally.

• Knowledge of federal and state laws regarding privacy of data highly desirable.

• Knowledge of higher education systems, especially Sungard-Banner preferred.

• Must be able to work on multiple projects concurrently and work within deadlines.
To Apply:   Click on the link below to use our new on-line application system.

If you do not have internet access you may mail your application, resume, and cover letter to: University of California, Merced, 5200 North Lake Rd., Merced CA 95343. Please list the job number on the subject line.

NOTICE: This position is not open. We are not accepting applications at this time.

    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.

For the complete University of California nondiscrimination and affirmative action policy see: http://policy.ucop.edu/doc/4000376/NondiscrimAffirmAct.

As of January 1, 2014 the University of California, Merced will be a smoke and tobacco free workplace. Information and the Smoke and Tobacco Free policy is available at

E-Verify: Effective September 8, 2009, all employers who receive Federal contracts and grants are required to comply with E-Verify, an Internet-based system operated by the Department of Homeland Security (DHS) in partnership with the Social Security Administration (SSA). E-Verify electronically verifies employment eligibility by comparing information provided on the I-9 form to records in the DHS and SSA databases. Certain positions funded by federal contracts/subcontracts requires UC Merced to notify job applicants that an E-Verify check will be conducted and the successful candidate must pass the E-Verify check.
More Information

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

Working at UC Merced
UC Systemwide Jobs
Log in to My Jobs
Hiring Manager

People Finder
Our Values
Contact Us