Data Analyst - Pittsburgh, PA

VetJobs; Pittsburgh (Allegheny County); Hybrid; USD 75,000 - 110,000; Full time

Job summary

The University of Pittsburgh is seeking a Staff Data Analyst III to evaluate business requirements and perform advanced data integration and analysis. This role develops analytical and reporting tools using multiple data sources and provides technical support to financial aid leadership across campus.

Responsibilities include analyzing regulatory changes, maintaining SQL queries, and documenting methods for audits.

Qualifications

• Bachelor's degree in a relevant field with 5+ years of data analysis experience.
• Experience with PeopleSoft Campus Solutions and data warehouse querying for eligibility analysis and compliance reporting.
• Proficiency in creating advanced analytical and reporting tools using Tableau, Snowflake, and Alteryx.
• Strong documentation, communication, and ability to support audits and regulatory initiatives.

Responsibilities

• Perform advanced data integration and analysis.
• Analyze federal regulatory changes to assess impact on aid data and system configuration.
• Identify population-level effects on aid packaging, eligibility, and reporting.
• Develop and maintain complex SQL queries against PeopleSoft Campus Solutions and Data Warehouse.

Skills

Advanced data integration

Federal regulation analysis

SQL querying

Data reporting tools

Education

Bachelor's degree

Tools

PeopleSoft Campus Solutions

Data Warehouse

Tableau

Snowflake

Alteryx

Job description

Job Description

On behalf of VetJobs/MilitarySpouseJobs, thank you for your interest. We are assisting our partnering company, listed below, with this position. It is open to Veterans, Transitioning Military, National Guard Members, Military Spouses, Wounded Warriors, and their Caregivers. If you have the required skill set, education requirements, and experience, please click the submit button and follow for next steps.

Job Description

On behalf of VetJobs/MilitarySpouseJobs, thank you for your interest. We are assisting our partnering company, listed below, with this position. It is open to Veterans, Transitioning Military, National Guard Members, Military Spouses, Wounded Warriors, and their Caregivers. If you have the required skill set, education requirements, and experience, please click the submit button and follow for next steps.

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

• Perform advanced data integration and analysis
• Analyze federal regulatory changes (e.g., OB3, NSLDS Loan Year classification updates) to assess impact on institutional aid data and system configuration
• Identify student population-level effects on aid packaging, eligibility, and reporting through multi-table analysis
• Develop and maintain complex SQL queries against PeopleSoft Campus Solutions tables and Data Warehouse to support aid eligibility analysis and compliance reporting
• Document query logic, methodology, and intended use for institutional reference
• Develop and maintain advanced analytical and reporting tools utilizing integrated financial aid data (PeopleSoft, Tableau, Snowflake, Alteryx)
• Develops advanced analytical and reporting tools through the creation and maintenance of Tableau dashboards and Alteryx workflow, providing necessary data to functional financial aid leadership at all campuses and careers
• Follow industry standards in reporting tool development to ensure consistency and reliability
• Coordinate patch validation and testing in TEST environments prior to production deployment
• Escalate complex system issues to senior analysts or Oracle support as appropriate
• Document analytical methods, data sources, and findings for internal stakeholders and external audits
• Author technical reference documentation for regulatory compliance initiatives (e.g., OB3/PeopleSoft reference guides)
• Support award year readiness by validating system data against updated federal aid classifications and reporting requirements
• Assist in help ticket resolution, including receiving, triaging, and resolving end user financial aid help tickets related to financial aid systems and PeopleSoft Campus Solutions
• Document resolutions, workarounds, and known issues for institutional reference

Physical Effort

Most work is sedentary, completed within an office setting. Employee must be able to move about the campus to meetings and travel to locations outside of the University of Pittsburgh.

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

B

Minimum Education Level Required Bachelor's Degree

Minimum Years of Experience Required 5

Will this position accept substitution in lieu of education or experience? No

Work Schedule Monday - Friday, 8:30 a.m. - 5:00 p.m., some mornings, evenings and weekends may be required

Work Arrangement Hybrid: Combination of On-Campus and Remote work as determined by the department.

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 The following PA Act 153 clearances and background checks are required prior to commencement of employment and as a condition of continued employment: PA State Police Criminal Record Check, FBI Criminal Record Check, PA Child Abuse History Clearance.

Required Documents Resume, Cover Letter

Optional Documents Not Applicable

Auto req ID

480679BR

Minimum Education Required

Bachelors

Preferred Education

Bachelors

Required Experience

5 years 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.

Preferred Experience

5 years 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.

Required Skills

• Perform advanced data integration and analysis
• Analyze federal regulatory changes (e.g., OB3, NSLDS Loan Year classification updates) to assess impact on institutional aid data and system configuration
• Identify student population-level effects on aid packaging, eligibility, and reporting through multi-table analysis
• Develop and maintain complex SQL queries against PeopleSoft Campus Solutions tables and Data Warehouse to support aid eligibility analysis and compliance reporting

Preferred Skills

• Perform advanced data integration and analysis
• Analyze federal regulatory changes (e.g., OB3, NSLDS Loan Year classification updates) to assess impact on institutional aid data and system configuration
• Identify student population-level effects on aid packaging, eligibility, and reporting through multi-table analysis
• Develop and maintain complex SQL queries against PeopleSoft Campus Solutions tables and Data Warehouse to support aid eligibility analysis and compliance reporting

City*

Pittsburgh

State*

Pennsylvania

Job_Category

Management

Job Code

Education Educational and Training Services

Affiliate Sponsor

Pitt