Remote Media Analytics & Optimization Specialist

We Are Rosie, LLC; Oregon; Hybrid; USD 94,000 - 107,000; Part time

Job summary

We Are Rosie, LLC seeks a Media Performance Analyst to transform complex media data into actionable insights that guide strategy, investment, and optimization decisions. The role is hands-on, data-focused, and collaborative with planning, activation, and measurement teams.

The ideal candidate will work with large datasets, identify performance trends, and translate findings into clear recommendations, while leveraging AI tools to accelerate analysis and ensure data privacy.

Qualifications

• Strong technical proficiency with messy, incomplete datasets to produce reliable analyses.
• Advanced Excel skills and proficiency with Power BI/Tableau for dashboards and reporting.
• SQL or similar data manipulation skills; Python is a plus.
• Ability to translate analytical findings into clear business recommendations for nontechnical audiences.
• Experience working with marketing data and multi-source data integration is highly valued.

Responsibilities

• Wrangle, clean, organize, and reconcile data from multiple sources (media platforms, analytics, reports).
• Analyze media investment and performance across channels, markets, and time periods.
• Develop repeatable analytical processes to improve efficiency and accuracy.
• Create and maintain dashboards and reports in Power BI/Tableau/Excel.
• Present insights and recommended actions to internal teams and clients.

Skills

Analytical mindset

Data storytelling

Problem solving

Attention to detail

Education

Bachelor's degree in a quantitative field

Tools

Power BI

Tableau

Excel

SQL

Python

Job description

We Are Rosie, LLC seeks a Media Performance Analyst to transform complex media data into actionable insights that guide strategy, investment, and optimization decisions. The role is hands-on, data-focused, and collaborative with planning, activation, and measurement teams.

The ideal candidate will work with large datasets, identify performance trends, and translate findings into clear recommendations, while leveraging AI tools to accelerate analysis and ensure data privacy.