1798 Advancement Applications and Data Analyst

POSITION IDENTIFICATION

TITLE Advancement Applications and Data Analyst

CLASSIFICATION NUMBER 1798

GRADE 33

CLASSIFICATION Nonexempt

IMMEDIATE SUPERVISOR Director of Advancement Services

MAJOR ADMINISTRATOR Vice President for University Advancement

GENERAL FUNCTION

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.


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 the overall success of the Advancement Services by performing all other essential duties as assigned.

SUPERVISION

The System Administrator is supervised by the Director of Advancement Services.

OFFICE OF HUMAN RESOURCES

REVISED MARCH 2016

JOB FAMILY 3

Factor 1: Educational/Experience Requirements of the Job

Level 5 - 985 Points: A combination of education and experience equivalent to a Level 5 as indicated by the Equivalencies Chart, when permitted by the Minimum Acceptable Qualifications.

Factor 2: Supervisory Responsibility

Level 1 - 299 Points: Little or no supervisory responsibility for the work of others.

Factor 3: Skill, Complexity, and Technical Mastery

Level 5 - 1600 Points: Knowledge of information technology methods and procedures applicable to several types of work processes. Knowledge permits the employee to carry out work assignments where the objectives are clearly identified and can be accomplished by adapting precedents and established practices.

Factor 4: Budgetary Control

Level 3 - 579 Points: Jobs at this level are responsible for identifying areas of need and for developing proposals that request funding to fulfill those needs.

Factor 5: Work Environment and Physical Demands

Level 1 - 25 Points: The work environment has only everyday discomforts associated with an office or commercial vehicle. The work area is adequately lighted, heated or cooled, and ventilated. Work is largely sedentary involving mostly sitting with occasional walking, standing, bending, or carrying of small items. No special physical demands are required of the work.

Factor 6: Work Impact and Effect

Level 3 - 2340 Points: Work products or services directly impact the operation, accuracy, reliability, acceptability, or design of programs, systems, or equipment, that affect the operation of individual departments or units. The work activity may be complex, but normally involves addressing conventional problems or situations with established methods that allow departments, programs, or units to function properly. Improperly performed work and/or equipment or software failures likely produce significant errors and/or create delays that directly affect the ability of a department, program, or unit to function properly, and the welfare of faculty, students, or others that use the services and/or products of the department, program, or unit. While the scope of improperly performed work and/or equipment or software failure is limited, the nature of the activity may require that emergency repairs be performed.