Senior Programmer/Analyst-Admissions--Middlebury College

The Senior Programmer/Analyst-Admissions will design, analyze, code, document, and implement applications that support and enhance our campus Oracle-based administrative system, Banner and associated systems. This includes on-going support of these applications. This position is also responsible for custom application and report creation and maintenance, with a primary focus on critical advanced report creation, primarily using Hyperion, for functional areas. While not limited to this area, this position holds primary responsibility for being the key contact for the Banner admissions sub-module and associated modules (including Student and Financial Aid) in support of our undergraduate, graduate and affiliate, Monterey Institute. Responsibilities include:

• Must be able to work cooperatively with others and accept direction from supervisors.
• Participate in installing purchased systems, programming in-house applications, integrating and testing applications, and if required, 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 trainings.
• Create database views, scripts, triggers and stored procedures.
• Proven ability to 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 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, 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, but a particularly deep knowledge-base is expected in the areas comprising the admissions sub-module (prospect inquiry, electronic application process, admissions decisions, entry requirements, SAT and ACT test scores tape loads, deposits, accounts receivable, financial aid, matriculation, electronic registration).
• 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.
• Performs other duties as assigned.

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. The ability to work well with people from different academic and administrative disciplines with varying degrees of technical experience and knowledge. Strong functional and technical/back-end knowledge of Banner system required. A background in higher education is also highly desirable. 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 and UNIX 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, HTML, XML, and HTTP servers is helpful.