Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

We're looking for a highly analytical and detail-oriented Programmatic Analyst to help drive the continued growth of The Guardian's programmatic advertising business. This role will be responsible for transforming large datasets into actionable insights that improve revenue, yield, and operational efficiency across our programmatic ecosystem. Working closely with the Programmatic Operations Manager and Head of Digital Optimisation and cross-functional teams, you'll develop dashboards, analyze programmatic revenue, identify opportunities, and provide recommendations that support strategic decision making. You'll become the subject matter expert on programmatic performance, helping stakeholders understand what is happening, why it's happening, and where opportunities exist.

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.

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
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.

Skills

Programmatic advertising
Yield analytics
Business intelligence
Revenue operations
Excel
Google Sheets
SQL
BigQuery
Snowflake
Google Ad Manager (GAM)
Looker Studio
Tableau
Power BI
Communication skills
Data analysis
HTML
JS
Chrome DevTools
Prebid.js
Header bidding
OpenRTB
ads.txt
Sellers.json
AI tools

Location

New York, New York

Work Type

Hybrid
Permanent
Full-time

Experience Level

2-5 years

Education Level

Bachelor's degree or equivalent practical experience

Salary/Compensations

$90,000-$120,000
TBD annually with commercial incentive

Benefits

20 days of vacation leave
12 company holidays
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
Access to an Employee Assistance Program
Support for professional qualifications through vocational courses and apprenticeships

About the Company

The Guardian is a global news organization that delivers fearless, independent journalism.
Guardian US is an entirely digital operation that seeks to engage US readers by combining the Guardian's international coverage with US voices and expertise.
Core coverage areas include the climate emergency, economic and racial inequality, digital privacy and much more.
Guardian US launched in 2011 and today has bureaus in New York, Washington DC, New Orleans and Los Angeles.
The Guardian is an independently owned, mission-driven organization, funded by readers around the globe.
It’s the talent, energy and commitment our people bring to The Guardian that make us who we are.
Across our business we have some of the most creative thinkers in media and beyond: award winning journalists, cutting edge commercial teams, digital talent and more.
We want everyone to feel like they belong at the Guardian and we champion diversity of thought.
You will also have the opportunity to hear unique insight from our journalists in our morning conference, a live discussion on the news story of the day.
We encourage personal and professional growth.
Our goal is to become an environmentally regenerative company and we have signed up to a sustainability vision and strategy to reach it.

Equal Opportunity

The Guardian is an Equal Opportunity Employer and does not discriminate on the basis of age, color, national origin, ethnic origin, citizenship status, disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, marital status, veteran status, or any other characteristic protected by federal, state, or local law in its employment policies.
In addition, the Guardian will provide reasonable accommodation for qualified individuals with disabilities.
We value and respect all differences (seen and unseen) in all people at the Guardian.
We aspire to have inclusive working experiences and an environment that reflects the audience we serve, where our people have equal access to career development opportunities, their voices are heard and can contribute to our future.