Technical ERP Systems Analyst

Job Description:

POSITION: Full-Time Technical ERP Systems Analyst (Staff Associate): Information Technology Services; Haverhill Campus; 37.5 hours per week; Non-Unit Professional Position.

SUMMARY: The Technical ERP Systems Analyst provides advanced systems analysis, database administration support, technical support and complex integration management for the Ellucian Banner Student module and related ecosystems. Acting as the IT Liaison for Admissions, Financial Aid, Student Accounts, and the Registrar's Office, this position ensures seamless data synchronization between Banner and critical edge applications including Ellucian Degree Works, and Nelnet Campus Commerce.

A primary duty of this role is evaluating business workflows and designing solutions that align strictly with Ellucian's baseline product standards and industry best practices. The analyst utilizes structured business process modeling techniques to identify manual inefficiencies, guiding departments to adjust their administrative workflows to fit native ERP capabilities, thereby eliminating custom code and maintaining native system stability.

RESPONSIBILITIES:

The responsibilities include, but are not limited to the following:

Business Process Analysis & Continuous Optimization

• Conduct Functional Discoveries. Lead discovery sessions with Admissions, Financial Aid, Student Accounts, and Registrar end-users to deconstruct, document, and map current "as-is" operational workflows.
• Gap Analysis & Re-engineering. Perform formal gap analysis to identify administrative bottlenecks, data redundancies, and manual interventions across student offices.
• Design "To-Be" Technical States. Author functional specifications and data flow diagrams that transition manual business processes into automated, out-of-the-box Banner configurations.
• Enforce "Vanilla" Architecture Standards. Evaluate incoming departmental requests while proposing a "no-customization" solution by mapping operational needs to baseline Ellucian configurations.
• Remediation Planning. Systematically evaluate legacy, custom modifications and define technical pathways to decommission them in favor of native Ellucian functionality.

Integration Engineering & Ancillary Application Management

• Manage and optimize bi-directional data exchanges between Banner Student and 3rd party integrations, ensuring data accuracy.
• Maintain the technical infrastructure of Ellucian Degree Works to include maintaining direct synchronization with Banner Student academic records.
• Support real-time payment integrations and file transfers between Banner Accounts Receivable and Nelnet Campus Commerce for student billing, payment plans, and cashiering.

Technical Systems Support & Baseline Configuration

• Serve as primary technical tier-3 support for Banner Student, Financial Aid, and associated Self-Service applications, diagnosing database exceptions, job submission errors, Linux Crontab job automations.
• Collaborate with database administrators (DBAs) to manage patches, test regulatory upgrades, and validate system fixes, ensuring zero disruption to baseline system functions.

Advanced Data Analysis, Scripting & Compliance

• Develop and optimize complex SQL queries, PL/SQL packages, functions, and triggers to perform data auditing and cross-system validation.
• Build automated scripts to monitor data integrity anomalies across systems proactively identifying sync errors before they impact students.
• Monitor and maintain Crontab job scheduler to ensure jobs are running as expected.

Requirements:

MINIMUM QUALIFICATIONS:

• Bachelor's Degree in Computer Science, Software Engineering, Information Technology, Business Analysis, or a heavily quantitative discipline.
• ERP Experience: 3+ years of technical systems experience working directly within Ellucian Banner Student (Oracle database environment) or similar ERP.
• Advanced proficiency in Oracle SQL and PL/SQL developer tools (e.g., TOAD, SQL Developer) for querying, scripting, and structural debugging.

PREFERRED QUALIFICATIONS:

• Degree Works Administration: Direct technical familiarity with Degree Works architecture, including the extraction of student audits and localized UCX table configurations.
• Professional certifications in Business Analysis (e.g., IIBA Certified Business Analysis Professional - CBAP, or PMI-PBA).
• Experience utilizing process mapping software (e.g., Microsoft Visio, Lucidchart, or Miro) to present process maps to executive stakeholders.
• Hands-on technical experience with Ellucian Ethos Integration components, or data-integration middleware tools.
• Bilingual (Spanish/English)
• Experience working with and supporting a culturally diverse population

EQUIVALENCY STATEMENT: Applicants who do not meet the qualifications as noted above are encouraged to put in writing precisely how their background and experience has prepared them with the equivalent combination of education, training, and experience required for the responsibilities of this position.

CONDITIONS OF EMPLOYMENT:

• All candidates must have legal authorization to work in the United States. Northern Essex Community College does not provide employment-based visa sponsorship.
• Employment is contingent upon the successful completion and review of a background check which will include CORI (Criminal Offender Record Information) and SORI (Sex Offender Registry Information).

Additional Information:

SALARY: Anticipated starting salary range is $90,000.00 - $105,000.00 annually with complete fringe benefit package including competitive health insurance, dental insurance, basic life insurance, long-term disability insurance, paid sick, vacation and personal leave, educational benefits for employee/spouse/dependents, and excellent retirement benefits. Official transcripts will be required at the time of hire.

ANTICIPATED START DATE: ASAP

Application Instructions:

TO APPLY: To be considered for this position click on the "Apply Now" button, you will be prompted to set up a new account or login to an existing account. You will be able to upload the following required documents for consideration:

• Cover Letter, describing your qualifications and/or how you may be best suited for the role
• Resume/CV

Review of applications will begin 5 business days from the posting date and will continue until the position is filled.

Please note that finalist candidates will be asked to provide contact information for three (3) professional references, including current supervisor (or at least two previous supervisors)

DEADLINE: Open until filled

Northern Essex Community College is an affirmative action/equal opportunity employer and does not discriminate on the basis of race, color, national origin, sex, disability, religion, age, veteran or military status, genetic information, gender identity, or sexual orientation in its programs and activities as required by Title IX of the Educational Amendments of 1972, the Americans with Disabilities Act of 1990, Section 504 of the Rehabilitation Act of 1973, Title VII of the Civil Rights Act of 1964, and other applicable statues and college policies. The College prohibits sexual harassment, including sexual violence. Inquiries or complaints concerning discrimination, harassment, retaliation, or sexual violence shall be referred to the College's Affirmative Action Officer/Title IX Coordinator, Elizabete Trelegan (Assistant Director of Human Resources, B-219,978-556-3928/ etrelegan@necc.mass.edu), the Massachusetts Commission Against Discrimination, the Equal Employment Opportunities Commission or the United States Department of Education's Office for Civil Rights. Northern Essex Community College will provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer.

Prospective employees are encouraged to review the College's Annual Security Report (ASR), in compliance with the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, which can be found on the disclosure page of the College's website at: http://www.necc.mass.edu/clery