What are the responsibilities and job description for the Lead Programmer Analyst position at State University of New York at Fredonia?
Location: fredonia, NY Category: Professional Staff Job Type: Full-time Posted On: Tue Jun 9 2026 Job Description:
Rewards & Benefits
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 RESPONSIBILITIES
Reporting to the Manager of Student Information Systems, the successful candidate will:
Develop applications including design of detailed flowcharts and routines, reviewing and analyzing user specifications in writing programming code, verifying program logic through QA testing, and writing application integrations.
Assist in evaluat i on, documenting, supporting , debugging, testing and improving business systems as assigned
Develop custom reporting and analytics
Configure, test, and support third-party product modules
Interface with third-party product support resources to resolve problems
Participate in committees and provide service to the department, college, university, and profession;
Be aware of, understand, and follow all university policies.
Job Requirements:
MINIMUM QUALIFICATIONS
Bachelor's degree in Computer Science, Information Systems Management or a related field.
Two to Three years of programming/analysis experience and/or training
Experience in SQL queries and programming with modern relational databases
Demonstrated knowledge of Oracle RDBMS, Oracle SQL*Plus, PL/SQL, Unix/Linux commands, and Windows OS and desktop tools.
Demonstrated business analysis skills and attention to detail.
Demonstrated ability to learn new technologies independently with minimal assistance
Excellent customer service and communication skills are a must.
Ability to work evenings and weekends on an occasional basis to support critical issues and project upgrades
Demonstrated commitment and ability to work with a diverse group of students, faculty, staff and constituents in support of campus and department mission
Experience with instructional technology;
PREFERRED QUALIFICATIONS
Demonstrated experience supporting Ellucian Banner software or other Higher Education enterprise SIS and related software.
Functional knowledge in Banner Student, Financial Aid, Admissions.
Familiar with web accessibility standards and testing tools.
Functional knowledge of OnBase Imaging System.
Applications Development skills: ApEx, Pl/SQL -Developer or SQL Developer IDEs, JAVA, Javascript, Database experience (Oracle 10g and above).
Demonstrated experience with Business Intelligence tools such as Argos, OBIEE, PowerBI...
Demonstrated ability to meet deadlines.
Professional experience in a higher education IT environment.
Experience with Microsoft SQL Server, SQL Server Management Studio, T-SQL, database development, writing of stored procedures and functions.
Additional Information:
This is a full-time12 month, SL-3 term appointed, UUP represented position, beginning July 1, 2026, or as soon as possible, with an annual salary of $62,000-$70,000, commensurate with experience.
Visa sponsorship is not available for this position.
Fredonia prides itself on an outstanding workforce. To continually support organizational excellence, the university conducts background screens on applicants.
An Affirmative 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.
Rewards & Benefits
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 RESPONSIBILITIES
Reporting to the Manager of Student Information Systems, the successful candidate will:
Develop applications including design of detailed flowcharts and routines, reviewing and analyzing user specifications in writing programming code, verifying program logic through QA testing, and writing application integrations.
Assist in evaluat i on, documenting, supporting , debugging, testing and improving business systems as assigned
Develop custom reporting and analytics
Configure, test, and support third-party product modules
Interface with third-party product support resources to resolve problems
Participate in committees and provide service to the department, college, university, and profession;
Be aware of, understand, and follow all university policies.
Job Requirements:
MINIMUM QUALIFICATIONS
Bachelor's degree in Computer Science, Information Systems Management or a related field.
Two to Three years of programming/analysis experience and/or training
Experience in SQL queries and programming with modern relational databases
Demonstrated knowledge of Oracle RDBMS, Oracle SQL*Plus, PL/SQL, Unix/Linux commands, and Windows OS and desktop tools.
Demonstrated business analysis skills and attention to detail.
Demonstrated ability to learn new technologies independently with minimal assistance
Excellent customer service and communication skills are a must.
Ability to work evenings and weekends on an occasional basis to support critical issues and project upgrades
Demonstrated commitment and ability to work with a diverse group of students, faculty, staff and constituents in support of campus and department mission
Experience with instructional technology;
PREFERRED QUALIFICATIONS
Demonstrated experience supporting Ellucian Banner software or other Higher Education enterprise SIS and related software.
Functional knowledge in Banner Student, Financial Aid, Admissions.
Familiar with web accessibility standards and testing tools.
Functional knowledge of OnBase Imaging System.
Applications Development skills: ApEx, Pl/SQL -Developer or SQL Developer IDEs, JAVA, Javascript, Database experience (Oracle 10g and above).
Demonstrated experience with Business Intelligence tools such as Argos, OBIEE, PowerBI...
Demonstrated ability to meet deadlines.
Professional experience in a higher education IT environment.
Experience with Microsoft SQL Server, SQL Server Management Studio, T-SQL, database development, writing of stored procedures and functions.
Additional Information:
This is a full-time12 month, SL-3 term appointed, UUP represented position, beginning July 1, 2026, or as soon as possible, with an annual salary of $62,000-$70,000, commensurate with experience.
Visa sponsorship is not available for this position.
Fredonia prides itself on an outstanding workforce. To continually support organizational excellence, the university conducts background screens on applicants.
An Affirmative 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.
Salary : $62,000 - $70,000