Business Intelligence Specialist

• 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.

JOB DESCRIPTION AND POSITION REQUIREMENTS:

The Agricultural Sciences Office of Finance and Business is hiring a Business Intelligence Specialist. The Business Intelligence Specialist will assist the Senior Supervisor with the analysis, design, develop, implementation and maintenance of county/college-wide administrative applications, relational databases, web applications, and data lake/repository for financial, research, student and other pertinent data. To include the administration, design, analysis, implementation, and maintenance of complex database structures of critical business value with respect to access methods, access time, device allocation, validation checks, organization, protection and security within FileMaker, SQL Server, Power BI and other related systems.

Responsibilities include:

• Assist the Senior Supervisor in facilitating the acquisition of university, college, and county level data for consumption into our data lake/repository. Develop and implement complex administrative, automation, and data integration scripts; display advanced knowledge of set-based, shell, and scripting languages. Create database maintenance procedures and backup/restore methods to protect the enterprise data; create innovative strategies and best practices to replicate the data to provide high availability. Contribute to strategic decision-making and long-term planning.

• Assist in the design, develop, implement, and support the creation and use of automated dashboards, analyses, reports, and other means as identified in support of the college mission in coordination with the Reporting and Data Management Team lead. Leading and/or mentor other team members.

• Assist in overseeing and maintaining On-Premises Gateway, SQL, and FileMaker servers. Assist in providing database development and support for confidential database systems.

• Develop functional knowledge of current systems, policies and practices through mentorship, professional development, and hands on learning. Role involves solving complex and varied problems with innovative approaches.

• Exhibit clear, accurate, and persuasive communication, both verbally and in writing, especially when dealing with internal and external stakeholders.

• Additional data management tasks as identified by the Director and team lead.

This position will work fully remote.

Education and Experience:

Minimum requirements for this position include a bachelor's degree and 3+ years of relevant experience, an equivalent combination of education and experience accepted.

The Pennsylvania State University is committed to and accountable for advancing equity, respect, and belonging in all its forms. We embrace individual uniqueness, as well as a culture of belonging that supports both broad and specific 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.

The salary range for this position, including all possible grades is:

Salary Structure - additional information on Penn State's job and salary structure.

CAMPUS SECURITY CRIME STATISTICS: