Takedown Digital, LLC · Nov 5th 2018
Headquarters: Remote URL:
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.
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.
We appreciate creativity, so we’re open to your suggestions about how to do what we do better.
Working with spreadsheet data
Performing basic arithmetic in the correct order of operations
Writing and debugging formulas
Finding and removing duplicate data
Creating pivot tables
Using Google Sheets add-ons when appropriate
Checking for errors and omissions (very important)
Emailing reports to clients (we will provide you with a company email account to use)
Other related activities
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.
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.
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 firstname.lastname@example.org.
Create a copy of this Google spreadsheet.
Rename the copy with the current month and year
Clip all text that’s longer than the default column width
Freeze the top row
Add filters to each column
Add 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 entered
Randomly 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?” column
Add random dates to the “Date notice sent?” column and choose a date format for the column
Randomly populate the “Content removed?” column with either yes or no for each cell
Add the word “Yes” to 20% of the cells in the “Escalated?” column
Add 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 Torrent
Create a dynamic bar graph to show the number and percentage of links from the ten domains with the greatest number of links
Add a dynamic summary table showing all of the above data in text format, without visualization, using calculations to populate the data from the spreadsheet automatically
Give email@example.com comment-level access to the spreadsheet without sending an access notification
Add all three pie charts, the bar graph, and the summary table into your application email
Include a link to the spreadsheet in your email
Have a great day!
To apply: Send the screencast and reports along with your resume, cover letter, or both to firstname.lastname@example.org.