Web Application Developer/Site Administrator

Department Summary

Business Affairs provides efficient and effective business services for University of Oregon (UO) students, faculty, and staff; manages and secures UO material assets; and ensures UO business is conducted in accordance with all applicable regulations, policies, procedures, Generally Accepted Accounting Principles (GAAP), and sound business practices.

Business Affairs consists of 5 divisions reporting to the Associate Vice President for Business Affairs/Controller and provides direct services to staff, students, and UO departments: Financial Services/Accounts Payable/Travel, Student Financial Services, Payroll, BA Information Systems, and Treasury Operations. These divisions manage one of the largest payrolls in Eugene, support UO supplies & services expenditures totaling more than $500 million, and manage the billing and collection of tuition and fees for more than 24,000 students. BA has approximately 64 FTE and an annual operating budget of $6.6 million.

The Information Systems department provides technical support for office staff, Banner ERP support for campus, eCommerce services for campus, and web application programming and support for units reporting to the Vice President for Finance and Administration (VPFA).

This position is part of the Information Systems unit.

Position Summary

The university relies on web-based applications to engage and inform university constituents and to efficiently conduct its various business functions.

The Business Affairs Web Application Developer/Site Administrator (AP3) develops, maintains, manages, and supports websites and web applications for units under the Vice President for Finance and Administration that improve efficiency in financial and administrative operations.

The incumbent will support websites and applications that have an enterprise-wide impact and serve faculty, staff, students, and the public. Examples include:

• Forms.uoregon.edu (UO workflow Esignature application)
• eCommerce.uoregon.edu (OU online payment application)
• RRS.uoregon.edu (UO Records Retention Schedule)
• DRU.uoregon.edu (National Disaster Resilient University resource library)
• BA.uoregon.edu (Business Affairs website)
• HR.uoregon.edu (Human Resources, Careers, Childcare websites)
• BRP.uoregon.edu (Budget and Resource Planning website)
• Transportation.uoregon.edu (Transportation Services website)
• Surplus.uoregon.edu (UO Surplus Property Website)
• FPM.uoregon.edu (UO Fiscal Policy Manual)

This position collaborates routinely with web developer colleagues across the UO campus to establish and adopt best practices in the following areas:

1. Development tools, libraries, and methods
2. Source code control and documentation
3. Site hosting and administration
4. Cloud, SAAS, database administration and maintenance
5. Integration methods
6. Digital accessibility compliance
7. Testing, troubleshooting, and problem resolution

This position will be familiar with PCI DSS and ensure university e-commerce operations remain PCI compliant.

This position will represent Business Affairs on committees formed to manage campus web hosting, digital accessibility, service advisory boards, and other communities of practice. They will lead sessions and conduct training in specialty areas.

This position serves as primary system architect and site administrator for the UO listener API service and reporting system, which requires an in-depth comprehensive knowledge of PHP, Microsoft SQL Server, NBS QuikPAY hosted payment integration, and the MS Azure hosting environment. They work independently and routinely solve the most complex system issues.

The UO Transaction API service redirects all payment requests generated by the UO e-commerce service to the QuikPAY-hosted payment page where customers securely process credit card or e-check payments. UO typically has about 300 online payment sites hosted on the E-commerce application allowing schools, colleges, and departments to securely accept payment for events and products at minimal cost. The UO Transaction API service also allows web developers in university departments to programmatically send payment requests that are redirected to the QuikPAY-hosted payment page. Provides Real-Time Payment Notification (RTPN) that departments use to update internal systems, and Receipt Redirect URL which places the customer on the department's desired landing page post payment. This position ensures that the UO Transaction API captures the correct payment amounts and Banner Index, Account, and Activity codes in the QuikPAY End of Day (EOD) file for processing by the university cashier and generation of the appropriate GL revenue entries for UO departments.

The position serves as co-chair of the QuikPAY Service Advisory Board which ensures service user issues are prioritized and their vision is incorporated in product strategy.

This position is responsible for the integrity of underlying e-commerce transaction reporting data, and continuous improvement of associated application programming methods, techniques, and practices for those systems under their responsibility and warrants understanding the bigger picture to identify cross-functional integration and system impacts.

This position supports the integration of all UO third-party payment providers with the QuikPAY-hosted payment page service. This centralized approach to online payment processing through QuikPAY greatly reduces university payment processing costs and contracting efforts, simplifies merchant banking operations, and reduces the scope and effort for PCI DSS compliance.

This position is the primary system architect and site administrator for the UO Human Resources, UO Careers, and UO Childcare websites and manages the integration of UO Career data with PageUp People - MyTrack third-party Talent Management System.

Minimum Requirements

This classification requires a basic foundation of knowledge and skills in systems analysis and related programming support functions generally obtained by a bachelor's degree in computer science, or an equivalent amount of training and applied experience.

Professional Competencies

Ability to:
• Develop applications using Symfony, YAML, Drupal, PHP, Javascript, HTML, XML, and CSS.
• Use relational database systems such as MySQL, Microsoft SQL Server, Oracle, or Microsoft Access for reporting, data modeling, and SQL programming.
• Use web/application server software, SAAS, and Cloud platforms such as MS Azure and Pantheon.
• Analyze data using reporting tools such as MS Excel, MS Access, SPSS, or SAS.
• Streamline business processes by conceptualizing, designing, and developing information system solutions.
• Develop and deliver technical training for information system owners, end-users, and other constituents.
• Collaborate with a diverse body of faculty, staff, and students.
• Communicate effectively with technical and non-technical staff both orally and in writing.
• Convene user group meetings, gather requirements, present prototypes, solicit user feedback, and manage a project schedule.
• Apply data security frameworks and controls.
• Comply with W3C accessibility standards, identify and remediate areas of non-compliance.

Preferred Qualifications

• Three years of professional experience developing interactive, database-driven, internet-facing applications.
• Experience administering web services on a LAMP stack.
• Experience with PHP/Symfony/Drupal administration, replication, and version control.
• Experience administering and tuning My SQL databases and REST APIs.
• Experience building commerce applications that accept online payment.
• Familiarity with and experience complying with the Payment Card Industry Data Security Standards.
• Experience analyzing business processes and creating efficient workflows.
• Familiarity with and experience complying with W3C Accessibility Guidelines.