Lead Programmer Analyst

State University of New York at Fredonia; Village of Fredonia (NY); On-site; USD 62,000 - 70,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Retirement plan

Tuition assistance

Professional development

Employee wellness

Job summary

State University of New York at Fredonia is seeking an Information Technology professional to support the university's Student Information Systems. The role focuses on developing applications, reporting, and system integrations, collaborating with faculty, staff, and students to improve data-driven services.

Strong SQL/PL/Oracle skills, experience with Banner or BI tools, and the ability to work evenings or weekends for critical upgrades are valued.

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
• Working familiarity with Windows desktop and Server OS.
• Excellent written and verbal communication skills.
• Excellent customer service and communication skills are a must.
• Ability to work with a diverse group of employees and students,individually and as part of a team.
• Ability to work evenings and weekends on an occasional basis to support critical issues and project upgrades

Responsibilities

• 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 evaluation, 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.
• Participate in committees and provide service to the department, college, university, and profession;
• Be aware of, understand, and follow all university policies.

Skills

SQL queries

PL/SQL

Oracle RDBMS

Unix/Linux commands

Windows OS

Communication skills

Education

Bachelor's degree in Computer Science, Information Systems Management or a related field

Tools

Oracle SQL*Plus

Ellucian Banner

Power BI

OnBase Imaging

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 Information Technology Departmentis home to a dedicated team of professionalswho support the university's technical infrastructure, faculty, staff, and students.

• 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 one course 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 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 evaluation, 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.
• Participate in committees and provide service to the department, college, university, and profession;
• Be aware of, understand, and follow all university policies.

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
• Working familiarity with Windows desktop and Server OS.
• Excellent written and verbal communication skills.
• Excellent customer service and communication skills are a must.
• Ability to work with a diverse group of employees and students,individually and as part of a team.
• Ability to work evenings and weekends on an occasional basis to support critical issues and project upgrades

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.
• 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-time 12 month, SL-3 term appointed, UUP represented position, beginning December 1st, or as soon as possible, with a salary range of $62,000 to $70,000. This position will be predominately onsite with some remote work available.

Visa sponsorshipis notavailable for this position.

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

An Affidative 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.