Requisition Number: 03024790 Final Filing Date: 09-23-2019 Closing Date: Payroll Title: APPLICATIONS PROGR 3 Number of Positions: 1 Salary: budgeted salary is $5,066.67/Mo. - $6,250.00/Mo. commensurate with experience ($5,066.67-$10,175) 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 Allow Applicants to Attach: Resume Cover Letter References
Job Summary: Under the general supervision of the Director of Business Intelligence (BI), work as part of the Advancement Services team supporting fund raising at UC Davis. Work with product owners, business analysts, and business unit stakeholders to turn business functionality requests in the form of user stories into technical deliverables that meet the requirements of the project. Serve on the delivery team within Advancement Services to coordinate and oversee that the products and services provided meet the quality and deadline objectives using the Agile SCRUM methodology. As part of the BI delivery team, help lead efforts to support Advancement Services products including (Advance Web, iModules, Reeher, Michelangelo, Online giving system etc.). Participate in determining how newly acquired data should be stored in the database to best meet user needs and be consistent with existing data. Analyze institutional business needs, system resources, and end user needs to improve existing data management processes. Independently specify, test, and debug user interfaces and SQL queries and programming code. Develop and enforce data standards. Consult with product owners and other delivery team members to devise and implement the technology solutions that meet the objectives for the user story/use case. As needed, develop implementation plans and conduct project management activities. Analyze processes, create documentation, and develop and oversee the training for internal and external use. Make recommendations for programmatic data correction, including data downloading, analyzing, programmatic correction, and uploading into an enterprise scale database environment for improving and enforcing data standards. Provide analysis and development across a variety of platforms, including data mapping. Provide general system administration, installation, file management and perform data update transfers using available tools.
Physical Demands: Work in close quarters.
Sit and work in front of a personal computer for extended periods of time.
Work Environment: Work occasional evenings and weekends.
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: Experience in understanding complex technical and conceptual information, identifying key issues and details, and presenting understandable alternatives to both technical and non-technical users orally and in writing.
Professional programming experience using Structured Query Language (SQL) - Oracle Procedural Language (PL/SQL) and JAVA.
Business experience with an understanding of operational and customer requirements within an institution of significant complexity and breadth.
Analytical, problem-solving and management skills to independently research, develop, and recommend solutions to complex problems and issues.
Experience with web page design and web content management systems.
Experience with documenting processes and procedures.
Experience with data transfer between systems, ETLs.
Skills to develop report specifications from customer requirements and develop reports that represent the data.
Knowledge of Microsoft Office Products.
Organizational skills to determine priorities, delegate responsibilities, exercise independent judgment and make appropriate decisions.
Interpersonal, verbal and written communication skills to interact effectively and diplomatically with management, peer institutions, software vendors, donors, customers, students, staff and/or university administrators.
Experience in evaluating system design specifications and prototypes, and recommend effective data maintenance and update mechanisms and functions.
Experience with large complex database structures.
Skills in statistical and data analysis to sample and test existing databases, determine error rates, establish minimum quality standards, and summarize and effectively present information.
Experience in tracing, isolating, debugging, and solving problems affecting donor databases, and related systems such as for telemarketing.
Knowledge of client/server applications and relational databases.
Preferred Qualifications: Experience in supporting and managing a fundraising database, preferably Advance or Raiser's Edge.
Experience supporting not-for-profit or fund raising environment such as annual fund and/or a membership program.
Experience with Advance Web, iModules, Reeher, Michelangelo and/or Advance Windows.
Experience with designing APIs to facilitate inter-machine communication.
Experience working on as part of an Agile, SCRUM or KANBAN team.
Ability to work in a positive, fast paced, agile development environment.
Helpdesk Management experience. Experience in developing SLAs and managing a Helpdesk tracking database such as Track IT!
Experience in training and/or developing a comprehensive training program.
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.