Media Performance Analyst

Responsibilities

• Data Wrangling & Analysis
• Collect, clean, organize, and reconcile data from multiple sources, including media platforms, client performance reports, analytics tools, and third-party data providers.
• Work with complex datasets to establish consistent definitions, classifications, geographic mappings, and reporting structures, in collaboration with Strategy/Planning, Activation, and the Client.
• Analyze media investment and performance across channels, campaigns, markets, audiences, and time periods.
• Connect media performance data with available business outcomes, including leads, appointments, conversions, sales, and revenue.
• Collaborate with media planning, investment, and measurement teams to address business questions and support performance assessments and optimization decisions.
• Leverage AI and other analytical tools to accelerate data wrangling and analysis, applying appropriate judgment to validate findings, ensure accuracy, and protect data privacy.
• Develop repeatable analytical processes that improve efficiency, consistency, and accuracy.
• Performance Insights & Recommendations
• Identify meaningful trends, performance drivers, anomalies, and opportunities within media and business data.

Requirements

• We value demonstrable capabilities over specific years of experience. While 4–6 years of relevant experience is ideal, candidates with less experience who demonstrate strong technical expertise, analytical capabilities, and problem-solving skills will also be considered.
• Strong technical proficiency, analytical capabilities, and problem-solving skills, with the ability to work with complex, incomplete, or inconsistent datasets to produce reliable analyses and actionable insights.
• Advanced Excel skills, including complex formulas, pivot tables, Power Query, and data manipulation. Experience with macros and VBA (Visual Basic for Applications) is a plus.
• Strong data wrangling skills, including cleaning, transforming, combining, and analyzing large datasets using SQL or comparable tools. Python proficiency is a plus.
• Proficiency in developing dashboards, reports, and data visualizations using Power BI, Tableau, or comparable platforms, including experience with data integration, workflow automation, and streamlining reporting and approval processes.
• Ability to interpret analytical findings, identify business implications, and communicate recommendations clearly to nontechnical audiences.
• Strong attention to detail, analytical curiosity, and the ability to manage multiple priorities in a fast-paced, collaborative environment.
• Familiarity with media or marketing performance metrics and their relationship to business outcomes is valuable, including experience with paid media platforms such as Google Ads and Meta.
• Experience at a media agency, marketing agency, or in a performance-focused marketing organization is an advantage, as is exposure to Marketing Mix Modeling, attribution, incrementality testing, or other marketing measurement approaches.
• Experience working with geographic and market-level data, including Designated Market Area (DMA) analysis, is a plus.