EEO/Affirmative Action Statement: 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, sexual orientation, gender identity, national origin, disability, age, or protected veteran status. UC Santa Cruz is committed to excellence through diversity and strives to establish a climate that welcomes, celebrates, and promotes respect for the contributions of all students and employees.
Business Intelligence Data Analyst Planning and Budget
JOB #: 1908927
Full Time; Career Starting Salary Range: $7,5000.00 - $9,166.67/monthly. Salary commensurate with qualifications and experience.
UCSC strives to embrace diversity in all its forms; it strives to be an inclusive community that fosters an open, enlightened & productive environment.
Under the general supervision of the Director of Data Management, the Business Intelligence Data Analyst will have responsibilities in data solutions design, development, and implementation. These responsibilities will include schematic modeling, data integrations, and partnerships with campus constituents to meet their information needs. This position will also provide second-tier support for the approximately 1,200 InfoView users, which includes monitoring ticket queues, customer service, communications, and troubleshooting data related issues. Additionally, this position will also be expected to assist in the general operations management of the data warehouse application stack, including production support for batch processing, off-hours maintenance, and conducting verification/acceptance testing procedures.
The Office of Planning and Budget's Data Management team oversees and supports campus data warehouse services in partnership with Information Technology Services. For more than 20 years, the campus data warehouse has grown and matured in response to campus-wide reporting needs across 35+ subject-areas from 50+ data sources. Reports available through the reporting tool InfoView (SAP Business Objects), both standard and ad hoc, are widely used on campus for both daily operational information and longitudinal trend analysis. The topical areas of reporting are varied and include enterprise system reporting, such as financial operations, personnel, payroll, academic information, philanthropic donations, campus facilities, etc., as well as unit-specific operations such as dining point of sale, purchasing turn-time, equipment management, etc.
This position requires passing a pre-employment criminal history background check. Selected candidates cannot begin work until passing their background check. Please note: Time required to complete this process may vary and can be lengthy.
Bachelor's degree in related area and / or equivalent experience / training.
Experience preparing or writing reports for a wide range of audiences using an enterprise report writing tool (Business Objects, Crystal Reports, Cognos, Evisions Argos, Hyperion, Tableau, Looker, etc.).
Ability to understand vague or changing requirements and translate them into reports or graphs.
Ability to advise users on appropriate data or report writing practices to meet their self-service reporting needs.
Experience with one or more of the following tools:
Business Intelligence software: Business Objects
Design: experience building Business Object Universes
Languages: SQL, PL/SQL, Unix shell, and Python
Tools: TOAD, SQLPlus
Protocols: FTP, SFTP, PGP, key management
Operating Systems: Windows, Linux
Proficient in Unix directory management
Position is open until filled; Initial Review Date: 08-13-2019
To ensure review of application materials by the hiring unit, they must be submitted on or before the initial review date (IRD) via the Staff Employment Opportunities web site; https://jobs.ucsc.edu. A computer is available at the UC Santa Cruz Staff Human Resources Office located at Scotts Valley Center. The Scotts Valley Center is located at 100 Enterprise Way, Suite E100, Scotts Valley, CA 95066. To learn more or to request disability accommodations, call 831-459-2009. Hearing impaired are encouraged to use the California Relay Service at 800-735-2922. UC Santa Cruz is an Equal Opportunity Employer.
Qualifications / Competencies
Preferred Qualifications / Competencies
Special Conditions of Employment
Safety Duties All UCSC employees must know and follow job safety procedures, attend required health and safety training, proactively promote safety at work, and promptly report actual and potential accidents and injuries.