Programmatic Analyst
The Guardian US
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
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
Education
Tools
Job description
The Guardian is a global news organization that delivers fearless, independent journalism. From breaking news and award-winning investigations, to in-depth coverage of technology, sports, film, culture and lifestyle, the Guardian offers a global view that deepens our audiences' understanding of America and the world.
Headquartered in New York City, 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'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.
Reports to: Programmatic Operations Manager
Location: New York, New York
Hybrid/Remote/In-Person: Hybrid
Terms and conditions: Permanent, Full-time
- 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.
- Analyse 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.
- 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.
- Salary: TBD annually with commercial incentive
- 20 days of vacation leave in addition to 12 company holidays and 2 personal days
- Free Headspace subscription for you and your family members(Headspace is a company that offers evidence-based meditation and mindfulness tools, mental health coaching, therapy, psychiatry, and EAP services)
- 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
- Work/Life balance: Flexible hybrid schedule
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 offer great tools to help you prioritize your wellbeing including a free Headspace subscription and access to an Employee Assistance Program.
We encourage personal and professional growth. Employees have access to a broad range of tools and solutions, and we are happy to support the pursuit of professional qualifications through vocational courses and apprenticeships.
Our goal is to become an environmentally regenerative company and we have signed up to a sustainability vision and strategy to reach it. Find more information about sustainability at GNM here.
***
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.
AI generated content must not be presented as your own work. Please review our guidance on the use of AI in your application here.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
