HR Data Analyst

About the role

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.

Responsibilities

• Leverage analytics tools and platforms to analyze large HR datasets
• Develop comprehensive reporting solutions
• Drive data-informed decision-making across the University
• Partner closely with HR leadership and stakeholders to understand their analytical needs
• Translate those needs into concrete technical solutions
• Distill the resulting complexity into clear, actionable insights for non-technical audiences
• Leverage SQL to merge, transform, and analyze data across multiple systems, including Oracle HCM, Taleo, Salesforce, and third-party benefits vendor platforms
• Build automated data workflows that streamline business processes and improve data quality across the team's reporting pipeline
• Build, update, and maintain dashboards in Tableau to visualize this data
• Collaborate closely with Pitt Digital's broader technical team to ensure analyses and dashboards are built on reliable, well-governed data infrastructure

Requirements

• 5+ years of professional experience in data analysis or a related role
• Experience with HR/organizational people data and the judgment to interpret it correctly
• Proficient in SQL, including ability to write joins, understand and write complex queries
• Strong experience with visualization tool (Tableau preferred) for dashboard & report development, including calculated fields, parameters & advanced visualizations
• Strong knowledge of data manipulation, cleaning & wrangling techniques
• Experience with Alteryx for data automation or transformation preferred

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
• Strong experience with visualization tool (Tableau preferred) for dashboard & report development, including calculated fields, parameters & advanced visualizations
• Strong knowledge of data manipulation, cleaning & wrangling techniques
• Experience with Alteryx for data automation or transformation preferred

Skills

• SQL
• Tableau
• Python/R
• Alteryx

Benefits

N/A

Pay

TBD

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.