Enable job alerts via email!

Business Intelligence Specialist

The Pennsylvania State University

University Park (PA, TX)

Remote

USD 76,000 - 116,000

Full time

Yesterday
Be an early applicant

Boost your interview chances

Create a job specific, tailored resume for higher success rate.

Job summary

The Pennsylvania State University is seeking a Business Intelligence Specialist to assist in the analysis, design, and maintenance of applications and databases. This fully remote position requires a bachelor's degree and 3+ years of relevant experience, focusing on data management and strategic decision-making.

Qualifications

  • Bachelor's degree and 3+ years of relevant experience required.
  • Advanced knowledge of database structures and scripting languages.
  • Experience with data integration and automation.

Responsibilities

  • Assist in the analysis, design, and maintenance of administrative applications.
  • Develop and implement data integration scripts and database maintenance procedures.
  • Create automated dashboards and reports in support of the college mission.

Skills

Data Analysis
Database Management
Scripting Languages
Communication

Education

Bachelor's Degree

Tools

FileMaker
SQL Server
Power BI

Job description

United States, Pennsylvania, University Park

  • 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 a ssist 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 b achelor's degree and 3+ years of relevant experience, a n 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:

$76,700.00 - $115,100.00

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.

JOB DESCRIPTION AND POSITION REQUIREMENTS:

The Agricultural Sciences Office of Finance and Business is hiring a Business Intelligence Specialist. The Business Intelligence Specialist will a ssist 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 b achelor's degree and 3+ years of relevant experience, a n 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:

$76,700.00 - $115,100.00

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

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.

Employment with the University will require successful completion of background check(s) in accordance with University policies.

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.

Federal Contractors Labor Law Poster

PA State Labor Law Poster

Penn State Policies

Copyright Information

Hotlines

University Park, PA

Helping all candidates find great careers is our goal. The information you provide here is secure and confidential.

We are now directing you to the original job posting. Please apply directly for this job at the employer’s website.

Get your free, confidential resume review.
or drag and drop a PDF, DOC, DOCX, ODT, or PAGES file up to 5MB.

Similar jobs

Business Intelligence Specialist

Providge Consulting

Remote

USD 89.000 - 221.000

Yesterday
Be an early applicant

Business Intelligence Specialist

Ignite Digital Federal Services

Charleston

Remote

USD 80.000 - 100.000

Today
Be an early applicant

Business Intelligence Specialist

JLL

Phoenix

Remote

USD 90.000 - 110.000

4 days ago
Be an early applicant

Threat Intelligence Specialist, US&C

Kodex

Remote

USD 80.000 - 120.000

Yesterday
Be an early applicant

Business Intelligence Specialist

Itcustomsolution

New York

Remote

USD 60.000 - 100.000

30+ days ago

Business Intelligence Specialist - 100% Remote

ContractStaffingRecruiters.com

Wallingford

Remote

USD 80.000 - 100.000

30+ days ago

Business Intelligence Specialist III

Maxor National Pharmacy Services, LLC

Remote

USD 70.000 - 110.000

30+ days ago

Data Warehouse & Business Intelligence Specialist

Matrix-EE

Snowflake

Remote

USD 70.000 - 110.000

30+ days ago

Business Intelligence Specialist

4Wall Entertainment

Las Vegas

Remote

USD 60.000 - 100.000

30+ days ago