Financial Aid Systems Analyst

Sdccdjobs; San Diego (CA); On-site; USD 70,000 - 90,000; Full time

Job summary

Sdccdjobs is seeking a Financial Aid Systems Analyst in San Diego, CA. This role requires significant experience as a Technical Analyst within higher education, specifically with financial aid systems.

The successful candidate will enhance systems, manage integrations, and ensure compliance with regulations. A bachelor's degree is required alongside at least five years of relevant experience. Training and support for the diverse student population is emphasized in the role.

Qualifications

• Minimum of five years of experience as a Technical Analyst, Systems Analyst, or similar role in Financial Aid.
• Strong experience writing SQL queries including complex joins and transformations.
• Experience with reporting tools and APIs for data integrations.

Responsibilities

• Support financial aid systems and processes within the ERP system.
• Gather and document business requirements for system enhancements.
• Perform data validation and reconciliation for integrations.

Skills

Technical Analyst experience

SQL querying skills

Reporting tools experience

Groovy or Java knowledge

Batch processing frameworks

Knowledge of financial aid regulations

API and data integration

Business requirements documentation

Project tracking tools

User support and issue resolution

Education

Bachelor's degree or equivalent experience

5 years PeopleSoft or ERP experience

Tools

Oracle BI Publisher

PeopleSoft Query

Microsoft Project

JIRA

Job description

Applications are currently being accepted for the Financial Aid Systems Analyst position in the IT Applications Programming team, located at 9315 Hillery Drive, San Diego, CA 92126. Hours are 8 a.m. to 5 p.m. Selected candidate must be willing to adjust work days/hours based on the department’s needs. Please note that an employee may be transferred to any site at the option of the Chancellor.

Desired Qualifications

• Minimum of five (5) years of experience as a Technical Analyst, Systems Analyst, Programmer Analyst, Business Analyst, or Technical Liaison supporting Financial Aid within a higher education ERP / SIS environment, preferably with Oracle Student Financial Aid (SFA – SAE / SFP) or PeopleSoft Campus Solutions.
• Strong experience writing SQL queries, including complex joins, subqueries, aggregations, and data transformations for analysis, reporting, and troubleshooting.
• Experience with reporting and query tools such as Oracle BI Publisher, PeopleSoft Query, or equivalent ERP / SIS reporting platforms.
• Experience or working knowledge of Groovy scripting in Oracle SFA, or comparable experience with Java or similar programming/scripting languages.
• Experience supporting or administering batch processing frameworks, including scheduling jobs, job sets, and run controls (e.g., PeopleSoft Process Scheduler or similar tools).
• Working knowledge of ERP / SIS modules and data structures, including:
  • Student biographical/demographic data
  • Enrollment and academic records
  • Student Financials
  • Financial Aid-related financial transactions
• Working knowledge of federal and state financial aid regulations, including:
  • Title IV programs
  • ISIR processing
  • Packaging and disbursement
  • Satisfactory Academic Progress (SAP)
  • Return to Title IV (R2T4)
  • California Student Aid Commission (CSAC) programs (e.g., Cal Grant)
• Experience supporting system integrations and data exchanges, including working with APIs, web services, or file-based integrations (XML, JSON, flat files), and performing data validation and reconciliation.
• Demonstrated experience working with functional users to:
  • Gather and document business requirements
  • Develop detailed functional and technical specifications
  • Create and execute test plans and test scripts
  • Support User Acceptance Testing (UAT) and defect resolution
• Experience participating in or supporting project implementations, including maintaining project plans and tracking tasks using tools such as Microsoft Project, JIRA, or similar.
• Ability to manage work assignments, maintain work logs, and provide regular (e.g., weekly) status updates to management and stakeholders.
• Experience responding to inquiries and resolving issues for internal users and external partners, including state and federal agencies.
• Ability to develop and maintain business process documentation, technical documentation, and training materials.

Training and Experience

• Any combination of training and experience equivalent to a bachelor’s degree.
• Equivalent experience should include a minimum of 5 years PeopleSoft or ERP experience.

Foreign Degrees

Applicants with foreign degrees from colleges or universities outside of the United States must have their coursework evaluated by a professional association that is a member of the National Association of Credential Evaluation Services (NACES) or Academic Credentials Evaluation Institute, INC (ACEI). A copy of the evaluation must be submitted with your online application.

EEO and Diversity Statement

All applicants must have demonstrated cultural competency and sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds of community college students, faculty and classified professionals.