Remote Media Performance Analyst — Data Insights & Optimization

We Are Rosie, LLC; United States; Remote; USD 94,000 - 107,000; Full time

Job summary

We Are Rosie, LLC in the United States is seeking a Media Performance Analyst to turn complex media and marketing data into actionable insights. You will wrangle data from diverse sources, build dashboards, and support optimization decisions across campaigns and markets.

The ideal candidate brings strong Excel, SQL, Python, and visualization skills, with experience in paid media metrics and a track record of turning data into business impact.

Qualifications

• Strong technical proficiency with complex datasets to produce reliable analyses.
• Advanced Excel: formulas, pivot tables, Power Query; VBA a plus.
• Strong data wrangling: SQL, Python; large datasets.
• Dashboards: Power BI, Tableau; data integration and automation.
• Interpret findings; communicate clearly to nontechnical audiences.
• Attention to detail; able to manage multiple priorities.
• Familiarity with paid media metrics (Google Ads, Meta) is valuable.
• Experience in media or marketing analytics a plus; MMM, attribution, etc.
• Geographic/DMA data experience is a plus.
• Experience with AI-assisted analytics workflows.

Responsibilities

• Collect, clean, organize, and reconcile data from multiple sources.
• Establish consistent definitions, classifications, and reporting structures with cross-functional teams.
• Analyze media investment and performance across channels and markets.
• Connect performance data to business outcomes such as leads, appointments, and revenue.
• Develop repeatable analytical processes to improve efficiency and accuracy.
• Create dashboards and visualizations to communicate insights to stakeholders.
• Automate recurring data prep, analysis, and reporting tasks.

Skills

Advanced Excel

SQL

Python

Power BI

Tableau

Data wrangling

Data visualization

Tools

Power Query

VBA

Data integration

Workflow automation

Job description

We Are Rosie, LLC in the United States is seeking a Media Performance Analyst to turn complex media and marketing data into actionable insights. You will wrangle data from diverse sources, build dashboards, and support optimization decisions across campaigns and markets.

The ideal candidate brings strong Excel, SQL, Python, and visualization skills, with experience in paid media metrics and a track record of turning data into business impact.