Programmatic Analyst

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. 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. Department: Global Programmatic Reports to: Programmatic Operations Manager Location: New York, New York Hybrid/Remote/In-Person: Hybrid Terms and conditions: Permanent, Full-time Annual Salary: $90,000-$120,000 Key Responsibilities Dashboards & Business Intelligence 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. Programmatic Yield & Revenue Optimization 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. Identity, Signals & Addressability 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. Forecasting & Finance Support 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. Stakeholder Management & Industry Insight 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. About You 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 have: 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. How to Apply We know there are great candidates who might not check all these boxes or who possess important skills we haven’t thought of. If that’s you, we encourage you to apply and tell us about yourself. All candidates interested in applying should upload a resume and cover letter. Compensation and Benefits Salary: TBD annually with commercial incentive 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(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 Commuter benefits Work/Life balance: Flexible hybrid schedule Culture & Wellbeing 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. Learning & Development 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. Sustainability 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.