Courier Newsroom

Data Analyst (Contract)

Courier Newsroom United States · $94K/yr

Newspaper Publishing · 51-200 employees

6 h ago
Remote data-analyst Mid (2-5 yrs) Contractor United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

You will build and maintain reporting dashboards to track core KPIs and perform on-demand analysis on subscriber, revenue, and voter data. The role involves collaborating with stakeholders to translate business requirements into technical solutions and cleaning complex datasets.

What they look for

SQL Python Looker BigQuery Data Analysis Dashboarding Data Extraction REST APIs Web Scraping Git Voter File Data Data Manipulation Google Workspace Reporting

Requirements

Candidates must have advanced SQL proficiency, Python scripting skills, and experience with data warehousing platforms like BigQuery. Proficiency in Looker for dashboarding and experience working with voter file data are also required.

Full description

Data Analyst (Contract)

📍 Remote (U.S.-based) | 💼 Contractor | 💰 $45 per hour

We're looking for an experienced data analyst to support our newsroom's data analytics needs on a contract basis.

Join Courier Newsroom - an organization that drives journalism and empowers communities.

At Courier Newsroom, we’re reinventing local media to inform and empower communities through impactful reporting. Our mission is rooted in civic engagement and equity—and we’re growing fast.

COURIER Newsroom is committed to building an inclusive workplace that values diverse perspectives and lived experiences. We strongly encourage women, people of color, individuals with disabilities, LGBTQ+ candidates, and those from all backgrounds to apply. As an equal opportunity employer, we strive to break down barriers and ensure every team member feels seen, heard, and supported.

What You'll Do

You'll build and maintain reporting dashboards that track our newsroom's core KPIs, alongside on-demand analysis covering subscriber data, platform metrics, revenue, and voter information. The role will also require turning complex & messy data into clean, well-organized datasets ready for analysis. We use Google Looker as our primary dashboarding platform; experience with notebooks (Jupyter, Google Colab, etc.) is a plus.

The role requires regular collaboration with fellow analysts and engineers, newsroom staff, and leadership stakeholders. You'll need to understand what they need, translate those requirements into technical solutions, and communicate progress clearly and maturely.

Technical Requirements

  • Advanced SQL proficiency: Be able to write efficient queries in SQL including CTEs, recursive queries, window functions, and pivoting/unpivoting of data
  • Python proficiency: Review and develop scripts for data manipulation and querying
  • Data extraction: Experience fetching data from REST APIs and web scraping when necessary
  • Looker: Create and maintain dashboards in the Looker platform
  • BigQuery or similar warehouse platform: Familiarity with fetching and managing data in Google BigQuery or equivalent enterprise data warehouse/lakehouse
  • Google Workspace: Experience working with the document, spreadsheet, and productivity tools within Google Workspace ecosystem
  • Version control: Standard git workflows
  • Voter File: Experience working with voter file data

What We're Looking For

Someone who can hit the ground running. You will be expected to manage your own time, communicate proactively when blockers arise, and work independently. In this fast paced environment, you will need to adapt to change accordingly.

To Apply

Send your resume and a brief note about relevant experience. Links to public repos or previous pipeline work are welcome but not required.

Similar roles