Job Opportunities API

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 insight Support documentation, governance, and process improvements across analytics workflows WHAT YOU’LL BRING Experience & Technical Expertise 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; familiarity with Python or R is a plus Capabilities Strong analytical thinking and problem-solving skills Ability to synthesize complex data into actionable busin