Systems Analyst and AI Programmer

About the role

The Systems Analyst and AI Programmer supports the Colgate mission by analyzing needs, providing technical guidance, helping with process improvement, and recommending and implementing solutions for academic and administrative areas of the university.

Responsibilities

• Analyze needs and assess functional needs to help improve processes.
• Provide technical consultation on business processes and how they interact with software systems.
• Translate end user behavior into recommended improvements in features and functionality.
• Lead implementations for new software systems when appropriate.
• Maximize the usefulness and performance of assigned systems and integration points.
• Deploy new modules, upgrades and fixes to assigned software applications and systems.
• Auxiliary in establishing requirements, methods and procedures for routine maintenance.
• Evaluate new vendor-provided AI functionality for fit and function within the University.
• Evaluate compatibility of external AI tools within the context of existing systems.
• Develop custom solutions where necessary and appropriate.
• Perform testing, including error handling.
• Develop user guides and training documentation.
• Provide Database Administration for assigned systems such as Ellucian Banner and Ellucian Degreeworks.
• Follow following generally accepted practices in programming and software development, develop system interfaces and system integrations.
• Research and consider hosted and SaaS solutions.
• Evaluate vendor solutions to ensure compliance with requirements and cost-effectiveness.
• Work with vendors to resolve problems and develop solutions.
• Design, create and manage database structures for development, testing and production.
• Lead large projects and actively participate on assigned projects.
• Meet deadlines.
• Ability to effectively communicate with customers in an appropriate level of detail.
• Assist ITS in the development of best practices and actively engage in improving ITS and its processes.
• Participate in professional development activities.
• Perform other related duties and projects as assigned.

Requirements

• Five or more years of experience with ERP systems management.
• Expert-level proficiency with Oracle PL/SQL.
• Demonstrated expertise with AI tools and technology.
• Expert at scripting in one or more of the following: Python, Linux Shell script, or Windows Powershell.
• Effectively runs large requirement gathering meetings, solicits needs and creates high-level requirements documents.
• Ability to work with vendors to troubleshoot, set up demonstrations, and understand future product direction.
• Attends and represents Colgate professionally at conferences.
• Expert understanding of relational databases and ability to create and manage database structures as needed for development and troubleshooting.
• Proven excellence in client contact and strong communication skills.
• Ability to work both independently and within a team.
• Willing to collaborate, share ideas openly and learn.
• Demonstrated understanding of, sensitivity to, and respect for the academic, cultural and social diversity in the Colgate University community.

Qualifications

• Bachelor’s Degree in Computer Science, Information Technology, or a related degree preferred.
• Master’s Degree in Information Technology or a related degree preferred, or equivalent additional professional experience in essential duties and responsibilities.
• Snowflake administration.