Position Summary

The Analyst/Programmer is responsible for supporting, maintaining, and enhancing university administrative applications, business processes, and system integrations. This position works collaboratively with university departments and Information Technology Services personnel to develop technical solutions, automate operational processes, maintain data integrations, and support the institution's administrative systems.

Essential Duties and Responsibilities

1. Transact and Illumia Systems

Support and maintain operational processes associated with the university's Transact and Illumia systems, including application integrations, data processing, reporting, troubleshooting, and ongoing system maintenance. Develop and maintain scripts and automated processes to ensure accurate and reliable daily operations.

2. Business Office Support

Collaborate with the Business Office and other university departments to develop, maintain, and enhance reports, SQL queries, scripts, scheduled jobs, and automated processes supporting daily financial and administrative operations. Maintain and execute Transact processes associated with housing door assignments, Flex Cash, and Cam Cash. Analyze business requirements and implement technical solutions to improve operational efficiency, data accuracy, and reporting capabilities.

3. Banner ERP and Operational Data Store (ODS)

Develop, maintain, and support programming processes, SQL queries, reports, data extracts, and integrations involving the university's Banner Enterprise Resource Planning (ERP) system and Operational Data Store (ODS). Assist with data analysis, troubleshooting, and application-related processes supporting university operations. Collaborate with functional departments and technical personnel to ensure the accuracy, reliability, and availability of institutional data.

4. Third-Party Application Integrations

Coordinate the implementation, configuration, and ongoing support of third-party applications requiring integration with university systems. Support application onboarding, data exchange, Single Sign-On (SSO) authentication integrations, and troubleshooting in collaboration with system administrators, software vendors, and campus departments. Assist with testing and validating integrations to ensure compatibility, functionality, and reliability.

5. Application Development and Maintenance

Develop, modify, test, document, and maintain application scripts, including Bash shell scripts and Python programs, SQL queries, reports, scheduled jobs, and automated processes to support evolving university business requirements. Troubleshoot application issues, evaluate existing processes, and identify opportunities for improved efficiency, automation, and system functionality.

6. Technical Support and Collaboration

Provide technical assistance to university departments regarding supported administrative applications, reporting, and business processes. Work collaboratively with Information Technology Services personnel, software vendors, and functional departments to diagnose and resolve application issues, implement enhancements, and support institutional technology initiatives.

7. Documentation and Operational Continuity

Develop and maintain documentation of application configurations, custom scripts, SQL queries, system integrations, scheduled processes, and operational procedures. Ensure appropriate documentation exists to support troubleshooting, knowledge transfer, system maintenance, and continuity of university operations.

8. Other Duties

Perform other related duties as assigned in support of university operations and Information Technology Services objectives.

Knowledge, Skills, and Abilities

• Working knowledge of Linux environments, Bash shell scripting and Python programming, including the ability to develop, maintain, modify, and troubleshoot scripts used for application integration, data processing, and automation.
• Knowledge of application development, programming principles, scripting, and database management.
• Ability to develop, maintain, and troubleshoot SQL queries, reports, and automated processes.
• Understanding of relational databases, data integration, and enterprise administrative applications.
• Familiarity with ERP systems, preferably Ellucian Banner, and institutional reporting environments.
• Understanding of application authentication and integration technologies, including Single Sign-On (SSO).
• Ability to analyze business requirements and translate operational needs into effective technical solutions.
• Strong analytical, problem-solving, troubleshooting, and organizational skills.
• Ability to communicate effectively with technical and nontechnical personnel.
• Ability to work independently, manage competing priorities, and collaborate with university departments and external vendors.
• Ability to develop and maintain accurate technical documentation.

Preferred Qualifications

• Experience supporting administrative applications in a higher education environment.
• Experience with Ellucian Banner ERP and Operational Data Store (ODS).
• Experience developing and maintaining Bash shell scripts, Python applications, SQL queries, scheduled jobs, and automated reporting processes.
• Experience with Transact systems or comparable campus financial transaction and access management applications.
• Experience integrating third-party applications with enterprise systems, including SSO authentication.
• Experience supporting financial, administrative, or student information system workflows.
• Experience with ODS, Cognos, or comparable reporting/data technologies.
• Experience developing or supporting APIs and system integrations.
• Experience supporting HR, Payroll, Finance, or administrative systems.
• Experience supporting enterprise systems in higher education.

PHYSICAL REQUIREMENTS:

Ability to lift objects under 25 pounds including using the upper body to raise objects from a lower position to a higher position; ability to reach including extending the arm and hand; ability to stand for short or extended periods of time; ability to engage in repetitive motions including finger dexterity; ability to speak, hear and see. Ability to crouch, climb and walk stairs.

SALARY RANGE:

Commensurate with qualifications and experience.

INSTITUTION:  Cameron University (www.cameron.edu) is a state-supported regional university located in Lawton, Oklahoma, that offers undergraduate and graduate degrees.  Dedicated to excellence, the university provides a wide range of economic, cultural, and educational opportunities for the betterment of all citizens.  Master's level graduate degrees are offered in business, behavioral sciences, and education; baccalaureate programs are offered in more than forty disciplines, and associate degrees are offered in many other studies.  The close proximity of Fort Sill contributes to an area rich in cultural diversity and provides the opportunity for frequent cooperative efforts.  The combined community of Lawton/Fort Sill has a population of more than 100,000 and is located adjacent to the picturesque Wichita Mountains Wildlife Refuge.

APPLYING:  Applications will be accepted until the position is filled. 

EEO/AA Employer/Vets/Disability

JOB #:  A1202D-26