APPLICATIONS PROGR 3 (Applications Programmer 3)

Development & Alumni Relations (DEVAR) provides leadership in building enduring public trust, understanding, and support for UC Davis and its mission of teaching, research, and public service. DEVAR provides leadership, coordination and support services to help the university meet its mission of research, teaching and service by building philanthropic support and executing approved fundraising programs that support the university’s highest priorities and initiatives.

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.

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, Anthology, 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.

Position Information

PHYSICAL DEMANDS

• Mental Demands: Analytical and Problem Solving - Constantly , Confidentiality - Constantly, Constant Interruptions - Frequently, Customer Contact - Frequently , Detailed Work - constantly , Language - Frequently , Math - Frequently, Multiple Concurrent Tasks - Frequently, Reading (documents or instruments) - Frequently, Reasoning - Frequently, Training - occasionally, Verbal Communication - Frequently , Written Communication - Frequently
• Physical Demands: Attendance - Occasionally, Sitting - Frequently , Speaking - frequently , Talk or Hear - Frequently
• Lifting Requirements: Up to 10 Pounds (Sedentary) - Occasionally
• Visual Acuity Requirements: Close Visual Acuity (e.g., viewing a computer screen; using measurement devices) – constantly
• Noise Conditions: Quiet Noise Conditions - Occasionally , Very Quiet Conditions - Occasionally , Moderate Noise Conditions - Occasionally , Ability to Adjust Focus - Frequently

WORK ENVIRONMENT

·       Remote work with occasional in-person meeting attendance.

·       In-person work required during onboarding period.

·       Work occasional evenings.

·       The Smoke and Tobacco Free Environment policy is intended to provide a healthier, safer, and more productive work and learning environment for the entire UC community. The University of California prohibits smoking and tobacco use at all University owned or leased properties, or facilities operated by UC staff or faculty. Smoking and tobacco use are strictly prohibited in indoor and outdoor spaces, parking lots, residential space, and University vehicles. https://ucdavispolicy.ellucid.com/documents/view/271

MINIMUM QUALIFICATIONS

Minimum Education/Experience:

·       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) or C#.

·       Business experience with an understanding of operational and customer requirements within an institution of significant complexity and breadth.

·       Experience with documenting processes and procedures. Skills to develop report specifications from customer requirements and develop reports that represent the data.

Minimum Knowledge, Skills, and Abilities (KSA):

·       Analytical, problem-solving and management skills to independently research, develop, and recommend solutions to complex problems and issues.

·       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.

PREFERRED QUALIFICATIONS

Preferred Education/Experience:   

·       Helpdesk Management experience. Experience in developing SLAs and managing a Helpdesk tracking database such as ServiceNow Experience in training and/or developing a comprehensive training program.

·       Experience supporting not-for-profit or fundraising environment such as annual fund and/or a membership program. Experience with fundraising software, such as Advance or Raiser’s Edge. Experience working on as part of an Agile, SCRUM or KANBAN team.

Preferred Knowledge, Skills, and Abilities (KSA):

·       Awareness, knowledge, and skill in applying diversity, equity, and inclusion to one’s work. A profound belief in the value of a diverse and safe workforce and a commitment to achieve this goal through collaboration and team building, working cooperatively with a diverse group of department and campus constituencies.

SPECIAL REQUIREMENTS

Background Check

This position is a critical position and subject to a background check. Employment is contingent upon successful completion of background investigation including criminal history and identity checks.

Diversity, Equity, Inclusion and Belonging

At UC Davis, we’re solving life’s most urgent challenges to bring a fuller, healthier, and more resilient world within reach. We grow from every challenge we take on and we don’t just maintain - we improve. We recognize that creating an inclusive and intellectually vibrant organization means understanding and valuing both our individual differences and our common ground. The most comprehensive solutions come from the most diverse minds, and you belong here. As you consider joining UC Davis, please explore our Principles of Community , our Clinical Strategic Plan  and strategic vision  for research and education, and our latest efforts to outgrow the expected . The University of California, Davis 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.

For the University of California’s Affirmative Action Policy please visit:  https://policy.ucop.edu/doc/4010393/PPSM-20.    

For the University of California’s Anti-Discrimination Policy, please visit: https://policy.ucop.edu/doc/1001004/Anti-Discrimination .