Programmatic Analytics Specialist

The Guardian US; New York (NY); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Headspace subscription

401(k) Match

Healthcare coverage (medical, vision,

Job summary

The Guardian US in New York, NY is seeking a highly analytical Programmatic Analyst to transform large datasets into insights that enhance revenue, yield, and operational efficiency across our programmatic ecosystem.

You will design dashboards, write BigQuery/SQL queries, and collaborate with Commercial, Product, Sales and Finance to drive pricing decisions and strategy. Hybrid work arrangement in NYC.

Qualifications

• Bachelor's degree or equivalent practical experience.
• 2–5 years of experience in programmatic advertising, yield analytics, business intelligence, or revenue operations.
• Strong proficiency with Excel/Google Sheets and SQL queries (BigQuery, Snowflake, etc.).
• Hands-on experience with Google Ad Manager (GAM) and BI tools (Looker Studio, Tableau, Power BI).
• Proven ability to turn large datasets into actionable yield and revenue strategies.

Responsibilities

• Design, build, and maintain scalable reporting dashboards (Looker Studio, Tableau, Power BI) to track daily programmatic revenue, eCPMs, fill rate, bid density, win rate, and viewability.
• Write custom queries in BigQuery/SQL to combine ad server log data with partner APIs, improving data quality and automating manual reporting.
• Deliver regular performance reports and ad-hoc quantitative analyses to leadership and cross-functional teams.
• Analyze large datasets across supply stack to identify yield bottlenecks, pricing adjustments, and monetization opportunities.
• Monitor supply-side delivery health metrics to detect issues and revenue discrepancies in real time.

Skills

Programmatic advertising

Yield analytics

Revenue operations

SQL queries

Excel/Google Sheets

BI tools

Education

Bachelor's degree or equivalent practical experience

Tools

BigQuery

Snowflake

Looker Studio

Tableau

Power BI

Google Ad Manager

Job description

The Guardian US in New York, NY is seeking a highly analytical Programmatic Analyst to transform large datasets into insights that enhance revenue, yield, and operational efficiency across our programmatic ecosystem.

You will design dashboards, write BigQuery/SQL queries, and collaborate with Commercial, Product, Sales and Finance to drive pricing decisions and strategy. Hybrid work arrangement in NYC.