Media Data Analyst

Irvington, NY (Hybrid)

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

Posted 4 days ago

Job Summary

Own and lead data driven media analytics by building dashboards, translating multi channel data into clear reporting, and delivering insights that drive campaign optimization and strategic decisions across cross functional teams.

Own dashboards and reporting frameworks that align with client goals
Drive actionable insights and optimization recommendations from multi channel data
Collaborate with Media Planning, Activation, Research, and Account teams to influence strategy

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 is required
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; familiarity with Python or R is a plus
Strong analytical thinking and problem-solving skills
Ability to synthesize complex data into actionable business insights
Strong communication and data storytelling abilities

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)

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