Job: Senior Programmer Analyst

Jobing Description

Job Description:

Primary Purpose

The Senior Programmer/Analyst will analyze, design, code, document, and implement applications that support and enhance our Oracle-based administrative system, Banner ERP environment and associated systems. Responsibilities include the on-going support of these applications and business systems. This position is also responsible for administration of our Hyperion reporting environment including system administration, report creation and maintenance with a primary focus on advanced report creation for functional areas. This position supports all student information system areas related to our undergraduate and graduate programs for Middlebury College and affiliated institutions.

Responsibilities

*

Must be able to work cooperatively with other technical and functional users and accept direction from supervisors.

*

Participate in installing purchased systems, programming in-house applications, integrating and testing applications, and diagnosing production problems.

*

Undertake custom application development using various languages & tools to support and enhance campus systems, including but not limited to Banner. This includes web-based modules.

*

Develop and modify technical documentation to support operations and training.

*

Create Oracle database tables, views, scripts, triggers, packages and stored procedures.

*

Populate and test rule and validation tables, and develop test scripts.

*

Additional responsibilities include assisting with module security planning and management, testing, software defect management and high-level module functional support, process oversight and scheduling.

*

Must be able to carry out needs assessment, system integration and design support and general change management support.

*

Assist in the designing, planning, development, installation, operations and implementation of ERP applications.

*

As needed, design and create appropriate Oracle tables and views to facilitate the creation of reports.

*

Support report development by campus users who work with institutional information systems and databases by providing expertise, analysis, data modeling, and programming in appropriate languages such as SQL, PL/SQL, JavaScript, and/or SQR to support the development of reports.

*

Applies user-centered design principles.

*

Proactively supports users in the creation of reports from transactional databases and data marts.

*

Work closely with other Programmer/Analysts to deliver timely and cost-effective solutions.

*

Work in partnership with functional leads in the various departments utilizing Banner and Hyperion.

*

While not expected to prioritize departmental initiatives, once a project is approved and drafted, a senior programmer/analyst is expected to manage medium and larger-scale initiatives independently, with limited supervision.

*

Some variability in work schedule may be required to support west coast users.

*

Must demonstrate a willingness and proficiency for learning new development environments, tools, frameworks, and languages.

*

Performs other duties as assigned.

Key Principles:
Library and Information Services is part of an educational community and shares in the responsibility for supporting teaching and learning as part of the College mission. We are committed to the following:

*

Proactive, responsive, respectful service to our constituents

*

Opportunities and expectations for ongoing employee education and development

*

Collaboration within the organization, across the college, and beyond

*

Effective and open communication

*

Understanding the work of our customers

Key Relationships:
With the programming staff of Library & Information Services, with the functional leads in departments, with the leadership of LIS Systems & Infrastructure Cluster Expected Outcomes:

*

Well documented code that meets a set of uniform standards

*

Data that is valid, consistent and secure

*

Applications that are well-supported and meet the needs of end-users

*

Application 'add-ons' and custom programs that create functionality that is needed by end-users

*

An information system which is able to provide end-users with the critical information needed to support the operations of the College

*

Applications that are reliable

Job Qualifications:

Education & Training

Bachelor's degree or equivalent experience in computer programming and systems/database analysis and architecture.

Experience

Excellent written and oral communications skills and strong service orientation. Applicants must display the ability to work well with people from different academic and administrative disciplines with varying degrees of technical experience and knowledge. 3-5 years verifiable Oracle PL/SQL development experience is required. Strong functional and technical/back-end knowledge of Banner system and/or Hyperion is preferred. A background in higher education is also highly desirable.

Knowledge

Working knowledge of network infrastructure components, web based application development tools, prototyping paradigms, security issues and production control. Must have a background in information systems analysis and design, systems integration and implementation and object oriented program design. Must have the ability to deliver quality systems that meet functional specifications on time and within budget. Experience with the following required: Unix/Linux and Unix/Linux shell scripting, Oracle databases and application development technologies (Oracle Forms, Discoverer, ETL tools, etc.), SQL*PLUS, PL/SQL, C, ProC. Experience desired with reporting tools such as Hyperion, TOAD and SQR. Additional experience in data modeling, LDAP, JavaScript, Groovy, Grails, Java, OOP, CSS, HTML, XML, and HTTP servers is helpful.

Other

Must have logical, analytical, and problem-solving skills. Must have good interpersonal communication skills. Must be highly motivated self-starter capable of working both independently and as a member of a team.

Additional Links:
Benefits
Library and Information Services