Penn State University · 1 month ago
Business Intelligence Specialist
Penn State University Park
Full-time
Hybrid
Mid, Senior Level
$86K/yr - $130K/yr
6+ years expPenn State University is seeking a Business Intelligence Specialist to lead and advance business intelligence systems that inform strategic decision-making and operational excellence. The role involves designing, implementing, and sustaining a comprehensive business intelligence framework to improve performance, resource allocation, and service delivery across the Office of Physical Plant (OPP).
Higher Education
No H1B
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 Smartsheet access, coordinate functionality enhancements, and serve as liaison between OPP users and system administrators
Research and implement emerging technologies—including AI-driven analytics, Power Automate, and Power Apps—to streamline workflows and improve insight delivery
Provide training, consultation, and technical guidance to users and managers to strengthen data literacy and BI adoption across OPP
Participate in continuous improvement and change management initiatives supporting OPP’s 'Cutting the Red Tape' and 'Optimized Service Teams' (OST) initiatives
Qualification
Required
Master's Degree
6+ years of relevant experience; or an equivalent combination of education and experience accepted
Demonstrated proficiency in Power BI, Microsoft Fabric, SQL Developer, Excel, and Smartsheet
Experience integrating multiple enterprise systems and developing cross-platform data solutions
Strong analytical, communication, and problem-solving skills, with the ability to translate data into actionable insights
Proven ability to work independently, manage multiple priorities, and engage collaboratively with diverse teams
Preferred
Experience in higher education or large-scale facilities management environments
Six or more years of progressively responsible experience in business intelligence, project management, data analytics, or enterprise data management preferred
Familiarity with Power Automate, Power Apps, and AI-based business process automation
Advanced data visualization and storytelling skills that support executive-level decision-making
Benefits
Comprehensive medical, dental, and vision coverage
Robust retirement plans
Substantial paid time off which includes holidays, vacation and sick time
Generous 75% tuition discount, available to employees as well as eligible spouses and children
Company
Penn State University
There’s a reason Penn State consistently ranks among the top one percent of the world’s universities.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Hamza Jamjoom
Co-Founder - Arts & Architecture Student Council
Kara Pytko
Co-founder of Virtual Scientist Webinar Series
Company data provided by crunchbase