Programmer/Analyst (Business Intelligence Programmer/Analyst)

Penn State University

University Park Campus
Date Announced:
Date Closing:
Job Number:
Level/Salary Band:
  • 03 – K – Exempt
  • 04 – L – Exempt
Work Unit:
Division of Development and Alumni Relations
Information Systems
Full/Part Time:


The Penn State Division of Development and Alumni Relations is seeking qualified candidates for the position of Business Intelligence (BI) Programmer Analyst for the Advancement Business Intelligence (ABI) team under the direction of the Assistant Director of Information Systems. The qualified candidates will have four primary responsibilities: Business Intelligence, Programming, Project Management, and Business Analysis. As part of Business Intelligence, the BI Programmer Analyst will partner with Division and University units to provide consultancy and translate the business needs to design and develop tools, techniques, metrics, and dashboards for insights and data visualization and utilize BI and analytics tools like Tableau BI, QlikView, SAS BI, MS BI, SAP BI, and Oracle BI. As part of Programming, the BI Programmer Analyst will write queries to pull data, document logic for data extraction, write reports using a variety of tools, and be the primary BI lead on data systems, reporting and querying. Have proven expertise and/or ability to learn and operate computer software programs and working knowledge of: relational database systems (TSQL, PLSQL); statistics (SPSS, SAS); report writers (SQL reporting services, and/or Crystal Reports). As part of Project Management, the BI Programmer Analyst will demonstrate a history of managing large and small projects, having demonstrated knowledge of project management methods like Agile, Scrum, and Waterfall; determine the resources and time requirements to complete the project and ensure all resources are allocated effectively. As part of Business Analysis, the BI Programmer Analyst will analyze business requirements; understand data and reporting needs; develop reports and analyses using multiple data sources; and play a leadership role in the selection and implementation of BI Solutions. This job will be filled as a level 3, or level 4, depending upon the successful candidate's competencies, education, and experience. Typically requires a Bachelor's degree or higher plus four years of related experience, or an equivalent combination of education and experience for a level 3. Additional experience and/or education and competencies are required for higher level jobs. Background in statistical programming and analysis highly preferred. Candidates must possess strong problem solving, interpersonal, and verbal/written communication skills, as well as the ability to excel in team environments. 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