Business Intelligence Specialist, Prospect Management and Analytics

Benefits

Additional Information

APPLICATION INSTRUCTIONS: CURRENT PENN STATE EMPLOYEE (faculty, staff, technical service, or student), please login to Workday to complete the internal application process . Please do not apply here, apply internally through Workday. CURRENT PENN STATE STUDENT (not employed previously at the university) and seeking employment with Penn State, please login to Workday to complete the student application process. Please do not apply here, apply internally through Workday. If you are NOT a current employee or student, please click "Apply" and complete the application process for external applicants . 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 . 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 to a customer focused, collaborative, mission-driven environment. 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 MINIMUM EDUCATION, WORK EXPERIENCE & REQUIRED CERTIFICATIONS Bachelor's Degree 1+ years of relevant experience; or an equivalent combination of education and experience accepted Required Certifications: None BACKGROUND CHECKS/CLEARANCES Employment with the University will require successful completion of background check(s) in accordance with University policies. Penn State does not sponsor or take over sponsorship of a staff employment Visa. Applicants must be authorized to work in the U.S. SALARY & BENEFITS The salary range for this position, including all possible grades, is $68,200.00 - $102,300.00. Salary Structure - Information on Penn State's salary structure 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. For more detailed information, please visit our Benefits Page . CAMPUS SECURITY CRIME STATISTICS Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act and the Pennsylvania Act of 1988, Penn State publishes a combined Annual Security and Annual Fire Safety Report (ASR). The ASR includes crime statistics and institutional policies concerning campus security, such as those concerning alcohol and drug use, crime prevention, the reporting of crimes, sexual assault, and other matters. The ASR is available for review here . EEO IS THE LAW Penn State is an equal opportunity employer