Analysis and Planning Consultant (Reporting Analyst)

Penn State University

University Park Campus
Campus City:
University Park, PA
Date Announced:
Date Closing:
Job Number:
Level/Salary Band:
  • 03 – J – Exempt
  • 04 – K – Exempt
Work Unit:
Office of the President
Office of Planning and Assessment
Full/Part Time:


The Pennsylvania State University is committed to ensuring that diversity, equity, and inclusion are central to the success of a world-class research institution. The Office of Planning and Assessment at Penn State supports this commitment throughout its four essential university functions: learning outcomes assessment, accreditation, strategic planning, and institutional research. The reporting analyst is an integral part of the institutional research team, which has responsibilities for official University reporting and conducting analyses that reflect the strategic priorities of the University. The position is physically located at the University Park campus, but connection to the 24 campuses around the Commonwealth is essential for this role. The reporting analyst supports the work of the Penn State community through the systematic collection, analysis, and reporting of data related to the 24 campuses. The reporting analyst is responsible for establishing processes and procedures for extracting, compiling, analyzing, and presenting data relevant to various components of the University, with a primary focus on Penn State’s human resources and student data for federal and state compliance reporting, regional accreditation, and institutional research studies. The position requires the skills to analyze, design, program, test, debug, implement, and modify existing reporting and analysis processes to serve as the source of the University’s official data for both internal and external reporting. For more information about the Office of Planning and Assessment, please visit the following site: 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 three 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. The position requires skills to work with large complex data sets, merge current with historical records, use database query tools, and develop programming logic that can be deployed and repeated to extract, translate, and load data into various data systems. The ability to establish automated procedures for analysis and reporting, as well as the ability to effectively communicate the methodology for these established procedures, is essential for this position. Experience with business processes for data extraction, transformation, and primary file creation in support of human resource and student system reporting is preferred. The willingness and ability to identify and implement innovative solutions to important, highly complex strategic and operational issues is vital to this position. Demonstrated experience in SQL and Access to support these processes is required and is essential for the position. The person in this position will have demonstrated experience in applying rigorous quality assurance processes to ensure data accuracy and will be able to work collaboratively with various University offices to ensure data integrity. Knowledge of IPEDS reporting is preferred in order to meet reporting requirements. The analyst will conduct in-depth analysis using faculty and student data and prepare written reports for internal and external audiences. Experience using Workday for reporting human resources data is preferred. Experience with Oracle’s PeopleSoft Campus Solutions (known as LionPath at Penn State) for accessing student data is preferred. Excellent interpersonal, teamwork, problem solving, attention to detail, and time management skills are required for this position.

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