Systems and Applications Specialist

Reporting to the Director of Systems and Information Services, the Systems and Applications Specialist supports the administration, automation, and development of Wesleyan College’s information systems within the Jenzabar J1 ecosystem and related technologies. This hands‑on position offers the opportunity to work across databases, Windows servers, web‑based applications, and campus integrations in a collaborative and supportive environment.

The role is ideal for a technically curious and motivated individual with foundational knowledge of SQL, Windows administration, and scripting who enjoys problem‑solving and is eager to learn. The position provides broad exposure to enterprise systems and database operations in higher education.

The Systems and Applications Specialist is a key member of a small, collaborative IT team that supports the College’s mission through reliable, secure, and efficient technology services. The ideal candidate is adaptable, resourceful, and eager to grow technical and analytical skills across multiple disciplines under the mentorship of the Director of Systems and Information Services.

• Assist with the administration and maintenance of institutional systems and applications within the Jenzabar J1 environment and related platforms.
• Help automate information flows between systems and departments using scripting and SQL processes.
• Participate in developing and maintaining custom reports for faculty and staff using T‑SQL and reporting tools such as SSRS.
• Assist with SQL Server maintenance, backups, and performance monitoring.
• Help troubleshoot issues and integrations between Jenzabar J1, databases, and third‑party systems.
• Support the administration and troubleshooting of Windows Server environments and related services.
• Support Google Workspace and Microsoft 365 user management, group and OU configurations, and general administration.
• Assist in maintaining lightweight web resources and simple HTML‑based applications.
• Collaborate with departments to understand reporting and workflow needs, and help translate them into technical solutions.
• Contribute to resolving data quality or integrity issues within the Jenzabar system.
• Support compliance with FERPA, GLBA, and institutional data governance practices.
• Assist with documentation of procedures, configurations, and processes.
• Participate in end‑user training and support campus‑wide technology initiatives.
• Perform other duties as assigned.

• Must be able to lift and move objects weighing up to 35 pounds.
• Occasionally, access and work with equipment in elevated spaces, such as data closets or equipment racks, as needed.
• Ability to assist with the physical setup, installation, or relocation of IT hardware and related components.
• Comfortable working in data closets or server environments for short periods.
• Working hours are 8:30 am – 5:00 pm, Monday thru Friday, with occasional evening or weekend work.

Required

• Foundational understanding of databases and SQL (T‑SQL preferred).
• Familiarity with Windows Server and basic system administration concepts.
• Exposure to scripting or automation tools (Power Shell, Python, or similar).
• Interest in learning enterprise systems such as Jenzabar J1.
• Basic knowledge of HTML5 and web‑based applications.
• Strong troubleshooting and analytical ability.
• Excellent communication, collaboration, and customer service skills.
• Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent combination of education and experience).

Preferred

• Experience with SQL Server administration.
• Familiarity with SQL Server Reporting Services (SSRS).
• Familiarity with HTML, JavaScript, and web development fundamentals.
• Exposure to Jenzabar J1, higher education information systems, or similar ERP platforms.
• Experience with Google Workspace or Microsoft 365 administration.
• Experience developing or maintaining documentation or technical guides.

Interested applicants should apply and upload the following required documents: a letter of interest, resume, and three references. If possible, please upload as one PDF file.

Wesleyan College is an Equal…