Business Intelligence Specialist
About The Position
Penn State Information Technology (PSIT) is seeking a Business Intelligence Specialist to serve as a member of a Data Analytics/Reporting Team, supporting both the SIMBA organization and the LionPATH Development and Maintenance Organization (LDMO). The successful candidate will provide data extraction, report development, analysis, and recommended design of analytics applications, data models, and reporting solutions to meet complex operational, financial, student, and other institutional reporting requirements. This role requires experience with two major enterprise systems supporting the University: SAP (used by SIMBA) and PeopleSoft Campus Solutions (used by the LDMO as the University’s Student Information System). The individual will work across a range of analytics and reporting platforms, data modeling environments, and enterprise data sources. Responsibilities include developing and supporting reports, queries, dashboards, datasets, and semantic data models; integrating enterprise-level data into appropriate reporting tools; and collaborating with functional business partners to design analytical solutions that support strategic and operational objectives.
Requirements
- Demonstrated experience as a data analyst, business intelligence developer, solutions architect, or in a similar role.
- Experience developing reports, queries, dashboards, and data models in business intelligence platforms.
- Experience working with SAP (SIMBA) and PeopleSoft Campus Solutions (LionPATH), including strong proficiency with PeopleSoft’s PSQuery tool.
- Strong analytical, problem-solving, and communication skills.
- Ability to learn new technologies quickly and work effectively in a dynamic team environment.
- Candidate must be a US Citizen to apply.
Nice To Haves
- Understanding of accounting principles, financial and student data concepts, and enterprise administrative processes, including how transactional data supports reporting and analytics.
- Experience working with enterprise data warehousing, semantic modeling, or modern analytics architecture.
- Experience integrating and modeling data from multiple administrative or operational systems.
- Experience supporting reporting and analytics in higher education or similarly complex organizations.
- Experience using AI-powered tools or techniques in analytics, reporting, automation, data modeling, or solution design.
Responsibilities
- Design, implement, and maintain complex data models and business intelligence solutions, ensuring efficient access methods, performance optimization, data organization, security, and documentation.
- Develop and enhance reports, queries, dashboards, datasets, and data transformations using modern business intelligence and analytics tools and delivered system functionality.
- Analyze business processes, data structures, and source systems to identify optimal data sources and reporting strategies.
- Collaborate with stakeholders and end users to translate business needs into technical specifications and analytics solutions.
- Provide business intelligence support by defining system scope and objectives, preparing detailed design specifications, and developing or modifying analytics applications accordingly.
- Manage solution design, data extraction, data modeling, testing, debugging, and related end-user documentation.
- Promote adherence to data governance, development standards, and documentation practices.
- Troubleshoot and collaborate to resolve data issues to ensure accuracy, consistency, and reliability in reporting outputs.
- Learn and apply new analytics technologies and techniques in support of evolving business needs.
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
