Pennsylvania State University
Business Intelligence Specialist
🇺🇸 Remote - US
🕑 Full-Time
💰 $77K - $115K
💻 Data Science
🗓️ December 5th, 2025
ETL
FERPA
Power BI
Edtech.com's Summary
The Pennsylvania State University is hiring a Business Intelligence Specialist. This role involves designing, developing, and maintaining advanced business intelligence solutions and data analytics to support strategic decision-making in the College of Health and Human Development, collaborating with leadership and cross-functional teams to deliver actionable insights and visualizations.
Highlights
- Design, develop, and enhance scalable BI systems to support enterprise data analytics and reporting.
- Leverage tools like Power BI, Tableau, and advanced BI technologies to transform complex data into actionable insights.
- Collaborate with stakeholders to gather requirements and define strategic, data-driven outcomes.
- Ensure reliability and performance of BI applications through testing and optimization.
- Maintain comprehensive documentation including advanced logic, queries, and scripts.
- Provide consultation, training, and support to elevate organizational data literacy.
- Build and optimize data pipelines and models integrating real-time analytics and data warehouses.
- Serve as liaison to the University's Office of Planning and Institutional Research (OPAIR).
- Ensure data accuracy, integrity, and compliance with institutional and regulatory standards.
- Requires Bachelor's degree, 3+ years of relevant experience, proficiency in SQL, ETL, database management, and BI visualization tools.
- Salary range: $76,700 to $115,100 with comprehensive benefits including medical, dental, vision, retirement plans, paid time off, and a 75% tuition discount.
Business Intelligence Specialist Full Description
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 Dean's Office in the College of Health and Human Development is seeking applicants for a Business Intelligence (BI) Specialist (Advanced). Reporting to the Assistant Dean for Operations, this position is responsible for designing, developing, and maintaining data analytics and reporting solutions that support strategic decision-making in Penn State's College of Health and Human Development.
The Business Intelligence (BI) Specialist will play a critical role in transforming complex data into actionable insights that inform strategic decision-making and drive business performance; leverage advanced BI technologies to design, develop, and maintain scalable business intelligence solutions, ensuring that data is accessible, accurate, and aligned with strategic objectives; and will collaborate with college leadership and cross-functional teams to identify analytical needs, resolve technical challenges, and deliver intuitive visualizations and dashboards.
Responsibilities:
- Leverage advanced business intelligence (BI) technologies and methodologies to transform complex data sets into strategic and actionable business insights that support organizational growth, innovation, and data-driven decision making
- Lead the strategic design, architecture, and continuous enhancement of scalable BI systems and solutions that support enterprise-wide data gathering, storage, and analytics
- Engage with cross-functional stakeholders to identify strategic objectives, gather business requirements, and define data-driven outcomes
- Design and deliver compelling data visualizations and dashboards, supplementing them with high-level narratives to contextualize findings and inform key strategic decisions
- Ensure the reliability, scalability, and performance of BI applications through rigorous testing, troubleshooting, and optimization; work closely with technical teams to resolve system issues and enhance capabilities
- Maintain documentation within BI systems including advanced logic and formulas, stored procedures, queries, and custom scripts
- Serve as a trusted adviser to users, providing consultation, training, and support in the effective use of BI tools to elevate organizational data literacy and decision-making maturity
- Build and optimize pipelines and data models that support real-time analytics, integration with data warehouses, and efficient data consumption across platforms
- Monitor emerging BI technologies, tools, and trends; assess their applicability to the university's strategic direction and guide the adoption of future-ready BI solutions
- Serve as the college's liaison to the University's Office of Planning and Institutional Research (OPAIR)
- Ensure data accuracy, integrity, and compliance with institutional and regulatory requirements
MINIMUM EDUCATION, WORK EXPERIENCE & REQUIRED CERTIFICATIONSBachelor's Degree3+ years of relevant experience; or an equivalent combination of education and experience
acceptedRequired Certifications:None
Qualifications:
- Experience in data visualization tools such as Power BI, Tableau, or similar BI platforms.
- Proficiency in SQL, database management, and ETL processes.
- Strong analytical skills with the ability to structure and interpret complex datasets and present insights.
- Excellent communication and collaboration skills to work effectively with cross-functional stakeholders.
- Understanding of higher education analytics and institutional research practices.
- Self-starter who is excited by the opportunity to shape and grow the college's analytics program.
Preferred Qualifications & Skills:
- Master's degree in Data Analytics, Information Systems, Business Administration, or a related field.
- Experience with cloud-based data solutions (Azure, AWS, Google Cloud).
- Familiarity with compliance frameworks such as FERPA and IPEDS data reporting.
Additional Information:
The location of this position is flexible and can operate fully remote or fully in person at the University Park campus, or in a hybrid model of both in-person and remote. Standard working hours are in the Eastern time zone. Questions about flexible work arrangements can be directed to the hiring manager.
BACKGROUND CHECKS/CLEARANCESEmployment 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 & BENEFITSThe salary range for this position, including all possible grades, is $76,700.00 - $115,100.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.The Pennsylvania State University 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.
Similar Jobs
Python, NodeJS, Java Senior Data Engineer I
Elsevier
🇺🇸 Philadelphia, PA
Senior Data Analyst
Utah State University
🇺🇸 Hybrid - Logan, UT
Director, Engineering - Data & Analytics
Frontline Education
🇺🇸 Remote - US
Research Analyst & BI Developer
Oakland University
🇺🇸 Rochester, MI
EHR/EMR Principal Data Analyst
Elsevier
🇺🇸 Remote - PA
