We are seeking an HR Data Analyst to join our team and play a critical role in transforming complex employee data into actionable insights for HR leadership and partners across the University. This position will leverage analytics tools and platforms to analyze large HR datasets, develop comprehensive reporting solutions, and drive data-informed decision-making across the University.
In this role, you will partner closely with HR leadership and stakeholders to understand their analytical needs — often starting from ambiguous or loosely defined requirements — and translate those needs into concrete technical solutions, while distilling the resulting complexity into clear, actionable insights for non-technical audiences. You will use SQL to merge, transform, and analyze data across multiple systems, including Oracle HCM, Taleo, Salesforce, and third-party benefits vendor platforms. You will also build automated data workflows that streamline business processes and improve data quality across the team's reporting pipeline. And you will build, update, and maintain dashboards in Tableau to visualize this data. You will also collaborate closely with Pitt Digital's broader technical team, who manage enterprise data and reporting platforms across the University, to ensure your analyses and dashboards are built on reliable, well-governed data infrastructure.
Required Qualifications
- 5+ years of professional experience in data analysis or a related role
- Experience with HR/organizational people data (e.g., headcount, turnover, recruiting metrics) and the judgment to interpret it correctly, avoid common pitfalls (e.g., data lag, org restructuring effects, voluntary vs. involuntary turnover), and communicate findings clearly to non-technical audiences
- Proficient in SQL, including ability to write joins, understand and write complex queries
- Understands the concept of data grain (e.g., one row per employee vs. one row per employee per pay period) and applies it to write SQL queries that avoid duplication, incorrect joins, or misleading aggregations
Strong experience with visualization tool (Tableau preferred) for dashboard & report development, including calculated fields, parameters & advanced visualizations
Working knowledge of Python, R, or similar programming languages for data manipulation & analysis
Strong knowledge of data manipulation, cleaning & wrangling techniques
Experience with Alteryx for data automation or transformation preferred
Applicants should include salary requirements in cover letter. -------------- The University offers a robust retirement savings plan with 100% employer match, 150% after vesting. 11 Paid Holidays. Paid Vac, Sick, Personal. Add'l Winter Recess Paid Time Off. Paid Parental Leave. Above-average Employer Contribution toward Medical, Prescription Drug, Dental, Vision, Life, and more. Education benefits for staff, spouses/ partners, dependents. Student loan assistance. Free transit pass. ---------------
On 8-13-26, Forbes listed Pitt among the 100 best employers in the commonwealth, ranking third among higher education institutions. This is the 6th year Pitt has been on Forbes' America's Best-in-State Employers list for PA.
Join the team responsible for strategy, implementation, and maintenance of technology at the University of Pittsburgh—ranked by Forbes among Amazon, CDW, Cisco Systems, Google, LinkedIn, and Microsoft as one of “America’s Best Large Employers.”
Evaluates business requirements and performs advanced data integration and analysis. Develops advanced analytical and reporting tools utilizing multiple sources of integrated data. Provides technical support.
Must have the ability to work with PC equipment and related hardware/software and telephony video-conferencing systems. Must have good written and verbal communication skills, as well as, analytical, organizational, and planning skills. Must have proficient knowledge of IT and HR information systems.
Generally sedentary desk work with computer-keyboard video phone other than traveling to other buildings on campus for meetings/events on occasion. Must be able to sit or stand for prolonged periods of time.
The University of Pittsburgh is an equal opportunity employer / disability / veteran.
Job Details
- Assignment Category: Full-time regular
- Job Classification: Staff.Data Analyst III
- Job Family: Information Technology
- Job Sub-Family: Analytics
- Campus: Pittsburgh
- Minimum Education Level Required: Bachelor's Degree
- Minimum Years of Experience Required: 5
- Substitution in lieu of education or experience: Combination of education and relevant experience will be considered in lieu of education and/ or experience requirement.
- Work Schedule: M-F bus hrs EST. On occasion, some evening and weekend work may be necessary depending on business load, project timeline requirements, urgent support, or scheduled downtime changes.
- Work Arrangement: Hybrid: Combination of On-Campus and Remote work as determined by the department.
- Hiring Range: TBD Based Upon Qualifications
- Relocation Offered: No
- Visa Sponsorship Provided: No
- Background Check: For position finalists, employment with the University will require successful completion of a background check
- Child Protection Clearances: Not Applicable
- Required Documents: Resume
- Optional Documents: Cover Letter