Business Systems Programmer/Analyst

Viterbo University invites applications for a full-time Business Systems Programmer/Analyst position. The Programmer/Analyst position reports to the Director of Instructional and Information Technology. The Business Systems Programmer/Analyst will work within the Administrative Systems team to develop and support systems, processes and structures related to the management of institutional data & digital resources for the operational effectiveness of administrative offices. This can include but is not limited to assisting with the management, maintenance, and improvement of systems related to University's administrative software/hardware systems (Ellucian Colleague & Self-Service, SoftDocs Etrieve, MS Reporting Services(SSRS), SQL Server Integration Services(SSIS), Tableau Dashboarding, RS2 door card system), data integration between disparate systems, assisting business units in the use of technology tools to gain operational efficiency and overall transparency of data for Institutional use. This is a full-time, year-round position eligible for employee benefits. Essential Duties and Responsibilities: Perform programming, database report writing and software support tasks on the University's ERP system, which includes ColleagueUI, Ellucian Self-Service, Microsoft Reporting services and ColleagueAPI. Export/Import and process data sets from the Colleague system using SQL Server Reporting Services, SQL Server Integration Services, MS-Excel, MS-Access and SQL Management Studio tools for use in other systems/databases. Serve as a primary support resource & c oordinate the integration of data between the Ellucian Colleague system and other auxiliary systems, including but not limited to Raisers Edge, RS2, CSI, Transferology, Moodle, EMS, etc. Assist end-users with the creation of custom reports using SQL Server Reporting Services, MS-Access, MS-Excel, Tableau Dashboards or other reporting tools. This includes meeting with users to define and translate their requirements into desired report formats. Prepare any necessary documentation within programs or as part of a user manual. The documentation should clarify the intent of the procedure or help in using that procedure. Assist assigned administrative offices with other PC-based software that is used to complete administrative tasks regardless of whether it directly interfaces with the Colleague system. Monitor database integrity, complete security maintenance and file maintenance. Make recommendations for improvements whenever concerns are found, or performance can be enhanced. Serve as a designated contact with Ellucian to troubleshoot and resolve issues with the Colleague software. Maintain knowledge of supported products and applications via list serves, conferences, user groups and training. Able to work off-hours to troubleshoot, install new systems and software upgrades. Self directed; Team player; With the capacity to manage multiple projects while communicating progress and work to end users, team, or supervisor. Perform other tasks as assigned by the Director of IIT General Requirements/Qualifications: Bachelor's degree in IT related program and at least two years additional relevant experience or 3-5 years of professional experience in an equivalent position required. Extensive knowledge of relational database software, programming and query languages is required. Demonstrable experience in troubleshooting of software and systems integrations is required. Experience with Microsoft SQL server, SSIS, SSRS preferred. Higher Education Student Information Systems support a plus. Excellent Customer Service, written and verbal skills are essential. Experience programming in Jquery, Java Script, ASP.NET , HTML is a plus. Must be authorized to work in the United States. Viterbo University is unable to sponsor or take over the sponsorship of the employment Visa . To Apply : Please complete the online employment application form and upload a letter of interest, CV/resume, and three professional references. Review of Application: The review of applications will start end middle of September, 2023 and will be ongoing until the position is filled. About the University: Viterbo University is a Catholic, Franciscan, liberal arts institution with an enrollment of nearly 3000 students. Viterbo is located in scenic La Crosse, Wisconsin, which has been rated as one of the top places to live in the US. The region features an attractive cost of living, beautiful bluffs and coulees, three major rivers including the Mississippi River, world-class health care and education systems, and easy access to major cities in Wisconsin, Minnesota, and Illinois. Diversity and Inclusion Statement: At Viterbo University, we value our inclusive climate and understand that diversity in experiences and perspectives is vital to advancing innovation, critical thinking, solving complex problems, and creating an inclusive academic community. We translate these values into action by seeking individuals who have experience and expertise working with diverse students, colleagues, constituencies, and those who will help us advance our diversity and inclusion initiatives aimed at creating a university that values student, staff, and faculty engagement in addressing issues of diversity and inclusiveness. Viterbo University provides equal employment opportunities to all employees and applicants for employment, encourages nominations and candidacy of historically underrepresented groups, and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Viterbo University is an equal opportunity employer and encourages nominations and candidacy of historically underrepresented groups. Job Posted by ApplicantPro