All Jobs
Business Administration Group
Administration Data Management Organizational Excellence Real Estate Records
Management Professional Supervisory
Administration Data Management Organizational Excellence Real Estate Records
Management Professional Supervisory
Penn State Job Catalog
Data Analyst – Intermediate Professional (PSU0357)
Job Summary and Representative Duties
The Data Analyst advises stakeholders in determining the appropriate analytical methodology to meet their requirements; gathers and analyzes data from various large datasets sources with the aim of providing actional insights that inform business decisions; develops reports, summaries, recommendations, and visual representations; performs statistical programming; develops and/or maintains databases.
- Meet with stakeholders to determine data needs and project requirements; advise in determining the appropriate analytical methodology to meet stakeholder needs and achieve objectives
- Collect, clean, validate, and format data from structured data sources including databases, surveys, or public data; design scripts and run queries to extract and retrieve data
- Use statistical techniques to explore and interpret data, identify trends, patterns, and correlations, and determine relationships; translate findings into actionable insights
- Apply best practices in data validation to ensure accuracy and consistency across datasets; identify and resolve errors
- Develop charts and visual aids to display and present data results
- Present findings and actionable insights to stakeholders in a clear, concise, and compelling manner
- Design and prepare standard and ad hoc reports; automate data workflows; develop and optimize reporting processes
- Maintain documentation of data processes and data dictionaries
- Continuously evaluate and implement new tools or methodologies to improve data accessibility and usability
- Ensure adherence to internal data governance policies and external regulations
- Collaborate with security and compliance teams to ensure proper handling of sensitive data
- May supervise staff members, including hiring, development, and performance management
Level Matrix
- Level:
- – Intermediate Professional
- Base Description:
- – Completes activities, tasks, and/or projects of a functional nature.
- Level Summary:
- – Demonstrates ability to perform intermediate tasks in defined skill areas. Demonstrates intermediate knowledge of internal procedures. Works under general supervision, performing assignments that may be varied and sometimes difficult. Supports team decisions and follows through with team responsibilities. Interprets and communicates information clearly and accurately. Demonstrates intermediate problem–solving skills.
- Supervisory Responsibilities:
-
– May serve as direct supervisor for part–time, student, and/or temporary workers or volunteers
- Fiscal Responsibilities:
-
– May validate and pay invoices
- Problem Solving:
-
– Encounters generally routine problems; occasionally faces more complex and/or varied problems
– Typically follows recommended course of action and procedures to resolve problems
– Applies knowledge of larger unit goals, priorities, and related procedures in determining course of action
- Independence of Action:
-
– Work is generally monitored by supervisor
– Detailed instructions and procedures are generally provided
– Uses available guidelines to make appropriate adaptations to routine situations and refers other situations to supervisor
- Communication and Collaboration:
-
– Communicates internally within working unit and/or the University
– May communicate with external audiences
– Collaborates closely with team members
– Interprets and communicates information, ideas and instructions clearly and accurately both verbally and in written materials intended for distribution
Salary Structure
- Comp Grade – 9
- Minimum – $56,200.00
- MidPoint – $68,800.00
- Maximum – $81,500.00
Critical Skills
- Analytical thinking
- Data Analysis
- Data Collection
- Data security
- Data visualization
- Database management
- Document management
- Report writing
- Research methods
- Statistical thinking
FLSA Exemption Status
Exempt
Minimum Education
Bachelor's Degree
Minimum Experience
1+ years of relevant experience
Equivalency
An equivalent combination of education and experience accepted
Job Profile last updated on 2025-08-05