Posted over 1 year agoSummary:Note: This position will only work about 1-4 hours per month. The hours might increase in the future if desired.The Piracy Data Analyst is a generally awesome individual who creates and manages reports in Google Sheets, reviews data for accuracy and quality, and emails reports to clients on a recurring schedule. This is a very small and relaxed organization.This role is for an independent contractor (a contractor is not an employee, does not receive benefits of any kind, and will be paid a flat hourly rate with no taxes withheld, so please be sure you're familiar with independent contractor rules and regulations in your locale)Requires spreadsheet skills (see “Required skills” and “Sample task” below for details)Remote (you’ll need your own computer and internet connection)Flexible scheduleRequires signing a non-disclosure agreement, non-compete agreement, work contract, tracking time and sending invoices for compensation, etc.$12 USD per hourOur clientele includes producers of explicit content that sometimes involves taboo subject matter (BDSM, kink, fetishism, etc.) so you will need to be cool with thatResponsibilities:Spreadsheet operations, data quality control, sending reports. We don’t micromanage, so ownership and conscientiousness are important. That said, we’re happy to support you whenever you’d like help with a technical or philosophical question.Required skills:We appreciate creativity, so we’re open to your suggestions about how to do what we do better.English fluencyWorking with spreadsheet dataSortingFilteringPerforming basic arithmetic in the correct order of operationsWriting and debugging formulasConditional formattingData validationCross-checking listsFinding and removing duplicate dataCreating chartsCreating pivot tablesUsing Google Sheets add-ons when appropriateChecking for errors and omissions (very important)Emailing reports to clients (we will provide you with a company email account to use)Other related activitiesSchedule:The hours are somewhat flexible. For example, you may have one hour of work to do and a day or so to do it in per month. The work will usually need to be done around the end and/or beginning of each month. No time zone restrictions.Location:Anywhere with reliable internet access. As a remote independent contractor, you will need to supply your own computer equipment and internet connection and work independently.What to expect after you apply:We won’t respond to all applications but if we’d like to speak with you further, you’ll most likely hear from us within a month.Sample task:Below is a timed task meant to assess your aptitude for the work. It involves starting with dummy data in a spreadsheet, adding data, modifying the data and sheet, and visualizing the data. If you can complete it in twenty minutes or less, please record a screencast of yourself performing the task and send it with your resume, cover letter, or both to email@example.com.Create a copy of this Google spreadsheet.Rename the copy with the current month and yearClip all text that’s longer than the default column widthFreeze the top rowAdd filters to each columnAdd a formula in column B (“Domain”) that extracts the top-level domain from each entry in the URL column (feel free to Google this rather than writing the formula from scratch; if it works, it works)Add data validation to the “Tube or Torrent” column so that only “Tube” or “Torrent” can be enteredRandomly populate that column with a mixture of Tube and Torrent for all links in the spreadsheet (none of them are actually tube or torrent, so you can just make this up)Add the word Yes to half of the cells in the “Notice sent?” columnAdd random dates to the “Date notice sent?” column and choose a date format for the columnRandomly populate the “Content removed?” column with either yes or no for each cellAdd the word “Yes” to 20% of the cells in the “Escalated?” columnAdd a tab to the spreadsheet called "Summary"On the Summary tab, create three dynamic pie charts to show: 1) the number and percentage of links that have a “Yes” and “No” in the “Notice sent?” column, 2) the number and percentage of links that have a “Yes” and “No” in the “Content removed?” column, 3) the number and percentage of links that are Tube versus TorrentCreate a dynamic bar graph to show the number and percentage of links from the ten domains with the greatest number of linksAdd a dynamic summary table showing all of the above data in text format, without visualization, using calculations to populate the data from the spreadsheet automaticallyGive firstname.lastname@example.org comment-level access to the spreadsheet without sending an access notificationAdd all three pie charts, the bar graph, and the summary table into your application emailInclude a link to the spreadsheet in your emailHave a great day!