Systems Analyst and AI Programmer
Colgate University
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
Qualifications
- Five or more years of experience with ERP systems management.
- Expert-level proficiency with Oracle PL/SQL.
- Demonstrated expertise with AI tools and technology.
Responsibilities
- Analyze needs and provide technical guidance for improvements.
- Lead implementations for new software systems.
- Evaluate new vendor-provided AI functionality.
Skills
Education
Job description
Department Information Technology Services - Services and Shared Infrastructure
Work Arrangement type On‑Site (Hamilton, NY) – expected to work fully at the designated campus/office location.
$95,000-$105,000
- 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.
Master’s Degree in Information Technology or a related degree preferred, or equivalent additional professional experience in essential duties and responsibilities.
Snowflake administration.
Bachelor’s Degree in Computer Science, Information Technology, or a related degree preferred.
When extending an offer, Colgate University considers factors such as (but not limited to) the scope and responsibilities of the position, candidate’s work experience, education/training, key skills, internal peer equity, as well as market and organizational considerations.
Work visa sponsorship is not available for this position.
Colgate University offers a competitive benefits package, with most benefits effective on the date of hire. Highlights include: medical, dental, vision, retirement contributions, paid time off, paid family leave, health & wellness, continuing education and professional development. We also offer unique perks, such as free parking, gym discounts, bookstore savings, athletic tickets, and access to cultural and recreational facilities. Explore the full benefits package on our Benefits page.
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. This position is responsible for optimizing the user experience of assigned software and systems and developing sustainable interfaces and in‑house solutions. The Programmer will engage with and guide Colgate ITS and campus partners in the evaluation and adoption of AI tools. The successful candidate will have a mastery of AI concepts such as orchestration, retrieval‑augmented generation (RAG) technology, and one or more AI frameworks or tools. Familiarity with AI concepts and usage within a complex software environment is a key skillset for this position. Further responsibilities include maintaining assigned software versions, including co‑requisite database and web server software such as Oracle RDBMS, Apache Tomcat, etc. Employment is subject to the terms and conditions of Colgate University Human Resources policy, consistent with the laws of New York state. Normal schedule is daily, Monday through Friday concurrent with the business hours of the office. Adjustments to the normal schedule to accommodate evening, overnight, weekend and holiday work as required for system and service maintenance and upgrades.
Gather requirements 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. Leads 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. Assist in establishing requirements, methods and procedures for routine maintenance.
Additional Responsibilities:
- 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.
- Develop user guides and training documentation.
- Provide Database Administration for assigned systems such as Ellucian Banner and Ellucian Degreeworks.
- 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.
- Perform other related duties and projects as assigned.
2026S014Posting
No
02/03/2026
Open Until Filled No
The University recognizes that equal employment opportunity can only be achieved through demonstrated leadership. It is the Policy of the University to recruit, employ, retain, promote, and train employees on the basis of skills and experience, capacity to do the job, and valid job qualifications without regard to any characteristics protected by applicable local, state or federal laws.
CAMPUS CRIME REPORTING AND STATISTICS
The Department of Campus Safety will provide upon request a copy of Colgate’s Annual Security and Fire Safety Report. This report includes statistics as reported to the United States Department of Education for the previous three years concerning reported: 1. crimes that occurred on‑campus; in certain off‑campus buildings or property owned or controlled by Colgate University; and on public property within, or immediately adjacent to and accessible from, the campus and 2. fires that occurred in student housing facilities. The report also includes institutional policies concerning campus security and fire safety, such as policies concerning sexual assault, life safety systems, and other related matters. You may access the report from the Clery Compliance web page at: https://www.colgate.edu/about/offices-centers-institutes/dean-college/campus-safety-staff/clery-compliance. Printed copies of this report may be obtained upon request from the Department of Campus Safety via e‑mail at cusafety@colgate.edu.
Required fields are indicated with an asterisk (*).
- * Are you currently a Colgate employee?
- Yes
- No
- * Have you ever been a Colgate employee?
- Yes
- No
- Do you have a spouse/domestic partner who currently is, or will be, employed at Colgate University?
- Yes
- No
- * Are you at least 18 years of age?
- Yes
- No
- * Please let us know how you heard about this position.
- Albany Times Union
- Binghamton Press & Sun
- BlackCoachesinSports
- Careerbuilders.com
- Cazenovia Republican
- Centralnewyorkhelpwanted.com
- Chronicle of Higher Education
- Chronicle of Philanthropy
- Colgate Employee
- Colgate Website
- CoSIDA
- Diverse Issues of Higher Education
- HERC (Upstate New York HERC)
- HigherEdJobs.com
- Indeed.com
- InsideHigherEd.com
- Mid-York Weekly
- NACWA
- naviGATE
- NCAA News
- Norwich Evening Sun
- Oneida Daily Dispatch
- Sherburne News
- Studentaffairs.com
- Syracuse Post Standard
- Utica Observer Dispatch
- Waterville Times
- WomenLeadersinCollegeSports.com
- Other
- If you selected "Colgate Employee" or "Other" for how you heard about this position, please provide the employee's name or where you heard about/saw the position.
(Open Ended Question)
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
