TITLE Advancement Applications and Data Analyst
CLASSIFICATION NUMBER 1798
IMMEDIATE SUPERVISOR Director of Advancement Services
MAJOR ADMINISTRATOR Vice President for University Advancement
The Advancement Applications and Data Analyst is responsible for understanding the data in Banner, how Banner processes the data, and using that knowledge to produce custom reports and lists using Argos, Excel, Access, and SQL Developer and working with third party systems in the extraction and input of information. The Advancement Applications and Data Analyst maintains data integrity and manages the security of information under their oversight. The Advancement Applications and Data Analyst maintains servers and serves as liaison between Advancement Services and the third-party systems, Computer Services, Communication Services, and Financial Services regarding systems and data for all areas of University Advancement.
MINIMUM ACCEPTABLE QUALIFICATIONS
Education: A high school diploma or the equivalent and is required.
Experience: At least two years of experience using Argos, Structured Query Language (SQL), SQL Developer, Access, Excel, or similar languages and tools is required.
Skills: Effective verbal and written communication skills and effective interpersonal skills are required. The ability to work independently with minimal supervision and to follow through on projects and work assignments is required. Must be detail-oriented. The ability to manage multiple concurrent projects, reason analytically, and to work with people possessing different levels of technical knowledge is required. The ability to develop knowledge of, respect for, and skills to engage with those of other cultures or backgrounds is required.
ESSENTIAL DUTIES AND RESPONSIBILITIES
1. Maintains data integrity by managing data flowing into and out of the Banner system, designs, develops, and maintains views of commonly used data, and responds to requests for information.
2. Facilitates secure data transfers for phone campaigns, alumni online communities, postal services address returns and other recurring projects to ensure effective Advancement programming.
3. Ensures the integrity of modifications and enhancements to the system by assisting in the installation, configuration, and testing of application software.
4. Defines and develops reports and queries from various databases that will provide information as required by Development staff for the cultivation, solicitation, and stewardship of donors.
5. Ensures the operational integrity of the system by serving as the department's liaison with Computer Services and/or vendors on all application system issues, coordinating the installation of new software, coordinating the purchase and development of all custom interfaces, installing and documenting all system customizations, and assisting Computer Services with maintenance of interfaces to external systems.
6. Provides the first line of support to University Advancement staff, communicates with the help desk in Computer Services to assure prompt assistance, assesses desktop and equipment needs for staff in University Advancement, and assists with recommendations for replacement, purchases, etc.
7. Ensures system viability by identifying the information needs of the Office of Development and Alumni Relations, including Alumni Relations, Annual Funds, Athletics Development, Development, Donor Relations, Planned Giving, and University Advancement, researching available products, methodologies, and query tools, contacting other educational institutions and Computer Services for approaches to resolving information needs, assisting in the selection of products for hardware and software purchase by developing bid specifications, evaluating bid responses and recommending the selection of products that meet user needs and system compatibility requirements.
8. Facilitates coordination of effective support of the Office of Development and Alumni Relations computer system by developing and maintaining a cooperative working relationship with Computer Services, Communication Services, Postal Services, Human Resources, the Office of the Registrar, Financial Services, and other resources.
9. Remains competent and current through self-directed reading of professional journals, developing professional contacts with colleagues, attending professional development courses, and attending training and/or courses as directed by the Director of Advancement Services.
10. Safeguards the confidentiality of information and projects undertaken by Advancement Services and the Office of Development and Alumni Relations by exercising discretion in communicating information to faculty, staff, students and the public and in handling administrative records and files.
11. Contributes to a work environment that encourages knowledge of, respect for, and development of skills to engage with those of other cultures or backgrounds
12. Contributes to the overall success of the Advancement Services by performing all other essential duties as assigned.
The Advancement Applications and Data Analyst is supervised by the Director of Advancement Services.
OFFICE OF HUMAN RESOURCES
REVISED JANUARY 2017