Job Description:
Administrative System Programmer/Analyst
Full/Part Time: Full- Time
Regular/Temporary: Temporary
Department: Information Technology Services
About the Position:
*This is a temporary benefited position ending on or before one year from date of hire.*
Reporting to the Director of Administrative Programming and Web Services, the Student Administrative System Programmer/Analyst provides application development and system analysis and planning support of SJSU’s Oracle (PeopleSoft) Campus Solutions-Student Administration applications. The incumbent will focus on providing critical support for SJSU Student Success goals, particularly Retention and Graduation initiative, by improving student advising (and providing better information for student decision making) at time of matriculation and throughout their academic career, reducing number of students taking duplicate or unnecessary course thus slowing time to degree.
The Student Administrative System Programmer/Analyst will be assigned to Undergraduate admissions, with the AVP UGS as the work lead, to support programming and integration needs for Transfer Credit processing and Degree Audit workflow. This individual will partner with the Transfer Credit Analyst/Articulation Officer, the Admin Programming staff, functional subject matter experts from the Student Affairs as well as Academic Affairs to deliver on their programing and support needs. The focus will be transfer credit (TC) and Pre Matriculation/ Impaction programming, testing and enhancements (e.g., implementing and enhancing process to load external subjects/courses for all schools in ASSIST.), Degree Audit and TC programing needs for integration of new modules and functions (e.g., Course Match; ASSIST Next Gen and TES; SB 1440 Degrees.) This individual will also provide programing for forthcoming and related student success initiatives (e.g., Early Alert/Grades First interventions; Course Scheduler; Course Planner; High Impact Practices and Service Learning) to assure all degree audit and student success programing needs are met in a timely manner.
Responsibilities include, but are not limited to:
A) System Analysis and Development
- Use applications software, data structures and utilities, operating systems, and communication interfaces within the SJSU ITS computing environment.
- Apply consultative skills to assess user needs and communicate technology systems and solutions.
- Research and evaluate the functionality of vendor or other CSU campus software to meet user needs, and serve as a technical liaison.
B) Application Programming
- Develop, Test and Implement Transfer credit (TC) and Pre Matriculation/ Impaction programs (People code, PeopleSoft SQRs, SQCs, App Engines) supporting new custom functions as well as enhancements to existing functions.
- Develop Applications supporting Pre-Admissions Processing (e.g., self-service CSU eligibility modeling, Supplemental Application, Validation of Transferable Coursework, Self-Reported Degree Audit etc.)
- Develop, Test and Implement integration of new modules and functions (e.g., Course Match; ASSIST Next Gen and TES; SB 1440 Degrees.) supporting Degree Audit and TC processing needs.
C) Database analysis and access
- Write SQL statements and scripts, SQR programs and use People Tools as required.
- Write and/or modify programs using multiple applications and databases.
Develop efficient database manipulation code to ensure reliable and consistent result sets