Note: The job is a remote job and is open to candidates in USA. HH Global is a global leader in responsible marketing activation services, helping brands achieve measurable impact. The Media Lab Operations Coordinator & Analyst will coordinate media agency activities, manage project tracking, and analyze media spend data to support the global media team.
Responsibilities
- 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
- Manage work streams related to staffing, financial accountability, and agency quality including budget forecasting for projects and PO requests
- Coordinate bi-annual compliance checks across regions (NA/EMEA) and organize documentation for Global Procurement Organization (GPO) or audit requests
- Update agency governance pillars, including links, resources, and policies to ensure they are current for all stakeholders
- Prepare presentations for senior management and monitor PMM feedback scores, escalating unaddressed issues
- Lead core work streams to understand media performance by campaign size and tiering to shape overall Media Operations strategy
- Play a pivotal role in supporting the global media team through business analysis of our forecasted and actual spend data
- Maintain and optimize dashboards of key reporting stats for executive leadership and internal stakeholders to ensure forecasting accuracy
- Analyze forecasted vs. actual spend data and develop narratives explaining how reporting shifts across forecast, planned, and actual phases
- 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
Skills
- 2-3 years within a marketing discipline (media agency or client-side) with specific experience in media, marketing, and advertising technology
- SQL skills for extracting data from multiple sources; superior Google Sheets/Microsoft Excel skills; familiarity with BigQuery, Google Cloud, and ETL processes
- Ability to translate business questions into analytical problems and create compelling data narratives
- Strong written and verbal communication skills with the ability to convey complex findings to cross-functional teams and senior management
- Detail-oriented self-starter with a high level of accuracy, timeliness, and demonstrated problem-solving skills
- Programming experience (Python, Javascript, App Script) is a plus
Company Overview