Media Performance Analyst

We Are Rosie•New York, NY

8h•$68 - $78•Remote

About The Position

The Media Performance Analyst turns complex media and marketing data into insights that inform strategy, investment, and optimization. This hands-on analytical role works with large, sometimes incomplete or inconsistent datasets to identify performance trends and opportunities, connect media investment with business outcomes, and communicate actionable recommendations. The analyst collaborates with media planning, investment, measurement, Strategy, Activation, and client teams to evaluate performance across channels, campaigns, markets, audiences, and time periods. The role includes collecting, cleaning, reconciling, and analyzing data from media platforms, client performance reports, analytics tools, and third-party providers. The analyst develops repeatable analytical processes, reports, dashboards, visualizations, and presentations, and supports automation of data preparation, analysis, reporting, and media optimization workflows. AI-assisted tools may be used with appropriate validation, judgment, and attention to data privacy. This is a remote U.S. contract engagement for 1–2 months, with the possibility of extension. The expected commitment is 20–25 hours per week, with flexibility to increase to 30 hours as needed. The analyst must be available during Eastern Time hours. The stated rate is $68–$78 per hour.

Requirements

Strong technical proficiency, analytical capabilities, and problem-solving skills, including the ability to produce reliable analyses and actionable insights from complex, incomplete, or inconsistent datasets.
Advanced Excel skills, including complex formulas, pivot tables, Power Query, and data manipulation.
Strong data wrangling skills, including cleaning, transforming, combining, and analyzing large datasets using SQL or comparable tools.
Proficiency developing dashboards, reports, and visualizations using Power BI, Tableau, or comparable platforms.
Ability to interpret analytical findings, identify business implications, and communicate recommendations clearly to nontechnical audiences.
Strong attention to detail and analytical curiosity.
Ability to manage multiple priorities in a fast-paced, collaborative environment.
Experience using AI-assisted analytical tools and workflows for data preparation, wrangling, automation, and analysis, with attention to accuracy, validation, and data privacy.

Nice To Haves

Four to six years of relevant experience is ideal; candidates with less experience may be considered if they demonstrate strong technical expertise, analytical capabilities, and problem-solving skills.
Experience with Excel macros and VBA (Visual Basic for Applications).
Python proficiency.
Experience with data integration, workflow automation, and streamlining reporting and approval processes.
Familiarity with media or marketing performance metrics and their relationship to business outcomes.
Experience with paid media platforms such as Google Ads and Meta.
Experience at a media agency, marketing agency, or performance-focused marketing organization.
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.

Responsibilities

Collect, clean, organize, and reconcile data from media platforms, client performance reports, analytics tools, and third-party data providers.
Establish consistent data 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.
Use AI and other analytical tools to accelerate data wrangling and analysis, validating findings, ensuring accuracy, and protecting data privacy.
Develop repeatable analytical processes that improve efficiency, consistency, and accuracy.
Identify performance trends, drivers, anomalies, and opportunities in media and business data.
Investigate performance changes and potential contributing factors, distinguishing correlation from demonstrated causation.
Evaluate performance differences across markets, channels, and campaigns to inform investment and optimization decisions.
Translate analytical findings into clear insights, business implications, and recommended actions.
Partner with Strategy and Activation teams to identify opportunities to improve investment effectiveness and business performance.
Proactively surface questions and areas for further investigation.
Develop and maintain reports, dashboards, and visualizations using tools such as Power BI, Tableau, and Excel.
Help establish consistent performance metrics and reporting methodologies across clients and campaigns.
Improve data accessibility, reporting efficiency, and dashboard usability in collaboration with internal teams.
Present analytical findings clearly and concisely to internal teams and client stakeholders.
Support automation of recurring data preparation, analysis, and reporting processes.
Help develop automated dashboard workflows to streamline review, approval, and implementation of media optimization recommendations and investment shifts.