POSITION IDENTIFICATION
TITLE Business Intelligence & Application Analyst
CLASSIFICATION NUMBER 1647
GRADE 34
CLASSIFICATION Exempt
IMMEDIATE SUPERVISOR Director of Data and Technology – University Advancement
GENERAL FUNCTION
The Business Intelligence and Application Analyst is responsible for understanding University Advancement’s multiple systems, database entity relationships, and how data is entered and integrates within internal and external systems. This position is responsible for understanding UA’s processes and procedures, maintains data integrity, and is responsible for technical support involving software implementation and maintenance on various platforms, application program planning, organizing, documenting, report writing, data engineering, data visualization and maintenance of business applications including technical support to internal UA staff.
MINIMUM ACCEPTABLE QUALIFICATIONS
Education: A Bachelor's degree in a related field is required. A Master’s degree is preferred. An equivalent combination of years of experience and education may be considered for substitution of educational requirements.
Experience: At least 3 years of experience managing a software application system and providing best practice for its use, programming, designing and/or developing integrations between systems. Experience with use of Power BI Preferred. Skills: Effective verbal and written communication skills and effective interpersonal skills are required. The ability to identify complex problems and review related information to develop and evaluate options and implement solutions. 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 understanding, securing, and managing data flowing into and out of University Advancement’s multiple software systems. Designs, develops, and documents University Advancement’s integration and use of software systems for optimization and accurate information extraction.2. Ensures data integrity managing modifications and enhancements to the system and assisting in the installation, configuration, and testing of application software. Ensure data standardization and data integrity by creating procedural documentation, process flows and training end users on systems under the responsibility of University Advancement.
3. Facilitates coordination of effective support of University Advancement applications by understanding integrations, possessing cross-functional ERP knowledge, and maintaining a cooperative relationship with Computer Services, Communication Services, Human Resources, the Office of the Registrar, Financial Services, Office of Financial Aid, and other resources.
4. Ensures business intelligence integrity and system viability by identifying University Advancement’s information needs, researching available products, methodologies, software, and cloud solutions, assisting in analyzing new solutions or services, evaluating bid responses, and recommending selection of products that meet user needs and effective system and business intelligence compatibility requirements.
5. Continually analyzes and provides suggestions for improvement of University Advancement processes and procedures improving or maintaining operational efficiency within existing software solutions. Employs project implementation methodology to enhance system usability, upgrades/enhancements, data corrections and process improvements.
6. Ensures data standardization by developing and adhering to data entry guidelines and helping users understand appropriate data input. Assist others in the division in understanding data entry for accurate information output in reports and dashboards.
7. Defines and develops reports and business intelligence platforms from various datasets to provide data-based decision-making to University Advancement and its units.
8. Ensures operational and data integrity of the system by being the frontline of defense in troubleshooting issues with the system, then serves as one of the department’s liaisons with Computer Services and/or vendors on application system issues for additional support, as needed.
9. Safeguards the confidentiality of data, information, and projects by understanding and developing security controls and assisting in granting or removing access to the systems and data under the responsibility of the division.
10. 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 Supervisor.
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 office by performing all other essential duties as assigned.
SUPERVISION: Irregular but occasional responsibility to direct the work of student workers and/or temporary or part-time workers.
OFFICE OF HUMAN RESOURCES
AUSUST 2024
