Media Performance Analyst

We Are Rosie•New York, NY

1d•Remote

About The Position

The Media Performance Analyst turns complex media and marketing data into insights that inform strategy, investment, and optimization decisions. This hands-on analytical role works with large, imperfect datasets and evaluates performance across channels, campaigns, markets, audiences, and time periods, connecting media investment to available business outcomes such as leads, appointments, conversions, sales, and revenue. Working with media planning, investment, measurement, Strategy, Activation, and client teams, the analyst identifies performance trends, drivers, anomalies, and opportunities, then translates findings into clear business implications and recommended actions. The role also develops and maintains reports, dashboards, visualizations, and repeatable or automated analytical workflows to improve the efficiency, consistency, and usability of performance analysis and decision-making. AI-assisted and other analytical tools may be used, with appropriate validation, accuracy, judgment, and data privacy safeguards. The engagement is remote within the United States, with availability during Eastern Time hours. It is a 1–2 month contract, with a possibility of extension, and is expected to require 20–25 hours per week, with flexibility to increase to 30 hours as needed. The stated rate is $68–$78 per hour.

Requirements

Demonstrable technical proficiency, analytical capabilities, and problem-solving skills; candidates with less experience may be considered if they demonstrate these capabilities.
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.
Strong data-wrangling skills, including cleaning, transforming, combining, and analyzing large datasets using SQL or comparable tools.
Proficiency developing dashboards, reports, and visualizations with Power BI, Tableau, or comparable platforms.
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 and analytical curiosity.
Ability to manage multiple priorities in a fast-paced, collaborative environment.
Availability during Eastern Time hours.

Nice To Haves

Four to six years of relevant experience is ideal, though candidates with less experience may be considered.
Experience with Excel macros and VBA.
Python proficiency.
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 with geographic and market-level data, including Designated Market Area (DMA) analysis.
Experience using AI-assisted analytical tools and workflows for data preparation, wrangling, automation, and analysis, with attention to accuracy, validation, and data privacy.

Responsibilities

Collect, clean, organize, and reconcile data from media platforms, client performance reports, analytics tools, and third-party 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 preparation and analysis, validating findings and protecting data privacy.
Develop repeatable analytical processes to improve efficiency, consistency, and accuracy.
Identify meaningful trends, performance 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 identify questions and areas for further investigation beyond predefined reporting requirements.
Develop and maintain analytical 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.
Help develop automated dashboard workflows for reviewing, approving, and implementing media optimization recommendations and investment shifts.