Programmer Analyst - Information Technology Services
Location: Fredonia, New York
Higher Education Institution
Internal Number: 156520
The State University of New York at Fredonia is seeking qualified applicants for a full-time, 12-month, Programmer Analyst position (SL2) on the Information Technology Services Enterprise Reporting and Development Team.
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.
Reporting to the Manager of Enterprise Reporting & Development, the successful candidate will:
Design, develop, modify and document forms and workflow as assigned using current campus solutions such as Dot Net Nuke (DNN), .Net Web Forms, OnBase, and AdobeSign).
Migrate legacy MS Access applications to new form and workflow environment with SQL Server back end.
Assist in evaluation, documenting, supporting, debugging, testing and improving business systems as assigned.
Become familiar with Fredonia's integration between Oracle, SQL Server, AD and Google for account and group membership management.
This position will be key for supporting the Finance and Administration division and Human Resources office for programming and reporting.
Participate in committees and provide service to the department, college, university, and profession;
Be aware of, understand, and follow all university policies.
Salary commensurate with experience.
Bachelor's degree in Computer Science, Information Systems Management or a related field plus 1 year professional experience in an IT environment.
Working familiarity with Windows desktop and Server OS.
Working familiarity with Microsoft Office, particularly Access and Excel.
Demonstrated analytical skills relative to project business requirements.
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.
Experience with SQL and database queries including query development.
Experience with SQL Server 2014-19, SQL Server Management Studio, T-SQL, database development, writing of stored procedures and functions.
Familiar with Database development in a RDBMS such as MySQL, MS SQL, and Oracle.
Familiar with web accessibility standards and testing tools.
Experience developing and content management in DNN portal.
Familiarity with XML and JSON.
Familiarity with REST web services and other asynchronous web services.
Familiarity with Web API service integration using XML & JSON data sources.
Familiarity with Visual Basic scripting, especially VBA (Visual Basic for Applications).
Professional experience in a higher education IT environment.
Interest in, and commitment to, community engagement.
This is a full-time, term appointed, SL2, UUP represented position beginning January 2023.
Visa sponsorship is not available for this position.
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 res...idents 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.