Director, Financial Aid Systems

SUMMARY

Performs application development and analysis functions of the Financial Aid Department's technology and application systems. Creates business processes to meet end-user requirements and Federal, State, District, local, and department regulatory mandates, rules, regulations, policies, and procedures. Evaluates and personally participates in the functions necessary to implement and sustain the creation, maintenance, and use of financial aid databases and applications. Tests and maintains data analysis and reporting programs to enhance and support reporting and data tracking needs.

ESSENTIAL FUNCTIONS

• Designs business processes for the maintenance, access, and retrieval of financial aid data; prepares detailed flow charts and diagrams outlining system capabilities and processes; defines data rules and relationships and develops methods for quality control of the database system
• Reviews and evaluates database access and reporting software applications to streamline and enhance the financial aid enterprise system; creates documentation of processes
• Troubleshoots, updates, modifies and analyzes information systems to ensure compliance with regulatory needs and changes
• Designs methods and applications to import/export data for analysis; uses various reporting tools and database applications to retrieve information from databases for financial aid staff and other staff as needed; determines required data and presentation formats
• Ensures successful storage and retrieval of data across a variety of campus systems; ensures financial aid systems interface with other campus systems
• Creates complex custom queries and programs for a variety of financial aid management needs and reporting requirements; creates queries to analyze and identify data integrity issues
• Monitors and maintains data integrity of financial aid tables, fields, reports, and related systems; works with central information technology to execute scripts to correct data issues
• Provides expert technical assistance and training for financial aid staff on system procedures, system integration, data integrity, and reporting
• Plans, designs, and creates new databases for data collection, analysis, and reporting
• Consults with information technology staff to create views and data blocks for data reporting and extraction
• Coordinates with information technology, finance, and other college staff to facilitate the resolution of implementing and scheduling new and/or modified business processes and the development of new modified database processes and reporting requirements
• Acts as the first-line contact person, representing Financial Aid to internal and external stakeholders who need assistance with any application systems module that integrates with Financial Aid
• In collaboration with the Information Technology department, tests and debugs applications to ensure the accuracy of data and writes related application documentation, including system upgrade testing and end-user documentation
• Communicates with personnel and various outside agencies as needed to exchange information and resolve issues or concerns
• Participates with end users and information technology in testing and implementing new computer programs as appropriate, including developing and maintaining related documentation
• Remains up-to-date with and applies emerging technologies, as necessary, to perform duties in an efficient, organized, and timely manner
• Performs other duties as assigned