Business Intelligence Specialist, Prospect Management and Analytics

About the role

The Division of Development and Alumni Relations (DDAR) is seeking a Business Intelligence Specialist (Intermediate Professional) to support analytics, reporting, and data-informed decision making within the Office of Prospect Management and Analytics.

Responsibilities

• Support the development and delivery of reports, dashboards, and analyses that inform fundraising performance, prospect pipeline activity, portfolio management, and donor engagement.
• Access and analyze data from University and DDAR systems to answer business questions, identify trends, and support tactical and operational decision making.
• Design, build, and maintain user-friendly dashboards and recurring reports using established business intelligence tools and standards.
• Aid in the development and documentation of key performance indicators (KPIs) and metrics aligned with DDAR goals and reporting needs.
• Write, test, and optimize scripts and data extracts to ensure accurate and reliable reporting in BI technologies.
• Collaborate with cross-functional stakeholders on analytical projects, data validation, and continuous improvement of reporting processes.
• Translate analytical outputs into clear, compelling data visualizations for non-technical audiences, with guidance from strategic partners as appropriate.
• Support and train end users on business intelligence tools, dashboards, and data literacy.
• Contribute to data quality, documentation, and standardization efforts to improve consistency and usability of advancement data.
• Stay informed about business intelligence and analytics tools in use at the University and apply best practices within the scope of the role.

Requirements

• Exemplary interpersonal and communication skills.
• The ability to create and maintain an inclusive and respectful environment for all students and colleagues.
• A proven ability to self-motivate and work both independently and as part of a team.
• A commitment to professional development, learning, and being mentored.

Qualifications

• Bachelor's Degree
• 1+ years of relevant experience; or an equivalent combination of education and experience accepted
• Required Certifications: None

Skills

• Data visualization and consultative analytical skills.
• Ability to work in a customer-focused, collaborative, mission-driven environment.

Benefits

Penn State provides a competitive benefits package for full-time employees designed to support both personal and professional well-being. In addition to comprehensive medical, dental, and vision coverage, employees enjoy robust retirement plans and substantial paid time off which includes holidays, vacation and sick time. One of the standout benefits is the generous 75% tuition discount, available to employees as well as eligible spouses and children.

Pay

The salary range for this position, including all possible grades, is $72,300.00 - $108,444.00.

Schedule

This position is based at the University Park campus, located in State College, Pennsylvania.