Full-Time EDP Systems Analyst III (Programmer/Analyst); Information Technology, Management Information Systems; 37.5 hours per week; AFSCME Unit I Position

Position Summary: The Programmer/Analyst is primarily responsible for support of and projects related to our Ellucian Banner information system (utilizing an Oracle database), reporting systems, and related applications. 

RESPONSIBILITIES: 

Responsibilities include, but are not limited to:

1. Develop an understanding of current business processes and how the Banner system enables those processes;
2. Analyze current business practices for process improvements;
3. Develop and implement innovative solutions for improvement within existing framework;
4. Work on all phases of the development process, including requirements gathering, work effort estimates, program development, testing and implementation;
5. Development and maintenance of Oracle database tables, views, procedures, functions, packages, and triggers using PL/SQL;
6. Create end users reporting solutions using SQL reporting tools;
7. Analyze and troubleshoot existing reporting or programming code and correct/update errors as required;
8. Create and maintain user, technical and operational documentation that describes program source/logic changes and corrections;
9. Provide technical support, consultation and training to functional staff on the appropriate use of programs and systems including Banner Administration, Banner Self Service, and Electronic Forms Software (Dynamic Forms);
10. Participate on committees where technical representation is required;
11. Due to the nature of IT responsibilities, occasional work outside of normal business hours will be required;
12. Performs other related duties as assigned

The Classification Specification is available at: https://www.mass.edu/shared/classificationspecs/specspers/EDP Systems Analyst.doc

MINIMUM QUALIFICATIONS: 

• Applicants must have at least (A) four years of full-time, or equivalent part-time, professional experience in electronic data processing of which (B) at least two years must have been in work in which the major duties included computer systems analysis, or (C) any equivalent combination of the required experience and the substitutions below.

  SUBSTITUTIONS:

I.     An Associate's degree with a major in the field of data processing or computer programming may be substituted for a maximum of one year of the required (A) experience.*

II.     A Bachelor's degree with a major in the field of data processing or computer and/or information science may be substituted for a maximum of two years of the required (A) experience.*

III.     A Graduate degree with a major in the field of data processing or computer and/or information science may be substituted for a maximum of two years of the required (A) experience.*

IV.     A diploma for completion of a two year full-time, or equivalent part-time, program in a recognized non-degree granting business or vocational/technical school above the high school level with a major in the field of computer programming may be substituted for a maximum of one year of the required (A) experience.*

V.     An official transcript from a recognized business or vocational/ technical school as evidence of completion of a program consisting of at least 650 hours of instruction in the field of computer programming may be substituted for a maximum of one year of the required (A) experience.

VI.     Graduation from the data processing course of a recognized vocational/technical high school may be substituted for a maximum of one year of the required (A) experience.

*Education toward such a degree or diploma will be prorated on the basis of the proportion of the requirements actually completed.

NOTE:     No substitution will be allowed for more than two years of the required (A) experience.

NOTE:     No substitution will be allowed for the two years of the required (B) experience.

• Experience in ERP applications maintenance and support;
• Experience with analysis, development, and implementation of new software systems and business processes;
• Experience with databases, creating objects, such as tables, views, functions, and procedures to address customer needs where necessary;
• Experience writing advanced SQL scripts with reporting tools such as Oracle SQL Developer, PL/SQL Developer, Toad, Argos;
• Strong analytical and problem-solving abilities;
• Excellent written, verbal, organizational, and presentation skills;
• Must be willing to learn and try new tools and approaches, take risks, and stay current in application software knowledge.
• Ability to set and change priorities amongst multiple competing constituencies, projects, and resources.

PREFERRED QUALIFICATIONS:

• Experience working with Ellucian Banner Higher Education Software in at least one of the Banner modules (e.g. Student, Financial Aid, Accounts Receivable, Finance, or Human Resources);
• Knowledge in third party systems, i.e., Degree Works, Destiny One, EAB Navigate
• Experience with PL/SQL, Oracle DB, and Linux/Unix operating systems;
• Experience with Oracle Application Express (Oracle APEX);
• Project management experience.
• Bilingual (English/Spanish)
• Experience working with and supporting a culturally diverse population 

BACKGROUND CHECK: Candidates will be required to pass a CORI and SORI check as a condition of employment.

COVID VACCINATION: Candidates for employment should be aware that all Northern Essex Community College students, faculty and staff have been fully vaccinated since January 3, 2022. Accordingly, initial employment is dependent upon receipt and verification of full vaccination status records; details of how to fulfill vaccine record verification requirements will be provided during the hire and onboarding process.

SALARY: $2,558.62 - $3,617.91 biweekly ($66,524.12 - $94,065.66 annually), Grade 23. An appointment from outside the bargaining unit (AFSCME) must start at Step I of the range. Complete fringe benefit package including competitive health insurance, free 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

ANTICIPATED START DATE: ASAP

Apply Online