Business Intelligence Analyst

Penn State University

Campus/Location:
University Park Campus
Campus City:
University Park, PA
Date Announced:
01/14/2020
Date Closing:
open until filled
Job Number:
92942
Level/Salary Band:
03 – H – Exempt
Work Unit:
College of Information Sciences and Technology
Department:
College of Information Sciences and Technology
Full/Part Time:
Full–Time

Description

The College of Information Sciences and Technology seeks a highly motivated and innovative Business Intelligence Analyst ready to provide data query creation, reporting assessment, and modeling data, accessing and querying internal and external data sets to extend to the college’s data warehouse capabilities; and design and creation of data reports and visualizations. The successful candidate will be responsible for working with the academic and administrative leadership to create routine to moderately complex applications to ensure delivery of the highest quality and accurate information across all functional areas within the college. Essential responsibilities of this position include: accessing and querying internal and external (where available) data sets to extend the college’s data warehouse capabilities; design and creation of data reports and visualization models that are intuitive and user-friendly to users as well as timely and accurate dissemination; design and implement tools/databases that enhance the collection of and reporting of approved data; assist in the coordination with various user groups to gather and analyze requirements and promote the correct interpretation and use of University information; assist, when necessary, in the development of training material and delivering training for data warehouse and reporting deliverables; and assist in the coordination of gathering and analyzing requirements and development of a learning analytics dashboard for faculty and student use. Candidate must have experience with relational and dimensional data modeling, professional experience with structured databases (using SQL), and should have a basic understanding of Extract, Transform, and Load (ETL/ELT) business practices. Experience with Oracle Business Intelligence Enterprise Edition (iTwo), or Tableau is preferred. Knowledge of Python and/or machine learning is a plus. The ideal candidate will be detail oriented, have strong data analysis skills, have excellent written and oral communication skills, and have some experience/knowledge of higher education processes, particularly areas related to student data, finance, human resources, compliance and research functions and strategic planning. Typically requires a Bachelor's degree or higher plus three years of related experience, or an equivalent combination of education and experience. This is a fixed-term appointment funded for one year from date of hire with excellent possibility of re-funding.

These salary bands have been established to provide salary guidelines for staff positions.

Salary Band Minimum Midpoint Maximum
A $16,584 $24,456 $32,328
B $18,240 $26,904 $35,556
C $19,728 $29,592 $39,456
D $21,708 $32,568 $43,416
E $24,312 $36,468 $48,612
F $27,228 $40,848 $54,456
G $30,012 $45,744 $61,500
H $34,188 $52,140 $70,080
I $38,988 $59,424 $79,908
J $43,716 $67,740 $91,812
K $50,712 $78,600 $106,488
L $58,836 $91,176 $123,528
M $68,232 $105,756 $143,292
N $80,508 $124,788 $169,068
O $93,492 $147,252 $201,024
P $110,340 $173,760 $237,192
Q $126,396 $199,056 $271,728
R $151,668 $238,872 $326,088