Data Analyst

Pittsburgh, PA, US • Posted 7 hours ago • Updated 7 hours ago
Full Time
On-site
Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

  • Technical Support
  • Data Integration
  • SQL
  • Data Warehouse
  • Snow Flake Schema
  • Tableau
  • Dashboard
  • Alteryx
  • Workflow
  • Leadership
  • Testing
  • Oracle
  • Analytical Skill
  • Auditing
  • Documentation
  • Regulatory Compliance
  • Reporting
  • Financial Aid
  • PeopleSoft

Summary

Essential Functions

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.

Physical Effort

  • 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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: RTX1ea725
  • Position Id: 21b7aa5b015ce46c3c7f18cadf207fe0
  • Posted 7 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Washington

Today

Full-time

USD 78,504.00 - 105,612.00 per year

Remote

Today

Full-time

USD 54,373.27 - 117,808.76 per year

Remote or New Hampshire

Today

Full-time

USD 23.23 - 39.61 per hour

Pittsburgh, Pennsylvania

5d ago

Easy Apply

Full-time

$90

Search all similar jobs