Programmer and Systems Analyst

Salary: $65,000.00 to $75,000.00 based on ACCS Board of Trustees Salary Schedule C-3 and experience

To support, analyze, and enhance the college's ERP systems with a focus on Banner Student, Financial Aid, Finance, HR, Banner Insights, and integrated technologies. This position plays a critical role in ensuring data accuracy, supporting decision-making, and optimizing processes in a multi-entity environment. This position will use analysis and design techniques to solve business problems using programming, automating processes, supporting ERP users and applications, and evaluating business processes.

The ERP Analyst works collaboratively with Information Technology, Institutional Effectiveness, and key campus stakeholders to translate business needs into data solutions.

* Provide technical and functional support for Ellucian Banner, with an emphasis on the Student module and MEPPD (Multi-Entity Processing and Person Data).

* Design and generate complex queries and reports using SQL (Postgre

SQL and Oracle), supporting departmental needs and institutional reporting.

* Develop and maintain dashboards and analytics in Banner Insights for various business units.

* Analyze business processes and recommend ERP-related improvements to increase efficiency and data quality.

* Serve as a liaison between end users and technical teams to gather, document, and translate functional requirements into technical specifications.

* Troubleshoot ERP-related issues and escalate to Ellucian or internal IT support when appropriate.

* Assist in system testing, patching, and upgrades by coordinating across departments and ensuring smooth implementation.

* Ensure data integrity by supporting audits, performing validations, and reconciling discrepancies.

* Provide end-user training and support for ERP tools and reporting solutions.

* Analyze and assist with all ERP applications: including Ellucian Banner and ancillary systems such as and Degree Works.

* Collaborate with system owners, development, technical support and end users to identify and resolve problems.

* Serve as a DAX verifier of data and assist the IE office in data integrity issues.

* Serve on college committees as assigned.

* Represent the institution in discussions with external parties or partners on ERP-related matters.

* Perform other duties as assigned.

Education:

* Bachelor's degree from an accredited four-year college or university required.

* A combination of education, work experience and certification (s) will be given consideration in lieu of the bachelor's degree.

Experience:

* Minimum of one year of full-time experience with ERP systems required, preferably with Ellucian Banner.

* Experience with Postgre

SQL and Oracle SQL required

* Familiarity with Banner Insights and working in a multi-entity environment (MEPPD) strongly preferred

* Experience in higher education preferred

License:
No special licenses required.

Applicants must meet the minimum qualifications required and must submit a complete application packet through the online application system in order to be considered for a position. Applicants who fail to submit all required information may be disqualified. Only applications received during the period of this announcement will be considered. All application materials must be submitted through the online system. Paper documents will not be accepted by Human Resources.

Please have ALL documents available for uploading at the time of application completion.

A complete application packet consists of the following:

* A completed Jefferson State Community College online application specific to this position

* Current resume

* Transcripts (unofficial copies will be accepted before the deadline but official transcripts must be on file prior to extension of an employment agreement to the successful candidate). Transcripts must include conferred or awarded date.

* Work experience verification
* in writing from your current and/or previous employer(s) confirming the required level of experience as stated in the "Qualifications" section. Verification should include dates of employment, whether full time or part time, and position title(s). Upon request from the applicant, work experience verification from current employer only may be delayed until an official offer of employment. Request must be made in the form of a statement on a separate document.

If applicant delays verification from current employer and it does not cover required level of experience as stated in the "Qualifications" section, verification from previous employer(s) is required. (For clarification, please contact Human Resources.)

* A work experience verification form can be found at Human Resources - Jefferson State Community College. Verification is the responsibility of the applicant. Verification must be completed by the employer and returned to the applicant for uploading with the online application. Do not return the paper form to Human Resources.

Incomplete application packets will eliminate the possibility of an…