HR Data Analyst

University of Pittsburgh; Pittsburgh (Allegheny County); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Retirement match

11 Paid Holidays

Paid Vacations

Education benefits

Free transit pass

Student loan assistance

Job summary

University of Pittsburgh seeks an HR Data Analyst to transform complex employee data into actionable insights for HR leadership and partners across the University. You will leverage analytics tools to analyze large HR datasets, and build dashboards in Tableau to visualize findings for non-technical audiences.

You will partner with HR leadership to translate ambiguous requirements into concrete technical solutions, write complex SQL queries across Oracle HCM, Taleo, and Salesforce, and develop

Qualifications

• 5+ years of professional experience in data analysis or a related role.
• Experience with HR/organizational people data and communicating findings to non-technical audiences.
• Proficient in SQL with ability to write joins and complex queries.
• Understanding data grain and writing queries to avoid duplication and misleading aggregations.
• Strong experience with Tableau for dashboard/report development, including calculated fields and advanced visuals.
• Experience with Python or R for data manipulation and analysis.
• Experience with Alteryx for data automation or transformation.

Responsibilities

• Analyze complex employee data and provide actionable insights for HR leadership.
• Develop comprehensive reporting solutions and dashboards in Tableau across multiple systems.
• Build automated data workflows to streamline business processes and improve data quality.
• Collaborate with Pitt Digital and other teams to ensure reliable, well-governed data infrastructure.

Skills

SQL

Tableau

Python

R

Alteryx

HR data

Data wrangling

Education

Bachelor's Degree

Tools

Oracle HCM

Taleo

Salesforce

Job description

Job Description - HR Data Analyst (26005408)

HR Data Analyst

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

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 Employerslist 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."

Job Summary

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.

Essential Functions

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.

Physical Effort

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.

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

Will this position accept 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

The University of Pittsburgh is an equal opportunity employer / disability / veteran.