Data Systems Programmer Analyst - Westfield State University : Job Details

Job Category:

Professional/Administrative

Position Title:

Data Systems Programmer Analyst

Full Time/Part Time:

Full Time

Division:

Dean of the Faculty

Department:

Information Technology Services - Services and Shared Infrastructure

Hiring Wage/Salary Range:

$80,000-$100,000

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.

Offer 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.

Benefits:

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

Requisition Number:

2025S062Posting

Temporary:

No

Job Open Date:

07/02/2025

Open Until Filled:

No

EEO 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 STATISTICSThe 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].

#J-18808-Ljbffr