Fast Facts

Colgate University is seeking a Data Systems Programmer Analyst to develop and maintain reports and dashboards, assist in software projects, and ensure data quality within the Information Technology Services department.

Responsibilities: Key responsibilities include designing data visualizations, data quality verification, collaborating with team members, and programming interactions with APIs.

Skills: Proficiency in SQL, Python, and experience with reporting/dashboard tools such as Tableau are essential qualifications.

Qualifications: A Bachelor's degree with 2 years of relevant experience or a Master's degree is required. Preferred experience in higher education settings and understanding of data privacy regulations.

Location: This position is based in Hamilton, New York, USA with no specified travel requirements.

Compensation: $80000 - $100000 / Annually

Colgate University

Data Systems Programmer Analyst

Requisition Number: 2025S062Posting

Full Time/Part Time: Full Time

Division: $ATSDiv

Department: Information Technology Services - Services and Shared Infrastructure

Wage/Salary Range: $80,000-$100,000

Department Statement:

Colgate Information Technology Services ( ITS ) is a dynamic organization that serves the diverse technology needs of the university community. Comprised of several functional areas – Classrooms, Digital Media & Events; Data Analytics & Decision Support; Engagement & Support; Information Security; Learning & Applied Innovation; Services & Shared Infrastructure – ITS prides itself on exceptional customer service and building collaborative relationships to meet the unique needs of our liberal arts campus. ITS endeavors to foster an inclusive environment that values diversity, professional development, creativity, and innovation to support the growth of individuals and the organization.

The Data Systems Programmer Analyst’s responsibilities include developing and maintaining reports and dashboards, performing data integration tasks, assisting in software maintenance and upgrade projects, drafting and updating documentation for new or existing processes, and other duties as assigned. The successful candidate will possess a solid understanding of data, database, and reporting concepts, and excellent communication skills. This role provides support to other Systems and Data team members through the fulfillment of these responsibilities.

As part of the Systems and Data team, this role reports to the Director for Enterprise Applications and Data systems. The Systems and Data team consists of eleven others within the Information Technology Services department and provides support for enterprise software systems through data integration, customization, configuration, and custom web development.

This is a new position with a 2-year term with a potential extension.

Accountabilities:

• Data visualization: design, develop, and maintain visual, interactive dashboards and reports using Tableau
• Data quality verification: ensure data quality and consistency
• Collaboration: collaborate with team members to provide support and assistance for project and operational tasks
• Programming: send and receive data to/from REST or other APIs
• Growth: participate in professional development
• Perform other duties and participate in projects as assigned

Professional Experience/Qualifications

• A Bachelor’s degree and 2 years relevant experience, or a Master’s degree
• SQL experience
• Python experience
• 2+ years of experience in reporting and dashboard development
• Demonstrated communication skills, both verbal and written, used to explain business and technical processes to a wide range of users
• Ability to maintain confidentiality
• Must be capable of working collegially with a diverse group of faculty, staff, and students within a university context

Preferred Qualifications

• Experience working in a higher education environment, preferably with student or institutional data
• Understanding of FERPA and data privacy regulations in an academic setting
• SQL experience in Oracle, SQL Server, and/or Snowflake.
• Tableau Cloud dashboarding experience
• Experience working with enterprise resource planning systems (Banner, Workday, Oracle, etc.)

Education

A Bachelor’s degree and 2 years related experience, or a Master’s degree is required.

Other Information

Work Schedule:

Job Open Date: 07/02/2025

Job Close Date: 8/2/2025

Open Until Filled No

Special Instructions Summary

To view the full job posting and apply for this position, go to: https://careers.colgate.edu/postings/6492

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 merit, ability, 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 .

Copyright ©2025 Jobelephant.com Inc. All rights reserved.

Posted by the FREE value-added recruitment advertising agency

jeid-bc85b0de5b59ea40a8c258cc384a5684