Programmatic Analyst

The Guardian • New York, NY

8d • $90,000 - $120,000 • Hybrid

About The Position

The Guardian is seeking a highly analytical and detail-oriented Programmatic Analyst to drive the growth of its programmatic advertising business. This role involves transforming large datasets into actionable insights to improve revenue, yield, and operational efficiency across the programmatic ecosystem. The analyst will work closely with the Programmatic Operations Manager and Head of Digital Optimisation, as well as cross-functional teams, to develop dashboards, analyze programmatic revenue, identify opportunities, and provide recommendations for strategic decision-making. The individual will become the subject matter expert on programmatic performance, explaining trends and opportunities to stakeholders.

Requirements

• 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 writing SQL queries (BigQuery, Snowflake, etc.)
• Hands-on experience with Google Ad Manager (GAM) and BI tools (Looker Studio, Tableau, Power BI)
• Proven track record of turning large datasets into actionable yield and revenue strategies
• Excellent communication skills with the ability to present complex data insights to non-technical stakeholders
• High attention to detail and ability to manage multiple analytical projects in a fast-paced environment
• Alignment with and commitment to The Guardian’s mission and values

Nice To Haves

• Practical familiarity with front-end web tech (HTML, JS, Chrome DevTools) to troubleshoot ad tags and render issues.
• Familiarity with Prebid.js, header bidding setups, and key IAB Tech Lab standards (OpenRTB, ads.txt, Sellers.json).
• Comfort using modern AI tools for rapid script generation, data manipulation, and building lightweight automation to streamline reporting and routine analytics tasks.

Responsibilities

• Design, build, and maintain scalable reporting dashboards (e.g., 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 processes.
• Deliver regular performance reports and ad-hoc quantitative analyses to leadership and cross-functional teams.
• Analyze large datasets across our supply stack (SSPs, DSPs, header bidding, PMPs) to identify yield bottlenecks, pricing adjustments, and monetization opportunities.
• Monitor supply-side delivery health metrics to detect fill drops, latency issues, or revenue discrepancies in real time.
• Partner with Commercial, Product, Sales, and Finance to conduct strategic analyses that inform pricing rules and sales strategies.
• Analyze the impact of identity, signal and addressability initiatives on revenue, match rates, bid density, CPM and RPM.
• Support testing and reporting for partners and initiatives such as Intent IQ, LiveRamp, UID2/EUID, TIDs and other identity-led monetisation opportunities.
• Help quantify the commercial value of new signals and make recommendations on scaling, pausing or further testing.
• Support revenue forecasting, partner cost modelling and monthly close processes where required.
• Work with Programmatic Operations Manager and Head of Digital Optimisation to provide clear analysis on revenue share partners, incremental uplift and cost/revenue performance.
• Help maintain accurate reporting for budget, forecast and actuals across programmatic channels.
• Translate complex programmatic data into clear, actionable insights and present recommendations to both technical and non-technical stakeholders.
• Research programmatic market trends, supply path optimization (SPO) dynamics, and emerging ad tech solutions to drive revenue growth.
• Promote and uphold The Guardian’s values and ethical standards in day-to-day decision-making.

Benefits

• 20 days of vacation leave in addition to 12 company holidays and 2 personal days
• Unlimited sick time
• Free Headspace subscription for you and your family members
• 401(k) Match
• Subsidized healthcare coverage including medical, vision, and dental
• Medical and Dependent Flexible Spending Accounts
• Generous parental leave with 100% pay
• Long Term and Short Term Disability insurance
• Life insurance
• Commuter benefits
• Flexible hybrid schedule

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree