Systems Analyst

Military, Veterans and Diverse Job Seekers; West Palm Beach (FL); On-site; USD 45,000 - 65,000; Full time

Job summary

Military, Veterans and Diverse Job Seekers is seeking a Financial Aid Support Specialist to assist with reporting, data analysis, and system integrations for the college’s Financial Aid office. The role involves SQL Server reporting, SSIS automation, and file transfers with vendors.

Responsibilities include handling complex queries, documenting applications, and supporting PowerFaids and related tools to ensure accurate data and smooth operations for student financial aid processes.

Qualifications

• Bachelor's degree or 1–2 years related experience or equivalent.
• Strong analytical and communication skills.
• Proficiency with SQL Server and Microsoft Office.

Responsibilities

• Research and prepare reports and statistical analysis for the Financial Aid office using SQL Server Reports Services.
• Develop workflows and automate processes using SSIS.
• Transfer files to and from vendors using SFTP.
• Create and maintain systems integrations to ensure data accuracy.
• Respond to requests for complex queries from the college database, gather and perform initial data analysis.
• Document computer applications written for the Financial Aid areas.
• Evaluate and implement new system functionalities.
• Support PowerFAIDS system and other tools for Financial Aid operations.
• Identify, troubleshoot and rectify student financial aid applications problems.
• Assist with special projects and documents processing.
• Support staff with forms, applications, data, workflows, etc.

Skills

SQL Server

Visual Studio

Microsoft Office

Analytical skills

Written and verbal communication

Initiative

Education

Bachelor's degree

Experience in related field

Tools

PowerFaids

SQL

Jenzabar

Perceptive Content

Job description

• Research and prepare reports and statistical analysis in support of the Financial Aid office using SQL Server Reports Services.
• Conduct research and resolve problems in relation to processes, and monitor processes to determine areas for improvement.
• Create workflows and automate processes using SQL Server Integration Services (SSIS).
• Transfer files to and from vendors using multiple technologies such as SFTP.
• Create and maintain systems integrations to ensure data accuracy.
• Respond to request for complex queries from the college database system, gather, compile and perform initial data analysis.
• Develop systematic documentation of computer applications written for the Financial Aid areas.
• Evaluate and put into practice new systems functionalities.
• Provide the Director of Technical Operations on emerging technology challenges and opportunities with respect to the PowerFAIDS system and other system tools to support the Financial Aid functions.
• Identify, troubleshoot and rectify student financial aid applications problems working with IT and/or other functional areas, and with outside consultants to solve procedural, operational and technical problems.
• Assist with or performs special projects as assigned.
• Assist with documents processing.
• Support SFS staff members with forms, applications, data, workflows, etc.

Required knowledge, skills, and abilities

• SQL Server, Visual Studio
• Microsoft Office Suite
• Strong analytical skills.
• Written and verbal communication skills.
• Initiative

Preferred

• PowerFaids, SQL, Jenzabar and Perceptive Content knowledge.

Minimum Qualifications

• Bachelor's degree (B. A.) from four-year college or university; or one to two years related experience and/or training; or equivalent combination of education and experience.