Media Data Analyst

About this role

Technology & Analytics — The Builders and Translators

We are a 1,000-piece puzzle. Each of us is essential, interconnected, and intentionally designed. Together we create something powerful: media that matters, growth that lasts, and a culture we are proud to build.

At Attention Arc, we exist to restore intention to media. As part of our Technology & Analytics team, the Builders and Translators, you help transform raw media data into clarity, action, and measurable growth. This team architects the systems, reporting frameworks, and analytical models that unify performance across channels, helping the agency move smarter, faster, and with greater precision.

The Media Data Analyst plays a critical role in turning complexity into insight. This role blends analytical rigor with strategic thinking, partnering across Planning, Activation, Research, and Account teams to uncover performance drivers, surface opportunities, and help shape smarter media decisions. You will not simply report on performance. You will help define what performance means and what happens next.

WHAT YOU’LL DO

You’ll build the analytical foundation that helps our teams make more intentional media decisions through scalable reporting, thoughtful analysis, and clear storytelling.

Data Visualization & Storytelling

• Design and maintain dashboards and visualizations that communicate media performance clearly and effectively

• Translate large, multi-channel datasets into intuitive reporting frameworks that support decision-making

• Distill campaign performance into actionable insights that drive optimization and strategic recommendations

• Present findings in ways that simplify complexity and create alignment across teams and clients

Advanced Analytics & Data Management

• Write and optimize SQL queries to extract, transform, and analyze large datasets

• Leverage Snowflake to support scalable, efficient data analysis and reporting workflows

• Ensure data accuracy, integrity, and reliability across reporting pipelines and dashboards

• Identify trends, anomalies, and performance drivers across audiences, channels, and campaigns

• Support the evolution of internal analytics processes, automation opportunities, and reporting best practices

Performance & Strategic Insight

• Conduct analytical deep-dives across campaign performance, audience behavior, and media effectiveness

• Evaluate full-funnel performance across the ARC framework: Attract, Resonate, Convert

• Translate analytical findings into clear recommendations that influence media strategy and optimization decisions

• Help teams connect performance data to broader business goals and client objectives

Collaboration & Partnership

• Partner with Media Planning, Activation, Research, and Account teams to support strategic decision-making

• Contribute analytics expertise to client conversations and performance narratives

• Collaborate cross-functionally to solve business challenges through data and…