1647 Business Intelligence & Application Analyst

 

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

JOB FAMILY 3

Factor 1: Educational/Experience Requirements of the Job

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

Factor 2: Supervisory Responsibility

Level 2.0 - 598 Points: Irregular but occasional responsibility to direct the work of student workers and/or temporary or part-time workers. At this level are jobs in which the incumbent may be asked to supervise small numbers of student workers, graduate assistants, or part-time employees, but the supervisory work is irregular or infrequent. The nature of supervision is largely confined to assigning tasks to others and does not include a full range of supervisory responsibilities.

Factor 3: Skill, Complexity, and Technical Mastery

Level 7.0 - 2200 Points: Professional knowledge of the principles, concepts, and specialized complicated techniques of a profession. Knowledge of a wide range of information technology methods and procedures and specialized knowledge in one or more specific functions. Knowledge permits the incumbent to provide authoritative advice on difficult assignments such as planning advanced systems. Skill in applying knowledge through analyzing, designing, organizing, and developing major programs, systems, and networks.

Factor 4: Budgetary Control

Level 2.0 - 386 Points: Individuals in jobs at this level actively document, monitor, and control expenditures. At this level incumbents may recommend minor expenditures but have no real authority over budgets.

Factor 5: Work Environment and Physical Demands

Level 1.0 - 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 4.0 - 3060 Points: Work products or services directly impact the work of other professionals, the development and operation of programs, affect major activities across units, and/or impact the well-being of large numbers of individuals. Typically the work is complex and may involve addressing conventional problems or situations with established methods or resolving critical problems or developing new processes or models to address specific problems. Improperly performed work and/or equipment or software failures produce errors and delays that affect the operations and/or reputations of multiple or critical departments, programs, or units, and individuals. Improperly performed work and/or equipment or software failures may be remedied in the short to medium term, but at substantial cost of time and resources. The scope of improperly performed work and/or equipment or software failure is large and the nature of the activity requires that emergency repairs be performed.