General Information

Position Title: Senior Programmer/Analyst (student)
Control Number: 000204
Reports To: 001101
Position Title Department Name
Manager of Administrative Systems Library and Information Services
Department Name: Library and Information Services
Location: Library and Information Services
Date Prepared: AUG-07
Exempt: Yes

Primary Purpose

Design, analyze, code, document, and implement applications that support and enhance our campus Oracle-based administrative system, Banner.  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 Brio, for functional areas.  This position holds primary responsibility for being the key contact for advancement and Banner student modules, particularly at cross-over points with other functional areas.

Responsibilities

Works cooperatively with others and accepts 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 store 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.

  As Senior Programmer/Analyst works closely with other Programmer/Analysts to deliver timely and cost-effective solutions.  Must have strong communication and organization skills. 

  Work in partnership with the functional leads in the various departments affected by the Banner student module.

  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.

  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:

A coherent team of programmers who are provided guidance and supervision.
Well documented code that meets a set of uniform standards.
Data that is valid, consistent and secure.
Aplications 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 need to support the operations of the College. 
Applications that are reliable.

Education & Training

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

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 Student system required and Banner Advancement desired.  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. 

Must have logical, analytical, and problem-solving skills. Must have good interpersonal communication skills.

Knowledge

Other

Must have logical, analytical and problem-solving skills.  Must have good interpersonal communications skills.  Must have at least moderate typing skills.
Gateways For: