Business Intelligence Specialist

Summary

Penn State University is seeking a Business Intelligence Specialist to support its Data Analytics/Reporting Team and enterprise systems. The role develops and maintains data models, reports, dashboards, queries, datasets, and analytics solutions while collaborating with stakeholders to address institutional reporting needs.

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

Skills

• 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
• Bachelor's Degree
• 3+ years of relevant experience; or an equivalent combination of education and experience accepted
• Applicants must be authorized to work in the U.S
• 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

Qualifications

Must Haves

• 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
• Bachelor's Degree
• 3+ years of relevant experience; or an equivalent combination of education and experience accepted
• Applicants must be authorized to work in the U.S

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

Benefits

• Comprehensive medical, dental, and vision coverage
• Robust retirement plans
• Substantial paid time off which includes holidays, vacation and sick time
• 75% tuition discount, available to employees as well as eligible spouses and children
• Flexible work arrangements when aligned with the ability to meet the needs of the unit and the essential duties of the position