Data Analyst (Contract)

Courier Newsroom

11h • Remote

About The Position

Courier Newsroom is seeking an experienced data analyst to support the newsroom’s data analytics needs on a contract basis. The analyst will build and maintain reporting dashboards for core newsroom KPIs and conduct on-demand analysis of subscriber data, platform metrics, revenue, and voter information. The role also involves transforming complex or messy data into clean, well-organized datasets ready for analysis. Google Looker is the primary dashboarding platform; experience with notebooks such as Jupyter or Google Colab is a plus.

The analyst will collaborate regularly with fellow analysts and engineers, newsroom staff, and leadership stakeholders. They will understand stakeholder needs, translate requirements into technical solutions, communicate progress clearly and maturely, manage their time independently, raise blockers proactively, and adapt to change in a fast-paced environment.

Requirements

• Advanced SQL proficiency, including efficient queries using CTEs, recursive queries, window functions, and pivoting or unpivoting data.
• Proficiency in Python for reviewing and developing scripts for data manipulation and querying.
• Experience fetching data from REST APIs and performing web scraping when necessary.
• Experience creating and maintaining dashboards in Looker.
• Familiarity with Google BigQuery or an equivalent enterprise data warehouse or lakehouse platform.
• Experience with Google Workspace document, spreadsheet, and productivity tools.
• Experience with standard Git workflows.
• Experience working with voter file data.
• Ability to work independently, manage time, communicate proactively about blockers, and adapt to change.

Nice To Haves

• Experience with notebooks such as Jupyter or Google Colab.
• Links to public repositories or previous pipeline work are welcome but not required.

Responsibilities

• Build and maintain reporting dashboards tracking newsroom core KPIs in Google Looker.
• Conduct on-demand analysis of subscriber data, platform metrics, revenue, and voter information.
• Transform complex and messy data into clean, well-organized datasets ready for analysis.
• Review and develop Python scripts for data manipulation and querying.
• Fetch and manage data using BigQuery or a similar enterprise data warehouse or lakehouse platform.
• Extract data from REST APIs and use web scraping when necessary.
• Collaborate with analysts, engineers, newsroom staff, and leadership stakeholders to understand needs and translate requirements into technical solutions.
• Communicate progress clearly, manage time independently, proactively communicate blockers, and adapt to change.

What This Job Offers

• Education Level: No Education Listed