Responsibilities

• Produce and assist with the construction of dashboards, regular campaign reporting, campaign wrap reports, bespoke analyses that help with media strategy and planning.
• Collaborate with strategy teams on audience discovery/insights, social listening, and other ad-hoc tasks to provide a lens into brand communications.
• Leverage the DIKW (data, information, knowledge, wisdom) framework to provide valuable strategic and analytic outputs into a well-organized, simplified, and consumable package (MS Excel, Apple Keynote, etc.)
• Identify and lead the implementation of data solutions required to enable the effective measurement, reporting, and optimization of media campaigns.
• Develop and maintain dashboards in Looker Studio and other visualization platforms, ensuring accuracy, usability, and performance.
• Utilize SQL (BigQuery or similar cloud data warehouses) to extract, validate, and analyze marketing performance data.
• Manage and optimize data aggregation and ETL workflows (e.g., Improvado, Supermetrics, or similar platforms) to ensure clean and reliable reporting inputs.
• Explore and adopt emerging analytics, automation, and AI-assisted tools to improve workflow efficiency, reporting scalability, and analytical output.
• Investigate data discrepancies and proactively trace issues to their source to maintain data integrity and reporting accuracy.