Computer Support Analyst

Occasional Telework

Seattle, WA

Part time

REQ-

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.

Systems Management 65%

• 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 fileservers, 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.)

Database Management 25%

• 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 administration

• Database design, modeling and organization of data in a way that facilitates ease of use and good performance in data entry, reporting and analysis

Other 10%

• 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.

• 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

• Applicants who do not meet these qualifications WILL NOT be forwarded to the Hiring Manager.

• 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…