THE UNIVERSITY OF TOLEDO Position Description Position Title: Programming Specialist State: Classified Union: CWA Department: UToledo Online General Summary The Programming Specialist is responsible for assisting with design, execution, and maintenance of “extract, transform, load” (ETL) processes and data operations for the learning management system (Blackboard Learn) and other technologies that support online education. The position also assists with administration of many software tools supported by UToledo Online and works with other departments to implement custom workflows and processes to create learning environments where learners can succeed. Principal Duties and Responsibilities Rank List of Job Duties Percent of Time 1. Assist with design, execution, and maintenance of daily “extract, 30% transform, load” (ETL) processes that synchronize data between the student information system (Banner), the learning management system (Blackboard Learn) and other supported systems. Develop and maintain processes to create customized courses, course merges, users and enrollments in various systems. Some examples of such processes include managing custom courses and merges for the College of Medicine MD program, creating/managing users/enrollments for external students taking UToledo classes through agreements with other institutions, and managing course/organization/user access for other custom non-Banner requests. 2. Assist with administration of the learning management system and 30% its associated plugins and other supported software. 3. Provide high-level technical support for the learning management 25% system and other supported software when escalated from help desk or other UToledo Online staff. 4. Perform data and log-based forensics to resolve problem reports 10% and academic disputes, and provide data reports and additional input for decisions relating to the learning management system. 5. Other tasks/projects/duties as assigned. 5% TOTAL 100% Impact on the Organization 1. Directly responsible for ensuring that faculty, staff and students can access the appropriate courses Position Description Page 2 and additional learning environments in a reliable and timely fashion. This responsibility is a critical component to the University’s ability to offer online education. 2. Responsible for maintaining confidentiality of student records. Qualifications/Knowledge, Skills & Abilities Education/experience/licensing: Bachelor’s degree in information systems, computer science or related field -OR- 5 years of relevant work experience required. Minimum one year of experience with “extract, transform, load” (ETL) processes is required. Demonstrable proficiency writing SQL statements required. Experience with the following technologies/products is preferred: o Oracle, PostgreSQL, Snowflake, DBeaver/Oracle SQL Developer, Linux scripting/cron jobs, Python, Blackboard Learn/Ally/Collaborate, Echo360. Communication and other skills: Excellent organizational, oral, and written skills. Ability to work alone efficiently and effectively as a self-starter and as a member of a team of professionals. Ability to coordinate multiple and complex tasks. Must be able to evaluate crisis situations, set priorities, and accomplish a high volume workload on time, while maintaining a positive working relationship with co-workers and clients. Ability to interact cordially with faculty, students, staff, vendors, and other parties. Ability to communicate effectively with individuals having varied levels of computer competency. Project management experience is beneficial. Ability to communicate data about online learning in a way that it is easily understood by decision makers. Knowledge of organizational management, including workflows and other business processes. Reporting Relationships The Programming Specialist reports to the Director of UToledo Online and functions as a team member of the Learning and Academic Technology staff. This position works closely with most members of the UToledo Online staff including Educational Technologists, Instructional Designers, Faculty and Student Support personnel and others. This position sometimes works directly with faculty and students to resolve support issues. This position also works with various department chairs and program directors to implement customized learning environments, with the Information Technology department and Registrar’s Office to facilitate changes to employee and student records, and provides reports for the UToledo Online and Admissions Success Coach. Working Conditions Primarily works in a professional office environment with occasional moderate to high stress levels. Will sometimes be required to work in server rooms and data closets installing equipment. Must be able to lift or assist with lifting heavy computer equipment. The above list of duties is intended to describe the general nature and level of work performed by people assigned to this classification. It is not to be construed as an exhaustive list of duties performed by the people so classified, nor is it intended to limit or modify the right of any supervisor to assign, direct and control the work of employees under his/her supervision. Job Type: Full-time Pay: $24.28 - $35.37 per hour Schedule: 8 hour shift Ability to commute/relocate: Toledo, OH 43606: Reliably commute or planning to relocate before starting work (Required) Work Location: In person