Business Intelligence Specialist
Penn State UniversityAbout the role
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 Office of Physical Plant (OPP) at Penn State is seeking a Business Intelligence Specialist to lead and advance business intelligence systems that inform strategic decision-making and operational excellence across one of the University’s largest and most complex organizations.
Reporting to the Director of Strategic Programs, this position partners closely with leaders across OPP (including the Director of Operational Technology) to design, implement, and sustain a comprehensive business intelligence framework that leverages data to improve performance, resource allocation, and service delivery.
As a member of the OPP team, the successful candidate will embody Penn State’s commitment to diversity, equity, inclusion, and sustainability, and actively contribute to fostering an inclusive workplace where all employees thrive.
The location of this position is hybrid and can operate in a hybrid model of both in-person and remote. Standard working hours are in the Eastern Time Zone. Candidates must be able to work in the US without sponsorship.
Key Responsibilities
Lead the design, development, and maintenance of business intelligence (BI) systems, dashboards, and performance metrics to support OPP’s strategic and operational goals.
Collaborate with internal stakeholders to identify key performance indicators (KPIs) and data requirements aligned with OPP’s mission, strategic plan, and University initiatives.
Integrate and maintain data connections to OPP and University enterprise systems, including Maximo, Trimble Unity Construct, LionSpace FIS, and Workday.
Develop and maintain data models, reporting frameworks, and visualization tools using Microsoft Power BI, Microsoft Fabric, SQL, and Smartsheet.
Conduct statistical analysis, forecasting, and scenario modeling to support budget planning, operational optimization, and long-term capital planning.
Design and publish standard and ad hoc reports for leadership and key stakeholders across Finance & Business and the Commonwealth Campuses.
Develop and document business process maps, ensuring data integrity and consistency across systems.
Administer Sm
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s