Requisition Number: 03024789 Final Filing Date: 09-23-2019 Closing Date: Payroll Title: DATA SYS ANL 3 Number of Positions: 1 Salary: budgeted salary is $5,683.33/Mo. - $6,250.00/Mo. commensurate w/experience ($5,683.33-$11,408.33) Appointment Type: Career Appointment Description: Full-time, Working Hours Monday-Friday between 8 a.m.-5 p.m. Overtime Eligible (FLSA): Exempt Union/HEERA Representation: This position is not represented by a collective bargaining unit
Department: DEVELOPMENT: ADV SERVICES - 061025 Department Description: Advancement Services manages centralized Gift Acceptance and Processing and Advance System Support to departmental staff campus-wide. Services provided includes, client programming support from Advance, data/information management, data analysis, system auditing and compliance, formulation and implementation of gift policies, acceptance and processing of gifts, and user documentation and training. Processing unit is critical to the strategic initiatives of the campus as it is utilized by campus departments and by UCOP in performing complex financial analyses and predictive modeling. Advancement Services is the office of record for the alumni and donors of the University of California, Davis.
Location: Davis/Sacramento(TES) Allow Applicants to Attach: Resume Cover Letter References
Job Summary: Under general supervision, work as part of the Advancement Services team supporting fund raising at the UC Davis.
Improve data integrity by analyzing database and developing validations and audits to improve overall data quality.
Provide input on how newly acquired data should be stored in the database to best meet user needs and be consistent with existing data. Co-ordinate the distribution of update tasks to staff in other departments; help identify suitable work, staff selection, and staff training. Analyze institutional business needs, system resources, and end user needs to improve existing data entry and input processes. Independently specify, test, and debug user interfaces and SQL queries and programming code. Develop and enforce data standards. Consult with clients and recommend acquisition of new technology solutions to improve or automate existing processes; coordinate and prioritize client requests; delegate staff resources; create implementation plans and conduct project management activities. Communicate Records Management policy and procedure changes to end users as necessary. Analyze processes, create documentation, and collaborate with training staff in the development of end-user training materials.
Serve as part of a team of decision makers who analyze database functionality, coding, and practices for continual improvement. Supervise programmatic data correction, including data downloading, analyzing, programmatic correction, and uploading into an enterprise scale database environment for improving and enforcing data standards. Provide overall database analysis and development across a variety of platforms. Provide general system administration, installation, file management and data transfers.
Physical Demands: Work in close quarters.
Sit and work in front of a personal computer for extended periods of time.
Work Environment: UC Davis is a smoke and tobacco free campus effective January 1, 2014. Smoking, the use of smokeless tobacco products, and the use of unregulated nicotine products (e-cigarettes) will be strictly prohibited on any UC Davis owned or leased property, indoors and outdoors, including parking lots and residential space.
Background Check Required: Yes
Minimum Qualifications: Extensive database experience in a large-scale database environment maintaining data quality.
Experience analyzing database, developing validations and audits to improve data quality.
Experience analyzing business needs, system resources, and end user needs to improve existing data entry and input processes.
Experience analyzing database functionality, coding, and practices for continual improvement.
Experience developing and enforcing data standards.
Skills in client interaction through written and verbal communication.
Experience working with confidential records.
Independent problem solving skills.
Preferred Qualifications: Experience managing small to midsize projects.
Working knowledge of SQL.
Experience working within a database environment, including work with interface development and query languages.
Experience developing, testing and debugging site specific applications.
Experience with Advance Web or Advance Windows.
Experience in not-for-profit or fund-raising environment.
Experience with large complex database structures.
The University of California 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.
Copyright 2017 Jobelephant.com Inc. All rights reserved.
UC Davis is the home of the Aggies — go-getters, change makers and problem solvers who make their mark at one of the top public universities in the United States. Since we first opened in 1908, we’ve been known for standout academics, sustainability and Aggie Pride as well as valuing the Northern California lifestyle. These themes are woven into our 100-plus-year history and our reputation for solving problems related to food, health, the environment and society.Our 5,300-acre campus is in the city of Davis, a vibrant college town of about 68,000 located in Yolo County. The state capital is 20 minutes away, and world-class destinations such as the San Francisco Bay Area, Lake Tahoe and the Napa Valley are within a two-hour drive.