Financial Aid IT Business Systems Analyst II

Edtech.com's Summary

Appalachian State University is hiring a Financial Aid IT Business Systems Analyst II. This role involves developing software and reports using WebFOCUS, SQL, and Tableau to support Financial Aid operations, managing multiple Financial Aid software systems, and leading IT projects to ensure efficient and compliant financial aid processing. The analyst will design and implement software solutions, test updates, liaise between technical and functional teams, and provide training on new systems.

Highlights

Develop software programs and reports to support Financial Aid data analysis and processes using WebFOCUS, SQL, and Tableau.

Manage integration and data flow among multiple Financial Aid software systems including Banner Financial Aid, Student Forms, and Scholarship Universe.

Write SQL queries to identify and resolve software or procedural issues and develop new applications as needed.

Develop and maintain Appworx scripts to automate Banner Financial Aid processes.

Manage Financial Aid IT projects such as software installation, configuration, and year-end closings.

Test Banner Financial Aid software updates and serve as a liaison for system integration and accuracy.

Analyze business practices to recommend or develop modifications or new systems for improved efficiency.

Create and maintain documentation of Financial Aid IT processes and manage security access requests in coordination with ITS.

Provide training on new software to Financial Aid, University Scholarships, and campus scholarship management units.

Required qualifications include a bachelor's degree with programming coursework or equivalent experience; preferred skills include SQL programming, scripting languages, ERP integration, UML modeling, and IT project management.

Salary range is $60,000 - $66,072; full-time position with standard Monday-Friday work hours.

Financial Aid IT Business Systems Analyst II Full Description

Employment Opportunities

Toggle navigation

Financial Aid IT Business Systems Analyst II Below you will find the details for the position including any supplementary documentation and questions you should review before applying for the opening. To apply for the position, please click the Apply for this Job link/button.

If you would like to bookmark this position for later review, click on the Bookmark this Posting link. If you would like to print a copy of this position for your records, click on the Print Preview link.

Bookmark this Posting Print Preview | Apply for this Job

Please see Special Instructions for more details.

Please submit the following required documents:

Cover Letter
Resume
List of 3 references

Posting Details

Request to Recruit

Position Title	Financial Aid IT Business Systems Analyst II
Location	Boone, North Carolina
Faculty Rank
Provide Rank
Position Number	024871
Department	Enrollment Mgt - Office of Student Financial Aid & University Scholarships - 240500

Position Summary Information

Primary Purpose	The primary purpose of the Office of Student Financial Aid and University Scholarships is to aid students and families in securing the financial resources necessary to attend college. The major activities of this unit include accurately and effectively aiding students, assisting with the completing of required applications, and ensuring students meet eligibility guidelines for various financial aid programs, evaluating all requests for eligibility, and administering all scholarships, grants, loans, and student work programs that are available to students at Appalachian State University. The Office is also responsible for the University’s compliance with federal and state regulations and reporting which are required to maintain our continued funding. The primary purpose of this position is to ensure the Office of Student Financial Aid and University Scholarships has systems and processes in place to effectively manage the reporting, packaging, updating, and communicating of all of the federal, state, institutional, and external funds awarded and received to assist students in paying for college. All processes and systems must remain compliant with Federal, State, NCAA, and Institutional regulations/laws. The purpose is to participate as a member of the critical team that manages the technology needed to ensure financial aid and scholarships can make awards in a streamlined and efficient way, communicate those awards consistently and effectively, and report on funds used to make those awards to help remain in compliance and within University’s budgetary limitations.
Minimum Qualifications	Graduation from a four-year college or university with nine semester hours in programming and one year of experience in business application consulting or development. Experience in the field of work related to the position’s role may be substituted on a year-for-year basis.
License/Certification Required
Preferred Qualifications	Experience writing SQL queries (preferably for Oracle databases) to extract, manipulate, analyze data, and create reports. Experience writing programs or scripts (R, Python, SAS, or other languages) to extract, manipulate, analyze data, and create reports. The ability to independently diagnose and resolve issues related to both data integrity and system functionality. Ability to manage data flow and system integrations between a primary ERP and third-party platforms such as Slate, Scholarship Universe, or Student Forms. Experience developing and maintaining automated scripts (e.g., Appworx) to streamline repetitive processes. Proficiency in UML Modeling or similar diagramming standards to document business practices and design technical solutions. Experience leading IT projects from inception to completion, including creating project schedules, defining milestones, and managing stakeholder expectations. Ability to analyze complex business requirements, identify process gaps, and recommend or develop technical modifications to improve operational efficiency. Ability to act as a high-functioning member of a critical technology team, collaborating closely with the Financial Aid Banner Lead, other members of the Financial Aid Tech team, and other Financial Aid staff.
Essential Duties and Responsibilities	Develop software programs and reports using WebFOCUS, SQL, and Tableau to support Financial Aid employees in data analysis and business processes. Demonstrate advanced knowledge of the standards, theories and practices associated with Banner Financial Aid and SQL reporting. Write SQL queries to independently identify issues with software or standard operation procedures. Identify solutions and make suggestions for technical modifications to prevent future problems. Develop new applications to address issues when needed. Develop Appworx scripts to automate Banner Financial Aid processes. Develop a detailed understanding of Financial Aid data and of the flow of that data among the various Financial Aid software systems. Work on integrating and managing multiple Financial Aid Software systems, including: Banner Financial Aid Student Forms Scholarship Universe Federal – SAIG Mailboxes Federal – COD State – State Grants Portal Manage various Financial Aid IT projects, e.g. installation and integration of new software (such as Scholarship Universe), new aid year software configuration, closing out aid year, etc. Work with central IT to design, develop, and test custom software solutions. Work with employees in the office of Financial Aid to understand functional requirements and to design and implement software systems to address those requirements. Test Banner Financial Aid software updates and patches. Test new functionality in Banner Financial Aid software releases. Serve as a functional user liaison during review of software applications. Act as a resource for the technical ITS staff to ensure appropriate integration and verify the accuracy of information. Work closely with Financial Aid office during testing for successful integration. Develop long-range vision and plans for Financial Aid IT systems, incorporating the appropriate use of technology into the division. Work closely with ITS to ensure adequate storage space and technical requirements for successful system performance. Participate in work groups with central IT to meet regularly to identify and resolve problems and to establish system goals. Understand and develop strategies for improved use of data in various systems used by division. Participate in work groups with other campus Banner leads (Student, Student Accounts, Advancement, Business Systems) to coordinate on data standards, usage of shared data, and integration of Banner Financial Aid with Banner and other campus software systems. Develop and maintain IT project schedules for Office of Financial Aid and University Scholarships to establish project priorities with the Financial Aid Banner Lead/Associate Director of IT. Analyze business practices and recommend new software systems to increase efficiency and streamline processes. Identify if system modification or new application development is required. Document and diagram Financial Aid IT processes. Create and maintain an up-to-date repository of Financial Aid IT process documents. Analyze Banner Financial Aid security requests, and serve as the liaison to ITS to ensure appropriate access is granted. This position will create security classes with appropriate objects and authorize access based on user role and supervisor approval Provide training on new software to financial aid and university scholarships as well as units managing scholarships across campus who may need assistance .
Type of Position	Full Time Position
Staff/Non-Faculty	Staff/Non-Faculty
VISA Sponsorship?	VISA sponsorship is not available for this position. All candidates must be eligible to work and live in the U.S.
Appointment Type	1.0
Work Schedule/Hours	Monday-Friday 8am to 5pm with occasional nights and weekends as needed to meet deadlines and attend meetings and conferences
Number of Hours Per Week	40
Number of Months Per Year	12
Mandatory Staff	Yes
Suggested Salary Range	60,000 - 66,072
Physical Demands of Position	To perform this job successfully, an individual must be able to perform each essential job duty satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform essential job functions.

Posting Details Information

Posting Date	03/06/2026
Closing Date	03/19/2026
Open Until Filled	No
Evaluation of Applications Begins	03/09/2026
Proposed Date of Hire	04/13/2026
Special Instructions to Applicants	Please submit the following required documents: Cover Letter Resume List of 3 references
Search Chair Name	Kenneth Kirksey
Search Chair Email	kirkseykb1@appstate.edu
Quick Link	https://appstate.peopleadmin.com/postings/53470
Posting Number	201501739P

Supplemental Questions

Required fields are indicated with an asterisk (*).

Applicant Documents

Required Documents

Resume
Cover Letter / Letter of Interest
List of References with Contact Information

Optional Documents

Contact Us:
Office of Human Resources
330 University Hall Dr.
Boone, NC 28608
Phone: 828-262-3187
Fax: 828-262-6489

HRS Home
Student Employment
Temporary Employment

UNC Wide Employment
NC State Agencies Employment

To ensure the security of your data, you will be logged out due to inactivity in 3 minutes at
.

Any data not saved will be lost.

Click 'OK' to keep your session active.

Original Job Description