The Pennsylvania State University-posted 7 days ago
Full-time • Mid Level
Hybrid • University Park, FL
5,001-10,000 employees

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.

  • 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
  • Bachelor's Degree
  • 3+ years of relevant experience; or an equivalent combination of education and experience accepted
  • 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.
  • 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.
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service