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 volunteers will be trained in the tools, skills and tasks required for their role.