Overview
Remote
On Site
USD 61,800.00 - 102,300.00 per year
Full Time
Skills
Workday
Analytical Skill
Benchmarking
Stored Procedures
Database
Dashboard
Regulatory Compliance
Data Quality
Data Science
Computer Science
SQL
Relational Databases
Microsoft Power BI
Tableau
Attention To Detail
Management
Communication
Microsoft Excel
Microsoft Office
Higher Education
Adobe AIR
Information Systems
PeopleSoft
Security Policy
Statistics
Reporting
Law
Accountability
Teaching
Research
Labour Law
Job Details
APPLICATION INSTRUCTIONS:
Approval of remote and hybrid work is not guaranteed regardless of work location. For additional information on remote work at Penn State, see Notice to Out of State Applicants.
POSITION SPECIFICS
The Office of Planning, Assessment, and Institutional Research (OPAIR) at Penn State is seeking a highly analytical and detail-oriented Institutional Data Analyst to support the University's required state and federal reporting. This position is central to the preparation and submission of official data reports to federal and state agencies, higher education consortia, and national rankings organizations.
The successful candidate will work closely with Institutional Reporting Specialists, Programmers, and campus stakeholders to ensure the accuracy, consistency, and timeliness of data submissions, including but not limited to IPEDS, Pennsylvania Department of Education (PDE), AAUP, and college rankings surveys (e.g., U.S. News & World Report, Common Data Set).
Key Responsibilities:
Required Qualifications:
Preferred Qualifications:
This position is filled at the Advanced Professional or Senior Professional level.
MINIMUM EDUCATION, WORK EXPERIENCE & REQUIRED CERTIFICATIONS
If filled as Data Analyst - Advanced Professional, this position requires:Bachelor's Degree3+ years of relevant experience; or an equivalent combination of education and experience acceptedRequired Certifications:NoneIf filled as Data Analyst - Senior Professional, this position requires:Bachelor's Degree6+ years of relevant experience; or an equivalent combination of education and experience acceptedRequired Certifications:None
BACKGROUND CHECKS/CLEARANCES
Employment with the University will require successful completion of background check(s) in accordance with University policies.
Penn State does not sponsor or take over sponsorship of a staff employment Visa. Applicants must be authorized to work in the U.S.
SALARY & BENEFITS
The salary range for this position, including all possible grades, is $61,800.00 - $102,300.00.
Salary Structure - Information on Penn State's salary structure
Penn State provides a competitive benefits package for full-time employees designed to support both personal and professional well-being. In addition to comprehensive medical, dental, and vision coverage, employees enjoy robust retirement plans and substantial paid time off which includes holidays, vacation and sick time. One of the standout benefits is the generous 75% tuition discount, available to employees as well as eligible spouses and children. For more detailed information, please visit our Benefits Page.
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.
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 .
The Pennsylvania State University is committed to and accountable for advancing equity, respect, and belonging. We embrace individual uniqueness, as well as a culture of belonging that supports 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.
Federal Contractors Labor Law Poster
PA State Labor Law Poster
Penn State Policies
Copyright Information
Hotlines
- 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.
Approval of remote and hybrid work is not guaranteed regardless of work location. For additional information on remote work at Penn State, see Notice to Out of State Applicants.
POSITION SPECIFICS
The Office of Planning, Assessment, and Institutional Research (OPAIR) at Penn State is seeking a highly analytical and detail-oriented Institutional Data Analyst to support the University's required state and federal reporting. This position is central to the preparation and submission of official data reports to federal and state agencies, higher education consortia, and national rankings organizations.
The successful candidate will work closely with Institutional Reporting Specialists, Programmers, and campus stakeholders to ensure the accuracy, consistency, and timeliness of data submissions, including but not limited to IPEDS, Pennsylvania Department of Education (PDE), AAUP, and college rankings surveys (e.g., U.S. News & World Report, Common Data Set).
Key Responsibilities:
- Lead or support the preparation and submission of required institutional reports to external agencies, including IPEDS, PDE, AAUDE, and other mandated surveys
- Coordinate and complete data submissions for national rankings and benchmarking efforts (e.g., Common Data Set, U.S. News, AAUDE)
- Develop, manage, and maintain complex SQL queries, views, and stored procedures to extract and validate data from institutional databases for reporting and analysis
- Create data visualizations and dashboards to communicate trends, comparisons, and key metrics to internal stakeholders
- Ensure data accuracy and compliance by identifying and resolving data quality issues, monitoring changes in reporting requirements, and maintaining alignment with federal and state regulations
- Document and manage reporting processes by maintaining clear records of data definitions, methodologies, and submission timelines to support transparency and repeatability
Required Qualifications:
- Degree in data science, statistics, education, public policy, computer science, or a related field
- Demonstrated proficiency in SQL for querying and manipulating data in relational databases
- Experience with federal and state reporting requirements in higher education (e.g., IPEDS, PDE)
- Experience creating data visualizations using tools such as Power BI, Tableau, Excel, or similar platforms
- Strong attention to detail and commitment to data accuracy and integrity
- Excellent organizational and time management skills, with the ability to manage multiple deadlines
- Strong written and verbal communication skills, including the ability to explain technical data to non-technical audiences
- Proficiency with Microsoft Excel and Office 365
Preferred Qualifications:
- Familiarity with national higher education data exchanges and associations (AAUDE, APLU, AIR, etc.)
- Experience completing required reporting across a multi-campus system
- Experience with student information systems (e.g., Banner, PeopleSoft)
This position is filled at the Advanced Professional or Senior Professional level.
MINIMUM EDUCATION, WORK EXPERIENCE & REQUIRED CERTIFICATIONS
If filled as Data Analyst - Advanced Professional, this position requires:Bachelor's Degree3+ years of relevant experience; or an equivalent combination of education and experience acceptedRequired Certifications:NoneIf filled as Data Analyst - Senior Professional, this position requires:Bachelor's Degree6+ years of relevant experience; or an equivalent combination of education and experience acceptedRequired Certifications:None
BACKGROUND CHECKS/CLEARANCES
Employment with the University will require successful completion of background check(s) in accordance with University policies.
Penn State does not sponsor or take over sponsorship of a staff employment Visa. Applicants must be authorized to work in the U.S.
SALARY & BENEFITS
The salary range for this position, including all possible grades, is $61,800.00 - $102,300.00.
Salary Structure - Information on Penn State's salary structure
Penn State provides a competitive benefits package for full-time employees designed to support both personal and professional well-being. In addition to comprehensive medical, dental, and vision coverage, employees enjoy robust retirement plans and substantial paid time off which includes holidays, vacation and sick time. One of the standout benefits is the generous 75% tuition discount, available to employees as well as eligible spouses and children. For more detailed information, please visit our Benefits Page.
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.
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 .
The Pennsylvania State University is committed to and accountable for advancing equity, respect, and belonging. We embrace individual uniqueness, as well as a culture of belonging that supports 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.
Federal Contractors Labor Law Poster
PA State Labor Law Poster
Penn State Policies
Copyright Information
Hotlines
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.