Programmer Analyst II

Job Description

Programmer Analyst II
Wright State University

EEO Statement: Wright State University is an equal opportunity employer.

Faculty Rank or Job Title: Programmer Analyst II

Job Category: IT

Department: Computing & Telecommunications

EEO number: 26P205

Position FTE: 100%

Minimum Annual or Hourly Rate:

Salary Band: UC S05

Job Summary/Basic Function

The Programmer Analyst II is responsible for supporting and enhancing enterprise business systems. This position documents business and technical requirements, defines project scope and objectives, and determines implementation strategies to achieve institutional goals. The role gathers and prioritizes customer requirements and works closely with functional business areas to ensure service and satisfaction goals are met.

The Programmer Analyst II participates as a team member or leads application development projects across all phases of application design and development, including enhancements, defect resolution, and custom reporting. This role provides technical support for the University's Ellucian Banner ERP suite and related third-party applications, ensuring reliable integrations, data integrity, and effective system functionality.

Minimum Qualifications

• Bachelor's degree in Computer Science or a related field plus 4 years of relevant experience such as working with ERP systems, data integrations, and enterprise application support.
• Strong proficiency in SQL, primarily with Oracle and Microsoft SQL Server (or other relational database platforms).
• Knowledge of best practices when dealing with relational databases.
• Highly skilled in optimizing large and complex SQL statements for performance and reliability.
• Experience with system integrations and APIs supporting ERP platforms and third-party applications in an enterprise environment.
• Proven ability to troubleshoot and resolve common database and data-related issues.
• Strong organizational skills with the ability to manage work efficiently across multiple priorities.
• Effective time management skills with the ability to meet deadlines in a dynamic environment.
• Ability to simultaneously manage several projects with constant concern on details, quality and customer satisfaction.
• Strong critical thinking and analytical problem-solving skills.

Preferred Qualifications

• Master's degree in Computer Science, Information Systems, or a related field.
• Experience working in a higher education environment supporting enterprise systems.
• Experience supporting Ellucian Banner ERP system.
• Experience with Oracle PL/SQL programming, including procedures, packages, triggers, and performance tuning.
• Ability to communicate complex technical concepts effectively to non-technical end users and business units.
• Experience using development and support tools such as Git, ServiceNow, and ETL tools.
• Basic knowledge of Java for supporting or troubleshooting integrations and custom applications.

Essential Functions and percent of time

50%
Provide support and development for enterprise-wide, business-critical IT applications, including the University's Ellucian Banner ERP system, as well as related third-party systems.

• Participate in all phases of the Software Development Life Cycle (SDLC), including discovery, analysis, requirements definition, solution design, configuration, development, testing, deployment, and operational support.
• Analyze business and technical requirements using strong problem-solving skills and apply process improvement methodologies. Determine appropriate technical solutions to resolve issues and recommend system enhancements.
• Design, develop, and maintain complex PL/SQL queries, scripts, triggers, and APIs. Create packages, extensions, and custom reports to support institutional needs.
• Work as a member of a collaborative technical team supporting multiple technology platforms and assisting internal business offices in achieving their business objectives
• Provide technical guidance and support to client and systems areas through consulting, training, and technical documentation related to Banner and integrated applications.
• Demonstrate the ability to manage multiple systems and competing priorities under tight deadlines in a hybrid ERP environment.

20%

• Ability to identify relationships between business challenges and data gaps across systems, and proactively recognize opportunities to improve reporting and application processes. Recommend technical solutions that address existing disparities and add measurable value to the institution.
• Document business processes and consult with functional clients to define requirements and system functionality that meet operational and strategic objectives.

Essential Functions and percent of time (cont'd)

10%

• Collaborate closely with technical and functional team members to perform impact analysis on proposed solutions, evaluating effects on Banner system, integrations, and downstream business processes.

10%

• Stay current with Ellucian Banner and supported vendor applications, including new releases, patches, and emerging functionality. Perform testing, validation, and implementation of releases and patches as directed, ensuring compatibility and stability across Banner environment.

5%

• Provide training, knowledge transfer, and ongoing technical support to team members and functional clients to ensure effective use of Banner and integrated applications.

5%

• Availability to work occasional evenings and weekends as required to support system upgrades, maintenance activities, and critical business processes

Non-Essential Functions and percent of time

 

Working Conditions

Some nights and weekends may be required. Professional office environment. Position requires the individual to be on call for production support as needed. Have the ability to work remotely; requires a quiet, distraction free environment with access to high-speed internet. To preserve the safety and security of the campus community and to maintain the integrity of university operations, it is the policy of Wright State University making an employment offer contingent on various background checks, such as a criminal record, credit history when job related and/or education verifications. Additionally, an administrative review shall be conducted whenever the university learns that an employee is charged with or convicted of a crime (except for minor vehicle violations). Frequently asked questions related to background checks may be found on the Human resources website at http://www.wright.edu/human-resources.Effective July 1, 2017, per Policy 7230 Wright State University is tobacco-free. Tobacco use, including the sale, advertising sampling and distribution of tobacco products and tobacco related items is prohibited in all university facilities, on all university owned or leased grounds, university owned or operated residence halls and apartments, and at all university sponsored events regardless of location. Tobacco use is also prohibited in all university vehicles or on any equipment owned, leased or operated by Wright State University. This policy applies to anyone on campus including students, faculty, staff, visitors, consultants, vendors, patients, volunteers, and contractor employee.

Special Instructions to Applicants

 

First Consideration Date: 04/16/2026

Closing Date:

Open Until Filled: Yes

To apply, please visit: https://jobs.wright.edu/postings/22191