- 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
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 serve as a Business Intelligence Specialist, providing 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.
CORE 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.
QUALIFICATIONS
Required
- 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.
Preferred
- 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.
MINIMUM EDUCATION, WORK EXPERIENCE & REQUIRED CERTIFICATIONS
Bachelor's Degree 3+ years of relevant experience; or an equivalent combination of education and experience accepted Required Certifications: None
LOCATION
The location of this position is flexible and can operate fully remote within the United States (restrictions apply). PSIT is supportive of flexible work arrangements when aligned with the ability to meet the needs of the unit and the essential duties of the position. Questions related to flexible work hours should be directed to the hiring manager during the interview process.
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 $81,312.00 - $122,016.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 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.
Federal Contractors Labor Law Poster
PA State Labor Law Poster
Penn State Policies
Copyright Information
Hotlines
Skills Required
- 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
- Strong proficiency with PeopleSoft PSQuery
- Strong analytical, problem-solving, and communication skills
- Ability to learn new technologies quickly and work effectively in a dynamic team environment
- U.S. citizenship and authorization to work in the United States without employer visa sponsorship
- Bachelor's degree and 3 or more years of relevant experience, or equivalent combination of education and experience
- Understanding of accounting principles, financial and student data concepts, and enterprise administrative processes
- Experience 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
Penn State University Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Penn State University and has not been reviewed or approved by Penn State University.
-
Retirement Support — Employer contributions to SERS and the TIAA Alternate Plan are described as significant, with supplemental retirement options available. Feedback suggests these choices and contributions create strong long‑term value.
-
Leave & Time Off Breadth — Full‑time employees accrue over 24 sick and vacation days annually, with additional university holidays and a winter break. Feedback suggests this depth of leave supports work–life balance.
-
Inclusive Benefits Coverage — A 75% tuition discount extends to employees, spouses, and dependent children up to age 26 across resident instruction, World Campus, and Penn College courses. Feedback suggests this broad eligibility meaningfully enhances total rewards, especially for families.
Penn State University Insights
What We Do
There’s a reason Penn State consistently ranks among the top one percent of the world’s universities. Across 24 campuses, our nearly 88,000 students and 17,000 faculty and staff know the real measure of success goes beyond the classroom—it’s the positive impact made on communities across the world. From access to state-of-the-art resources to interdisciplinary pursuits in collaborative atmospheres, a Penn State degree is more than an education. The experiences and knowledge gained here will form the foundation for the lives our students build. Their contributions to the world begin with a Penn State degree. We Are Penn State.
