Media Data Analyst

Attention Arc•Irvington, NY

1d•$75,000 - $90,000•Hybrid

About The Position

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. You’ll build the analytical foundation that helps our teams make more intentional media decisions through scalable reporting, thoughtful analysis, and clear storytelling.

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
Strong analytical thinking and problem-solving skills
Ability to synthesize complex data into actionable business insights
Strong communication and data storytelling abilities
High attention to detail and commitment to data accuracy
Ability to manage multiple priorities in fast-paced environments
Collaborative mindset with strong cross-functional partnership skills
Curiosity and learning agility in evolving analytics and media environments
You lead with expertise and curiosity. You ground your recommendations in data, insight, and thoughtful analysis while continuously strengthening your craft.
You simplify complexity and communicate insights in ways that help people make confident decisions. You organize information thoughtfully and focus on what matters most.
You collaborate openly across disciplines and build trust through transparency, responsiveness, and shared problem-solving. You believe the best outcomes happen together.
You lead with integrity and empathy, considering the people behind the performance metrics. You support teammates, communicate honestly, and contribute positively to the broader team.
You take ownership, follow through, and bring energy to the work.
You collaborate across teams without ego or silos.
You ask thoughtful questions, explore deeply, and use data to learn rather than defend.
You communicate clearly, directly, and with empathy.
You understand that behind every dashboard is a decision. Behind every decision is a person. And every interaction is a chance to turn attention into impact.
You must be authorized to work in the United States for any employer. At this time, we are not sponsoring or providing assistance with obtaining work authorization.

Nice To Haves

Familiarity with Python or R is a plus

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
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
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 insight
Support documentation, governance, and process improvements across analytics workflows