ITS Programmer Analyst

State University of New York at Fredonia; Village of Fredonia (NY); Hybrid; USD 55,000 - 65,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Retirement plan

Tuition benefits

Paid leave

Fitness center access

Child care center access

Job summary

The State University of New York at Fredonia is seeking a Programmer Analyst to join the Information Technology Services team. The role focuses on designing and reporting with Ellucian Banner, testing changes, and ensuring system stability. A 4-year degree and SQL reporting experience are required.

The position is predominantly onsite with some remote work, offering a competitive salary and comprehensive benefits. Commitment to diversity and ongoing professional development are emphasized.

Qualifications

• 4 year degree in programming or related field.
• Minimum one year of experience in SQL reporting and development (including stored procedures, packages, functions, triggers).
• Excellent written and verbal communication skills.
• Knowledge of structured/object-oriented programming and query languages.
• Experience with relational databases (MS SQL Server or Oracle).
• Strong problem-solving and teamwork abilities.
• Ability to adapt to evolving technology and work with diverse groups.

Responsibilities

• Work with faculty and staff to design and enhance reports and programs using Ellucian Banner.
• Develop and execute test plans to ensure stability and security during changes.
• Collaborate within ITS to maintain availability and integrity of university systems.
• Produce technical and user documentation.
• Participate in collaborative activities with peer institutions.
• Use IT ticketing system for incidents, problems, and service requests.
• Follow university policies and contribute to campus mission.

Skills

SQL reporting

Teamwork

Communication

Programming concepts

Problem solving

Education

4 year degree in programming or related field

Tools

SQL Server

SSMS

T-SQL

Stored procedures

Oracle PL/SQL

Git

Ellucian Banner

Job description

About State University of New York at Fredonia:

The State University of New York at Fredonia is one of the crown jewels in the 64-campus State University of New York system. Founded in 1826, Fredonia is a highly ranked comprehensive, selective, public, residential, liberal arts university that enrolls approximately 4,000 undergraduate and graduate students in 80+ majors and 50+ minors. Fredonia is consistently ranked as a top public university for academics, value, and social mobility. Fredonia is known for its strong academic programs , professional, award-winning faculty, a welcoming, inclusive atmosphere, and a strong focus on student success .

The 256-acre campus , known for beautiful green spaces and attractive architecture, is located one mile from the shore of Lake Erie in beautiful Western New York with ready access to fishing, swimming, and lakefront attractions. Fredonia is centrally located between several large metropolitan areas. It is one hour south of Buffalo and Niagara Falls, 45 minutes north of Erie, PA, and just 2 ½ hours from Pittsburgh, Cleveland, or Toronto.

Fredonia is a safe village community with beautiful Victorian homes situated in the heart of Western New York wine country. The location affords residents all four authentic weather seasons; warm and sunshine-filled, yet comfortable spring and summer, vibrant colors across rolling hills with the changing leaves of autumn, and the picturesque landscapes and accompanying outdoor activities of winter.

SUNY provides a competitive salary and benefits package.

Fredonia's faculty and staff focus on ensuring that all students will achieve the Institutional Learning Goals:

• SKILLED Develop Intellectual and Applied Skills, Literacies and Knowledge
• CONNECTED Engage Community and Diversity: Local Stewardship, Global Citizenship
• CREATIVE Demonstrate Scholarship, Artistry, and Innovation
• RESPONSIBLE Activate Sustainability, Ethics, Leadership, and Professionalism

Read a message from State University of New York at Fredonia's President.

Job Description:

The State University of New York at Fredonia is seeking qualified applicants for a full- timeProgrammer Analyst position on the Information Technology Services team.

• Competitive compensation plus comprehensive benefits plan including health, dental, and vision insurance and retirement plan options including a fixed pension plan or a 401(A) with generous employer contributions.
• Paid leave provisions including sick and holiday leave; impressive educational benefits including tuition-free study plus supplemental tuition aid.
• A rich array of services, programs and benefits to help employees advance in their career and enhance the quality of their personal life, including professional development programs and services, employee EAP and wellness programs, discounted membership to the on-campus fitness center, and access to the Campus and Community Child Care Center.

KEY RESPONSBILITIES

Reporting to the Manager of Enterprise Data Services, the successful candidate will:

Work with faculty/staff at the University to assess needs, enhance existing and design new reports and programs to promote the use of the Ellucian Banner Student Information System

Develop and execute comprehensive test plans to ensure local/vendor changes do not negatively impact the stability and security of our systems.

Work collaboratively within ITS to maintain the availability and integrity of university systems.

Produce technical and user documentation.

Actively participate in collaborative activities with peer institutions.

Use IT Ticketing system for processing incidents, problems, and service requests.

Be aware of, understand, and follow all university policies.

Requirements:

MINIMUM QUALIFICATIONS

4 year degree in programming or related field.

Minimum one year of experience in SQL reporting and development (including stored procedures, packages, functions, triggers).

Excellent written and verbal communication skills.

Knowledge of structured/object-oriented programming and query languages.

Established experience in Database design and development within a relational database such as MS SQL Server or Oracle.

Strong problem-solving skills and decision-making ability.

Ability to research and keep current with constantly changing technology.

Demonstrated ability to work in a Team environment and individually along with a demonstrated commitment and ability to work with a diverse group of vendors, service providers, students, faculty, staff and constituents in support of campus and department mission.

Demonstrated commitment and ability to work with a diverse group of students, faculty, staff and constituents in support of campus and department mission.

Demonstrated commitment to the university, division, and profession.

Ability to work evenings and weekends on an occasional basis to support critical issues and project upgrades.

PREFERRED QUALIFICATIONS

• Experience with Microsoft SQL Server, SQL Server Management Studio, T-SQL, database development, writing of stored procedures and functions.
• Experience with Ellucian Banner Student Information System.
• Experience using Linux, Windows and Mac OS
• Experience with Oracle PL/SQL and PL/SQL Developer or comparable IDE
• Experience with Argos Reporting or equivalent reporting applications/Business Intelligence tools
• Experience working in higher education
• Experience with Source Code Control, Git preferred
• Interest in, and commitment to, community engagement.

Additional Information:

This is a full-time 12month, SL-2 term appointed, UUP represented position, beginning December 1st, or as soon as possible, with a salary range of $55,000 to $65,000.This position will be predominately onsite with some remote work available.

Visa sponsorship is notavailable for this position.

Fredonia prides itself on an outstanding workforce. To continually support organizational excellence, the university conducts background screens on applicants.

An Affine Action, Equal Opportunity Employer, Fredonia provides for, and promotes, equal opportunity employment, compensation, and other terms and conditions of employment, without discrimination.

Pursuant to University policy, the University is committed to fostering a diverse community of outstanding faculty, staff, and students, as well as ensuring equal educational opportunity, employment, and access to services, programs, and activities, without regard to an individual's race, color, national origin, religion, creed, age, disability, sex, gender identity, sexual orientation, familial status, pregnancy, predisposing genetic characteristics, military status, or domestic violence victim status. Employees, students, applicants or other members of the University community (including but not limited to vendors, visitors, and guests) may not be subjected to harassment that is prohibited by law, or treated adversely or retaliated against based upon a protected characteristic.

The University's policy is in accordance with federal and state laws and regulations prohibiting unlawful discrimination and harassment. These laws include the Americans with Disabilities Act (ADA), Section 504 of the Rehabilitation Act of 1973, Title IX of the Education Amendments of 1972, Title VII of the Civil Rights Act of 1964 as Amended by the Equal Employment Opportunity Act of 1972, and the New York State Human Rights Law. These laws prohibit discrimination and harassment, including sexual harassment and sexual violence.

SUNY Fredonia is actively recruiting diverse faculty of all backgrounds. In efforts and our commitment to the goal of building a diverse workforce we are participating in PRODiG. PRODiG ("Promoting Recruitment, Opportunity, Diversity, Inclusion and Growth") aims to increase the representation of historically underrepresented faculty at SUNY including underrepresented minority ("URM") faculty in general and women faculty of all races in STEM fields ("WSTEM"). Click this link https://www.suny.edu/prodig/ to find out more about PRODiG.