Business Systems Programmer/Analyst

Viterbo University; La Crosse (WI); On-site; USD 70,000 - 95,000; Full time

Job summary

Viterbo University in La Crosse, Wisconsin, seeks a Business Systems Programmer/Analyst to develop and support institutional data and digital resources for administrative operations. The role covers data integration, BI reporting, dashboards, and ERP system support (Ellucian Colleague & Self-Service).

The position is full-time, exempt, and based on campus. The ideal candidate will analyze business systems, manage data workflows, and collaborate with campus units to improve efficiency and

Qualifications

• BA/BS degree in information systems, data analytics or IT, or equivalent experience.
• Strong project management skills with results focus within an information systems environment.
• Experience with BI dashboarding/reporting from a variety of data sources required.
• Strong understanding of data relationships, data integrity, reporting and security.
• Basic understanding of HTML, JQuery and JavaScript coding is required.
• Advanced experience with extraction/transformation of data from various databases using SQL queries.

Responsibilities

• Review, analyze and evaluate business systems and user needs to determine opportunities that can improve efficiency of business processes.
• Provide oversight of the document imaging/management solution, form creation, BI reporting & dashboarding, and data integration between systems.
• Work with the Dashboarding and Programmer/Analyst Teams in support of data use for decision making and KPI tracking at all institutional levels.
• Support systems and data integration to aid end user utilization and maintain data security/integrity.
• Support departmental needs related to data extraction/analysis for regulatory or institutional needs.
• Provide Tier II support of software for administrative offices.
• Assist in ERP system support and software update management (Ellucian Colleague & Self-Service).
• Collaborate with campus departments on process mapping for document workflow automation.
• Write technical procedures and documentation for the applications.

Skills

Strong project management

Data analysis

Communication skills

Team collaboration

Education

BA/BS in information systems or data analytics or IT

Tools

HTML basics

JQuery

JavaScript

SQL

SSIS

SSRS

Tableau

Etrieve SoftDocs

Ellucian Colleague

Job description

Viterbo is seeking a Business Systems Programmer/Analyst to 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 interactive data integration between disparate systems, cross system data visualization/reporting, assisting business units in the use of technology tools to gain operational efficiency and overall transparency of data for Institutional use and support the management, maintenance, continual improvement and upgrading systems related to University's administrative software/hardware systems (Ellucian Colleague & Self Service). This is a full time, year-round, salary, exempt position.

Responsibilities

• Review, analyze and evaluate business systems and user needs to determine opportunities that can improve efficiency of business processes and decision making.
• Provide oversight, planning, and support of the document imaging/management solution, form creation, BI reporting & dashboarding, and data integration between systems.
• Work as part of the Dashboarding and Programmer/Analyst Teams in support of data use for decision making and metric (KPI) tracking at all levels of the Institution.
• Support systems and data integration to aid in end user utilizations as well as maintain security/integrity of data.
• Support departmental needs related to data extraction/analysis for regulatory or institutional needs.
• Provide administrative offices with Tier II support of software.
• Assist in the support & software update management of the ERP (Ellucian Colleague & Self-Service) system.
• Work with various campus departments on process mapping to determine opportunities for document workflow automation.
• Write technical procedures and documentation for the applications including operations, user guide, etc.
• Willingness to undertake additional tasks or responsibilities as assigned by the Director of IIT as the role evolves over time to meet the department's changing needs.

Qualifications

• BA/BS Degree, preferably in information systems, data analytics or information technology or equivalent experience
• Strong project management skills with effective results focus within an information systems environment
• Experience with BI dashboarding/reporting from a variety of data sources required
• Strong understanding of data relationships, data integrity, reporting and security
• Basic understanding of HTML, JQuery and JavaScript coding is required
• Willingness to work in a collaborative environment
• Ability to gather and interpret relevant data and information
• Advanced experience with the extraction/transformation of data from various types of databases utilizing & writing SQL query language required, demonstratable skills in creating, maintaining, troubleshooting SQL queries is required
• Demonstratable experience with data base structure and design is a plus
• Experience of SSIS and SSRS tools a plus
• Experience with Tableau and knowledge of visualization best practices a plus
• Experience with Etrieve SoftDocs a plus
• Experience with Ellucian products a plus
• Experience in server software management a plus

Alignment

Viterbo University seeks employees who will embrace the University mission and incorporate our values into their day-to-day work.

Mission

The Viterbo University community prepares students for faithful service and ethical leadership.

Values

• Contemplation, reflecting upon the presence of God in our lives and work
• Hospitality, welcoming everyone we encounter as an honored guest
• Integrity, striving for honesty in everything we say and do
• Service, working for the common good in the spirit of humility and joy
• Stewardship, practicing responsible use of all resources in our trust

About the University

Viterbo University is a private, not-for-profit, Catholic, Franciscan institutions founded by the Franciscan Sisters of Perpetual Adoration in 1871. Viterbo offers a student-centered liberal arts education with a wide range of undergraduate, graduate, and professional programs. Located in La Crosse, Wisconsin, the university is nestled along the scenic Mississippi River and surrounded by the stunning bluffs. The local area combines natural beauty with a vibrant, welcoming community, offering opportunities for outdoor recreation, arts and culture. Together, Viterbo and La Crosse provide an exceptional place to live, work, and make a difference.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship at this time.

The university does not unlawfully discriminate on the basis of sex or engage in sex discrimination in any education program or activity that the university operates. Title IX's mandate not to discriminate on the basis of sex extends to students, employees, applicants for employment, and other persons in all aspects of the university's programs, activities, and operations. Inquiries regarding how Title IX applies to the university may be referred to the university Title IX coordinator, to the U.S. Department of Education Office of Civil Rights, or to both.

Contact information for the Title IX coordinator is available at Title IX: Sex and Gender Discrimination or Harassment | Viterbo University