Data Systems Programmer Analyst - Colgate University : Job Details

Posting DetailsPosition Information Job Category Professional/AdministrativePosition Title Data Systems Programmer AnalystFull Time/Part Time Full TimeDivision Dean of the FacultyDepartment Information Technology Services - Services and Shared InfrastructureHiring Wage/Salary Range $80,000-$100,000Professional 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.CertificationsOffer Determination 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.Physical RequirementsOther InformationBenefits 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.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

Posting Detail Information Requisition Number 2025S062PostingTemporary NoWork ScheduleJob Open Date 07/02/2025Job Close DateOpen Until Filled NoSpecial Instructions SummaryEEO Statement 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.Clery Act 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: . Printed copies of this report may be obtained upon request from the Department of Campus Safety via e-mail at [email protected] Questions

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
• LinkedIn
• 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)

Applicant Documents Required Documents

Resume

Cover Letter

Optional Documents