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