University at Buffalo logo

University at Buffalo

Application Analyst, UB Foundation, Inc.

🇺🇸 Buffalo, NY

🕑 Full-Time

💰 $72K - $82K

💻 Data Science

🗓️ November 6th, 2025

ETL SQL

Edtech.com's Summary

University at Buffalo Foundation is hiring an Application Analyst who will maintain, enhance, and ensure the quality of application software including AccuFund, Real Vision Software, Caissa, and SIRI. The role involves supporting ETL processes using tools like Visual Studio and SSIS, developing Oracle and SQL Server components, conducting quality assurance, and collaborating with end-users to improve processes and data accuracy.

Highlights
  • Maintain and enhance application software for UB Foundation such as AccuFund, RVI, Caissa, and SIRI.
  • Use Visual Studio and SSIS to support ETL processes and ensure data integration across systems.
  • Develop and maintain Oracle and SQL Server stored procedures, functions, and views used in ETL workflows.
  • Conduct quality assurance activities to ensure data reliability and efficiency.
  • Identify and implement process improvements to enhance data feed accuracy.
  • Engage with end-users to gather feedback and meet user needs.
  • Develop knowledge of UB Foundation business office operations.
  • Required qualifications include a Bachelor’s degree, minimum 2 years’ experience in database operations, SQL database knowledge, and ETL development experience.
  • Preferred skills include problem solving, communication, independence, organizational skills, and ETL development with SSIS in Visual Studio.
  • Salary range is $72,000 - $82,000; full-time position; background check required.