Programmer and Systems Analyst

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 (PostgreSQL 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.

Do you have experience in SQL?, Do you have a Bachelor's degree?, 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 PostgreSQL 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.

Pulled from the full job description

• Tuition reimbursement
• Health insurance
• Retirement plan
• Vision insurance
• Dental insurance
• 401(a)
• Wellness program, Salary: $65,000.00 to $75,000.00 based on ACCS Board of Trustees Salary Schedule C-3 and experience

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 interview. It is the sole responsibility of the applicant to ensure his or her application packet is complete. Once submitted, all applications become the property of Jeff State. Requests for copies of application materials, including transcripts, will be denied by the College. The College reserves the right to fill the position within one year of the stated anticipated starting date or not to fill the position due to budgetary or operational considerations. Further, the College reserves the right to fill more than one position in the same job classification should another vacancy occur during the search process. If you are applying for one or more positions, you must submit a separate application packet for each position. In accordance with Alabama Community College System policy and guidelines, the applicant chosen for employment will be required to sign a consent form for a criminal background check. Employment will be contingent upon receipt of a clearance notification from the criminal background check. Jefferson State Community College is an active participant in the Employment Eligibility Verification Program (E-verify). E-verify electronically confirms an employee's eligibility to work in the United States as required by the Department of Homeland Security. All male applicants between the ages of 18-26 must provide proof of Selective Service Registration. Jefferson State Community College is an Equal Opportunity Employer. It is the official policy of the Alabama Community College System, that no person shall, on the grounds of race, color, disability, gender, religion, creed, national origin, or age, be excluded from participation in, be denied the benefits of, or be subjected to discrimination under any program, activity, or employment. Jefferson State Community College will make reasonable accommodations for qualified disabled applicants or employees. If you have a disability and require accommodation, please notify us. Applicants must adhere to the College's prescribed interview schedule and must travel at their own expense. The College reserves the right to withdraw this job announcement at any time prior to the awarding.