Media Performance Analyst

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.

• 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.

Reporting Visualization & Business Intelligence

• 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.

Qualifications :

Required

We value demonstrable capabilities over specific years of experience. While 46 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.

• Experience using AI-assisted analytical tools and workflows for data preparation wrangling automation and analysis with appropriate attention to accuracy validation and data privacy.

Additional Information :

What Success Looks Like

• Media and client performance data can be analyzed more efficiently and consistently even when sourced from disparate or imperfect reporting systems.

• Planning and investment teams have greater visibility into the factors influencing performance across channels markets and campaigns.

• Analytical findings go beyond reporting what happened to help explain potential performance drivers implications for paid media strategy and opportunities for optimizations to improve business outcomes.

• Dashboards and recurring analyses provide reliable accessible information that supports faster and better-informed decisions.

• The agency develops more scalable analytical capabilities that strengthen its performance-first approach to media planning investment and optimization.

The Ideal Candidate

You are as interested in understanding why performance changed as you are in reporting what changed. You enjoy working with data are resourceful in finding ways to organize and analyze it and know how to turn complex findings into insights that others can act on.

You understand that the value of analytics is not simply producing reports or dashboards but helping teams make better decisions and deliver stronger business outcomes.

We Are Rosie provides strategic consulting and talent solutions for the marketing industry. We partner with more than 200 of the worlds 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 thats 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.and Adweeks 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.

Remote Work :

Yes

Employment Type :

Contract