ITS Programmer Analyst

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.

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 with web technologies (HTML5, CSS, Javascript, etc.) Experience working in higher education Experience with Source Code Control, Git preferred Interest in, and commitment to, community engagement.

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