Division/Department: Office of Business and Finance/Student Financial Services
Reports To: Associate Vice President for Student Financial Services
Leads technology and reporting efforts for the Student Financial Services division. The Programmer Analyst role is defining, developing, testing, analyzing, and maintaining the Ellucian Banner ERP system (financial aid and AR modules) and current and new software applications supporting the achievement of Student Financial Services operational requirements. This includes writing, coding, testing, and analyzing software programs and applications. The Programmer Analyst will also research, design, document, and modify software specifications throughout the production life cycle, per the SFS team requests to develop reports, apply and test vendor-delivered patches, and ensure data integrity. Additionally, this position assists the AVP in ensuring compliance with all federal, state, and institutional regulations and policies and will support the AVP with the operational needs as related to the areas of technology and compliance.
Essential Duties and Responsibilities
- Collaborate with central ITS developers, programmers, and designers in conceptualizing and developing new software programs and applications for the financial aid and student AR operations.
- Excellent understanding of coding methods and best practices
- Extensive relational database and operating systems experience
- Oversees the management and maintenance of computer systems used in student financial services functions.
- Design systems, processes, procedures, and methods for implementing modifications to existing financial aid and student account applications and third-party vendor software to increase operational efficiency and effectiveness
- Write programs and procedures to implement designed enhancements
- Coordinate implementation of system enhancements, including consultation with end-users to assess and test techniques and document procedures.
- Participate in project teams and serve as a technical liaison to facilitate other systems-related activities.
- Liaise with central ITS network administrators, systems analysts, and software engineers to resolve problems with software products or College software systems.
- Oversee the SFS Production calendar's coordination to coordinate Student Financial Services processes that merge timelines of production jobs with operations conducted by other key areas (registrar, housing, admissions).
- Train end-users to operate new or modified programs, reporting tools, and application systems
- Support the financial aid and student account modules of application systems, including but not limited to EDExpress, ED Connect, COD, federal CPS, NSLDS, Georgia Futures, Argos, BDM, Self Service Banner, Luminis, Ellucian Workflow.
- Provide explanations of exceptions to normal processing, which requires researching, recording, and tracking financial aid and student account processing errors.
- Create audit reports that review all financial aid and student accounts processing and transactions using Banner and vendor reports to identify exceptions to normal processing (e.g., missing transactions, transactions with incorrect detail codes, duplicate transactions, and other problems). Lead the data gathering and submission process for IPEDS reporting.
- Other duties as assigned
Required Knowledge, Skills, and Abilities
- A bachelor's degree in Computer Science or Information Systems
- Strong commitment to customer service
- Collaborative, holistic approach to problem solving
- Must be analytic, organized, innovative, detail-oriented, and able to multi-task
- Experience in using various programming languages with demonstrated success in software development. UNIX/Linux skills and shell scripting experience preferred
- At least four years' experience demonstrating proficiency in relational databases (Oracle), SQL/PL SQL, preferably with the Ellucian Banner Financial Aid module.
- At least two years' experience using reporting and/or data visualization tools, Argos experience preferred.
- Must not be in default on federal student loans and have the ability to access federal student aid databases (NSLDS, COD, FAAaccess)