The position of Sr. Programmer / Analyst will be responsible for providing applications support for our ERP and CRM Platforms (BANNER, CRM Advance, Slate), various related systems as well as some database and web programming. The position requires knowledge of several functional departments within a college or university setting and a clear understanding of how to apply BANNER to improve workflow and office function efficiency.
This position will be responsible for consulting with appropriate management regarding application needs and objectives, proactively addressing customer's application support needs while exercising efficient time management. Specific responsibilities include developing programs to support the College's administrative offices, with other support duties as assigned.
Responsibilities will include, but are not limited to:
Customer Engagement, Business Support, & Planning – 30%
Consults with customers to gather information about program needs, objectives, functions, features, and input and output requirements.
Researches and evaluates software and hardware to assist in programming or to use as program platforms.
Develops and maintains plans outlining steps and schedules for developing programs.
Trains end users or technical support staff to use programs.
Analyzes, defines, and documents requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks and controls, and outputs.
Writes and maintains technical specifications.
Writes and maintains documentation to describe program development, logic, coding, testing, changes, and corrections.
Customizes and codes screen layouts, graphical user interfaces, printed outputs, and interfaces with other systems.
Converts designs and specifications into computer code. Compiles code into programs and corrects errors detected in compile process.
Creates test transactions and runs tests to find errors and confirm programs meet specifications.
Installs and tests programs.
Maintenance – 25%
Analyzes code to find causes of errors and revises programs. Consults with customer to prototype, refine, test, and debug programs to meet needs.
Writes documentation or reviews documentation written by others that describes installation and operating procedures.
Provides technical assistance by responding to inquiries from others regarding errors, problems, or questions about programs.
Monitors performance of programs after implementation.
Other Duties As Assigned – 5%
Education / Experience:
Bachelor’s degree in Computer Science, Information Technology, or a related field from a four-year college or university and at least five years of related experience or the equivalent combination of education and experience.
Competencies / Skills:
Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.
Ability to write reports, business correspondence, and procedure manuals.
Ability to effectively present information and respond to questions from groups of managers, customers, customers, and the general public.
Ability to define problems, collect data, establish facts, and draw valid conclusions.
Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Proven ability to provide the highest levels of interpersonal communications with sensitivity to and understanding of the demands of a higher education environment
Strong Oracle SQL and PL/SQL programming (PL/SQL web programming is a huge plus)
Other Oracle tools (import/export, SQL*Loader)
Proficiency in working in Linux and Windows environments
Working knowledge of Waterfall SDLC methodology
Proficiency using Microsoft Access and Excel
Proficiency in Database design concepts
Unix – RedHat, Solaris, HP/UX, or other
Excellent Requirements Gathering
Excellent customer service skills
Excellent problem solving skills
Oracle 12c, 18c, 19c
Ellucian Banner 9.x experience
PL/SQL Web programming
Java based programming (ex: Groovy, Grails)
Microsoft SQL Server
Unix Shell scripting
3rd party software install/configuration
Oracle Web Packages
Supervision of Employees:
Physical and Mental Demands:
Normal sitting, standing, and walking throughout the course of the day.
Periods of extended computer usage.
40 hrs per week, 12 months per year
Special Conditions for Eligibility:
Evening and weekend flexibility as needed for releases, upgrades, implementations, and on-call rotation.
It is the policy of St. John Fisher College to provide Equal Employment Opportunity to all employees and applicants for employment in accordance with the applicable federal, state, and local laws governing non-discrimination in employment in each locality in which the College has employees.
The College does not discriminate against applicants or employees in hiring, promotion, termination or the terms and conditions of employment on the basis of race, color, religion, gender, sex, perceived sex, gender identity, gender expression, the status of being transgender, sexual orientation, national origin, citizenship, age, disability, marital status, military status, veteran status, predisposing genetic, characteristics or genetic information, arrest or conviction record, status as a victim of domestic violence, or any other characteristic protected by law.
The Title IX Coordinator is the designated College official with primary responsibility for coordinating compliance with Title IX and related federal and state laws. The Title IX Coordinator, Meg Flaherty, Ph.D., can be reached by phone (585-385-8232), email (firstname.lastname@example.org), in-person in Campus Center 206, or outside of business hours by contacting the Office of Safety and Security (585-385-8111).
Internal Number: 1976
About St. John Fisher College
St. John Fisher College is an independent, liberal arts institution in the Catholic tradition of American higher education. The College emphasizes liberal learning for students in traditional academic disciplines, as well as for those in more directly career-oriented fields. We are committed to enriching the work, teaching and life experiences for all faculty and staff, in support of the College’s mission. Human Resources is dedicated to providing high quality service with a true sense of personal value for all faculty, staff and their families and consistently meeting or exceeding expectations in all human capital disciplines. Mission: St. John Fisher College is a collaborative community dedicated to teaching, learning, and scholarship in a student-centered educational environment. The College is guided by its liberal arts tradition and its Catholic heritage, as expressed in the motto of its founders, the Basilian Fathers: “teach me goodness, discipline, and knowledge.” Fisher engages individuals in lives of intellectual inquiry, professional integrity, and civic responsibility, where diversity and service to others are valued and practiced.