Media Lab Operations Coordinator & Analyst

Key Responsibilities:   Media Agency Coordination & Governance  Engage our media agencies to ensure their day-to-day work is flawless and lead monthly/quarterly project management to ensure all agency deliverables are reported correctly and on time and spend is validated against invoices. . Project Tracking : Manage work streams related to staffing, financial accountability, and agency quality including budget forecasting for projects and PO requests  Compliance & Audits: Coordinate bi-annual compliance checks across regions (NA/EMEA) and organize documentation for Global Procurement Organization (GPO) or audit requests. Governance Maintenance: Update agency governance pillars, including links, resources, and policies to ensure they are current for all stakeholders. Stakeholder Communication: Prepare presentations for senior management and monitor PMM feedback scores, escalating unaddressed issues. Agency Management: Lead core work streams to understand media performance by campaign size and tiering to shape overall Media Operations strategy.   Media Analyst  Play a pivotal role in supporting the global media team through business analysis of our forecasted and actual spend data. Understanding when a new data set appears and how to move from forecast, planned, and actual spend changes the nature of how we report. Media Spend Dashboards: Maintain and optimize dashboards of key reporting stats for executive leadership and internal stakeholders to ensure forecasting accuracy. Business Analysis: Analyze forecasted vs. actual spend data and develop narratives explaining how reporting shifts across forecast, planned, and actual phases. Reporting Supplements: Work with large publishers to supplement missing data in reporting when necessary. Create compelling data narratives that tell the story behind the numbers. Access, query, and extract data from various internal data sources, including relational databases (SQL, MySQL, PostgreSQL, Oracle), data warehouses, APIs, and spreadsheets. Develop and optimize SQL queries to retrieve specific datasets for analysis. Translate business questions into analytical problems and develop appropriate solutions. Identify and resolve data quality issues, inconsistencies, and discrepancies. Knowledge, Skills + Experience  2-3 years within a marketing discipline (media agency or client-side) with specific experience in media, marketing, and advertising technology. Technical Proficiency: SQL skills for extracting data from multiple sources; superior Google Sheets/Microsoft Excel skills; familiarity with BigQuery, Google Cloud, and ETL processes. Analytical Mindset: Ability to translate business questions into analytical problems and create compelling data narratives. Communication: Strong written and verbal communication skills with the ability to convey complex findings to cross-functional teams and senior management. Operational Excellence: Detail-oriented self-starter with a high level of accuracy, timeliness, and demonstrated problem-solving skills. Bonus: Programming experience (Python, Javascript, App Script) is a plus. #LI-AF1