Computer Support Analyst

Job Description

The Department of Biology has an outstanding opportunity for a Computer Support Analyst 2 to join their team.

Reporting to Dr. Dee Boersma, the Computer Support Analyst 2 is responsible for facilitating the daily functioning of a ~30-computer research lab. This position also includes maintaining and improving existing data collection programs, administering the 40+ year SQL Server database, and general technical support and documentation to support the Center’s research. This is a 80% FTE Professional Staff position.

• Maintenance of lab and field computers including installation, networking protocols and security on various operating systems (Windows, Mac, Linux)
• Staying up-to-date with security needs and employing cybersecurity measures for the lab’s computers
• Maintaining the Center’s cloud-based and local backups of file servers, updating automated processes for backups
• Maintaining documentation on backup processes, networking changes, and devices
• Providing technical support for equipment and applications used during biological fieldwork
• Performing installation, maintenance, and support of software, including but not limited to:
  Microsoft Office, SQL Server/SQL Server Management Studio, Arc Map, R/RStudio and Resource Space
• Coordinating IT support, purchase, insurance and backups
• Advise on purchases of computers and other technology-related devices
• Overseeing resource needs for student/staff projects, including basic training on computing protocols and necessary software
• Responding to lab member computing needs, troubleshooting technical barriers, and escalating to departmental/UW IT when necessary
• Setup and troubleshooting of accessory technical hardware (e.g. projectors, printers, scanners, etc.)

• Writing SQL queries and stored procedures
• Programming, developing, testing, and debugging applications in MS Access and SQL Server
• Training volunteers, students, and researchers on data entry, cleaning, and extraction
• Providing users with other flexible methods to access information with an emphasis on “self-service” and ad-hoc analytics
• Importing and processing heterogeneous and semi-structured datasets from Center collaborators and instruments into lab databases
• Database design, modeling and organization of data in a way that facilitates ease of use and good performance in data entry, reporting and analysis

• Writing documentation, protocols, and manuals
• Assistance with file and media management
• Overseeing student/volunteer technical projects

To be considered for this opportunity your application must demonstrate you meet both the minimum qualifications and additional qualifications listed below. Equivalent education and/or experience may substitute for minimum qualifications except when there are legal requirements, such as a license, certification, and/or registration. Applicants who do not meet these qualifications WILL NOT be forwarded to the Hiring Manager.

• Three years of professional experience in programming and/or work in an administrative/operational role or one year of experience as Computer Support Analyst I

• Bachelor's degree in Biology, Computer Science, Informatics, or related field
• Technical knowledge of PC, Mac, and Linux systems, including management and configuration of software and hardware
• Understanding of information security issues
• Knowledge of one or more of the following programming languages: (SQL, Python, E, C, VBA, etc.)
• Demonstrated excellence in written communication; ability to communicate technical concepts or instructions to nontechnical audiences; technical documentation skills; user liaison skills

• Familiarity with command-line shell and associated scripting language/Power Shell task automation
• Experience with hybrid backup strategy/data redundancy
• Experience managing software installations and licensing across a variety of software platforms
• Experience with SQL Server and SQL Server Management Studio (SSMS)
• Demonstrated experience with Microsoft Access and Visual Basic for…