Application: Open Doors Committee – Technical Volunteer

Position Title: Open Doors Committee – Technical Volunteer

Organization name: Organization for Transformative Works

Committee: Open Doors Committee

Reports to: Open Doors Chair, Open Doors Senior Technical Staff

Time Requirements: 3-6 hours/week

Term: 1 year

Role overview: Assist Open Doors with data wrangling fanworks archives to facilitate their import to the Archive of Our Own.

Key Responsibilities

  • Retrieve, verify and clean metadata from external fanworks archives and convert it to MySQL tables for import
  • Clean story files from external fanworks archives to remove outdated formatting and personal information
  • Optionally improve the Python scripts for data cleansing

Skills, experience and attributes

Technical

  • Essential: SQL language and usage of MySQL
  • Essential: Experience using Google Drive and Google Sheets
  • Nice to have: Python
  • Nice to have: Advanced Sheets/Excel skills

Other

  • Excellent attention to detail
  • Commitment to team building and working effectively as part of a small team
  • Ability to adapt to new software and procedures quickly

Training requirements:

Open Doors staff  will be trained in the tools, skills and tasks required for their role.