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.
Admissions & Financial Aid
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 People
- Soft 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 (People
- Soft, 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/People
- Soft 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 People
- Soft 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 CategoryFull-time regularJob ClassificationStaff.
Data Analyst IIIJob FamilyInformation TechnologyJob Sub-FamilyAnalyticsCampusPittsburghMinimum Education Level
Required
Bachelor's DegreeMinimum Years Of Experience
Required
- 5Will this position accept substitution in lieu of education or experience?
- NoWork 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
- NoVisa Sponsorship Provided
- NoBackground 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
