Business Intelligence Specialist, Prospect Management and Analytics

Position Specifics

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.

The Office of Prospect Management and Analytics empowers gift officers and DDAR leadership with timely, accurate insights that support effective fundraising, prospect strategy, and engagement efforts. Through thoughtful analytics and research, the office contributes to the successful achievement of DDAR’s philanthropic and engagement goals.

Reporting within Prospect Management and Analytics, the Business Intelligence Specialist will serve as a skilled analytical contributor, partnering with advancement leadership, development officers, prospect management staff, and colleagues across DDAR. This role is well‑suited for a professional with demonstrated data visualization and consultative analytical skills in a customer‑focused, collaborative, mission‑driven environment.

Approval of remote and hybrid work is not guaranteed regardless of work location. For additional information on remote work at Penn State, see Notice to Out of State Applicants.

• 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.
• Assist 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.
• Provide support and training to 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.

• Bachelor’s Degree.
• 1+ years of relevant experience; or an equivalent combination of education and experience accepted.
• No required certifications.

Employment with the University will require successful completion of background check(s) in accordance with University policies.

Salary range: $68,200.00 – $.

Benefits include comprehensive medical, dental, and vision coverage, robust retirement plans, paid time off (holidays, vacation, sick time), and a generous 75% tuition discount for employees, spouses, and children. For more detailed information, please visit the Benefits Page.

Penn State is an equal opportunity employer and is committed to providing employment opportunities to all qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. If you are unable to use our online application process due to an impairment or disability, please contact 814‑865‑1473.

Penn State is committed to and accountable for advancing equity, respect, and belonging. We embrace individual uniqueness, as well as a culture of belonging that supports equity initiatives, leverages the educational and institutional benefits of inclusion in society, and provides opportunities for engagement intended to help all members of the community thrive. We value belonging as a core strength and an essential element of the university’s teaching, research, and service mission.