[Hiring] Media Performance Analyst @We Are Rosie

Role Description

Our agency client is seeking a Media Performance Analyst to help turn complex media and marketing data into meaningful insights that inform strategy, investment, and optimization decisions. This is a hands-on analytical role requiring strong technical capabilities, intellectual curiosity, and an understanding of how media investment contributes to business outcomes.

The ideal candidate is comfortable working with large, imperfect datasets, identifying performance trends and opportunities, and translating findings into clear, actionable recommendations. Working closely with media planning, investment, and measurement teams, this individual will help strengthen our ability to evaluate performance across channels, campaigns, markets, and audiences, with a focus on driving measurable business results.

Engagement Details

• Rate: $68-78/hr
• Location: Remote in the US, but must be available during EST hours
• Hours: 20-25 hrs/week with bandwidth to flex up to 30 as needed
• Contract: 1-2 months, but possibility to extend if things are going well

Qualifications

• Demonstrable capabilities over specific years of experience; 4–6 years of relevant experience is ideal.
• Strong technical proficiency, analytical capabilities, and problem-solving skills.
• 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.
• Ability to interpret analytical findings and communicate recommendations clearly to nontechnical audiences.
• Strong attention to detail, analytical curiosity, and the ability to manage multiple priorities.
• Familiarity with media or marketing performance metrics and their relationship to business outcomes.
• Experience at a media agency, marketing agency, or in a performance-focused marketing organization is an advantage.
• Experience working with geographic and market-level data, including Designated Market Area (DMA) analysis, is a plus.
• Experience using AI-assisted analytical tools and workflows for data preparation, wrangling, automation, and analysis.

Requirements

• Collect, clean, organize, and reconcile data from multiple sources.
• Work with complex datasets to establish consistent definitions, classifications, and reporting structures.
• Analyze media investment and performance across various dimensions.
• Connect media performance data with available business outcomes.
• Collaborate with media planning, investment, and measurement teams.
• Leverage AI and other analytical tools to accelerate data wrangling and analysis.
• Develop repeatable analytical processes that improve efficiency and accuracy.
• Identify meaningful trends, performance drivers, anomalies, and opportunities.
• Investigate changes in performance to understand potential contributing factors.
• Evaluate differences in performance across markets, channels, and campaigns.
• Translate analytical findings into clear insights and recommended actions.
• Develop and maintain analytical reports, dashboards, and visualizations.
• Help establish consistent performance metrics and reporting methodologies.
• Create clear, concise presentations of analytical findings for stakeholders.
• Support automation of recurring data preparation, analysis, and reporting processes.

Benefits

• Opportunity to work remotely.
• Flexible hours with potential for increased workload.
• Possibility for contract extension based on performance.

Company Description

We Are Rosie provides strategic consulting and talent solutions for the marketing industry. We partner with more than 200 of the world’s biggest brands and agencies to help them solve unique marketing challenges with the best people, swiftly and at scale. Founded by former advertising executive Stephanie Nadi Olson in 2018, We Are Rosie is on a mission to redefine how marketing works, with an inclusive, human-centric approach that’s better for business and better for marketers.

Our company has been recognized as an industry trailblazer and earned many accolades, including being named to the 2023 Global Top 100 Inspiring Workplaces, the Inc. 5000 2022, and Adweek’s Fastest Growing Agencies in 2021.

We Are Rosie is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, marital status, or any other status protected under federal, state, or local law.