Media Data Analyst

Irvington, NY (On-site)

$75K/yr – $90K/yrMid Level2+ years expFull time

Posted 4 months ago

Top 1% of applicants do these two things.

The other 99% submit and hope. You're about to do something different.

Job Summary

Drive data-driven analytics for media planning and optimization across channels.

  • Must-have: Advanced SQL and Snowflake expertise for scalable analysis.
  • Standout: Cross-functional collaboration to inform strategy with data-driven insights.

Job Description

Responsibilities

  • building scalable analytics solutions that inform strategy and fuel smarter media decisions.
  • Design and build interactive data visualizations and dashboards to communicate media performance metrics
  • Translate large, multi-channel datasets into intuitive, actionable reporting frameworks
  • Distill campaign performance into clear insights that drive optimization and strategic shifts
  • Write and optimize SQL queries to extract, transform, and analyze large datasets
  • Leverage the Snowflake data warehouse platform for scalable, efficient data analysis
  • Ensure accuracy, integrity, and reliability across reporting pipelines and dashboards
  • Identify trends, anomalies, and performance drivers across audience segments and media channels
  • Conduct analytical deep-dives on campaign performance, audience behavior, and media effectiveness
  • Evaluate full-funnel performance across the ARC model (Attract, Resonate, Convert) to uncover optimization opportunities

Requirements

  • 2–4+ years of experience in media analytics, advertising analytics, marketing analytics, or business intelligence
  • Advanced proficiency in SQL for querying, data transformation, and performance optimization
  • Hands-on experience working within Snowflake data warehouse environments
  • Experience building dashboards in tools such as Tableau, Sigma, Looker, Power BI, or similar platforms
  • Strong understanding of media KPIs across paid media channels (impressions, CTR, CPA, ROAS, reach/frequency, etc.)
  • Ability to synthesize complex datasets into actionable insights and clear business recommendations
  • Experience working with large, multi-source datasets (platform APIs, CRM data, web analytics, etc.)
  • Strong analytical and problem-solving skills with high attention to detail
  • Comfort working in fast-paced environments with multiple clients and priorities
  • Advanced Excel skills; familiarity with Python or R is a plus

Preferred

  • You lead with expertise and curiosity—asking “why” before “how,” grounding your recommendations in data, and continuously sharpening your craft .
  • You make complex media performance simple and actionable. You eliminate noise, structure insights thoughtfully, and communicate in ways that move work forward.
  • You collaborate across disciplines without ego or silos. You listen with intention, share information openly, and strengthen trust through consistency and responsiveness.
  • You put people first—delivering honest insights with heart, considering the human impact behind the numbers, and supporting teammates with integrity.
  • You live The Arc Code. You go All In on accuracy and outcomes. You believe in No Sidelines, stepping into collaboration across planning, activation, and strategy.
  • You Move With Curiosity, using data to explore rather than defend.
  • You practice Truth With Heart, sharing insights clearly—even when they challenge assumptions—because that’s how better decisions are made.

Benefits

  • -
Attention Arc logo

Attention Arc

We’re a modern media agency built for brands that need every dollar to work harder.Attention Arc brings together the strengths of McKinney Media and LWD, united by a shared belief: every moment is an opportunity. Even this one. We use media (words in this case) intentionally and effectively to attract the right audiences, resonate with them, and convert awareness into action.It’s as simple—and as difficult—as that.Like many media agencies, we have the tools, clients, and talent you’d expect. What sets us apart is how we make it matter, with deeper audience insight, full-funnel thinking, and performance-driven execution that turns strategy into results.We blend creativity and analytics to deliver smarter targeting, sharper attribution, and more effective campaigns. Our proprietary tools work alongside industry standards to connect media decisions directly to business outcomes.We believe there’s an arc for every challenge.It’s the path from awareness to action, and how we move through it makes all the difference. We bring passion, expertise, and intention to guide that journey. And we find it fun, challenging, thought-provoking, and deeply rewarding.Thanks for taking the time to learn more about us.Whether you’re a prospective client, future team member, or media partner ready to push past the status quo. If anything here sparked your curiosity, let’s keep the conversation going.

New York, New York, USA
81 employees (23 in marketing)

Traffic Signals

Monthly Visitors
584
Traffic Source Mix
Direct
100%

Headcount Trend

Current headcount: ~81

Marketing Team

Marketing Team Size
23 (28% of company)
Marketing Roles Posted (Last 30 Days)
4