Data Analyst - Pittsburgh, PA
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
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.
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 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
Job_Category
Management
City*
Pittsburgh
State*
Pennsylvania
Job Code
Education Educational and Training Services
Affiliate Sponsor
Pitt
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
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.
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 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
Job_Category
Management
City*
Pittsburgh
State*
Pennsylvania
Job Code
Education Educational and Training Services
Affiliate Sponsor
Pitt
Recommended Jobs
Business Intelligence Developer II
Posted 1 hour ago
Data Solutions Analyst (Regional Reporting Team)
Posted 2 hours ago
Data Science Analyst
Posted 2 hours ago
Data Analyst - Servicing Operations
Posted 1 day ago
Product Analyst / Data Analyst
Posted 1 day ago