Note: The job is a remote job and is open to candidates in USA. We Are Rosie is recruiting for an unnamed agency client seeking a Media Performance Analyst. The role analyzes media and marketing data, connects performance to business outcomes, and develops insights, dashboards, and recommendations to guide media investment and optimization.

Responsibilities

• 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
• Identify meaningful trends, performance drivers, anomalies, and opportunities within media and business data
• Investigate changes in performance to understand potential contributing factors, distinguishing between correlation and demonstrated causation
• Evaluate differences in performance across markets, channels, and campaigns to help inform media 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 overall business performance
• Proactively surface questions and areas for further investigation rather than relying solely on 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
• Work with internal teams to improve data accessibility, reporting efficiency, and the usability of performance dashboards
• Create clear, concise presentations of analytical findings for internal teams and client stakeholders
• Support automation of recurring data preparation, analysis, and reporting processes
• Help develop automated workflows within dashboards to streamline the review, approval, and implementation of media optimization recommendations and investment shifts

Skills

• We value demonstrable capabilities over specific years of experience
• Candidates with less experience who demonstrate strong technical expertise, analytical capabilities, and problem-solving skills
• 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
• Strong data wrangling skills, including cleaning, transforming, combining, and analyzing large datasets using SQL or comparable tools
• 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
• Experience using AI-assisted analytical tools and workflows for data preparation, wrangling, automation, and analysis, with appropriate attention to accuracy, validation, and data privacy
• 4–6 years of relevant experience
• Experience with macros and VBA (Visual Basic for Applications)
• 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 in a 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)

Benefits

• Remote in the US, but must be available during EST hours

Company Overview