Media Data Analyst at Attention Arc | Irvington, NY | $75K/yr – $90K/yr

Attention Arc

Media Data Analyst

Irvington, NY (Hybrid)

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

Posted 3 weeks ago

Top 1% of applicants do these two things.

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

Job Summary

Own end-to-end media analytics from data to decision, turning multi-channel performance into actionable guidance for media strategy and client outcomes.

Design dashboards and reports that translate impressions, CTR, CPA, ROAS into clear recommendations.
Lead cross-functional storytelling with audiences, channels, and ARC funnel to drive optimization.
Automate analytics workflows in Snowflake and SQL to support scalable, accurate insights across campaigns.

Job Description

Responsibilities

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
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
Conduct analytical deep-dives across campaign performance, audience behavior, and media effectiveness

Requirements

2–4+ years of experience in media analytics, marketing analytics, business intelligence, or advertising analytics
Advanced proficiency in SQL, including querying, transformation, and performance optimization
Hands-on experience working within Snowflake environments
Experience building dashboards and reporting solutions in Tableau, Sigma, Looker, Power BI, or similar platforms
Strong understanding of paid media KPIs including impressions, CTR, CPA, ROAS, reach, frequency, and conversion metrics
Experience working with large, multi-source datasets including platform APIs, CRM data, and web analytics
Advanced Excel skills

Preferred

Python or R is a plus

Benefits

Flexible Paid Time Off
Comprehensive Medical, Dental, and Vision plans
Competitive Parental Leave
Hybrid work model with in-office collaboration
Mental health support
Annual agency contribution to 401(k)
Flexible Spending Accounts (FSAs)
Commuter benefits and corporate discounts
Carrot Fertility and family-building support
Employee Assistance Program (EAP)
Casual work environment, team events, and community-building opportunities

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)

www.attentionarc.com