Senior Data Analyst

Posted Yesterday
Irvington, NY, USA
In-Office
Senior level
AdTech • Agency • Marketing Tech • Software
The Role
The Senior Data Analyst is responsible for ensuring data integrity across media and advertising clients, implementing tracking solutions, and providing actionable insights from complex datasets to improve analytics operations.
Summary Generated by Built In

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.

As part of our Technology & Analytics team, you help architect the systems, insights, and intelligence that power smarter decisions across the agency. The Builders and Translators connect strategy, activation, and performance by transforming raw data into meaningful action. Your work ensures our teams and clients can move with clarity, confidence, and precision.

WHAT YOU’LL DO

As a Senior Data Analyst, you will own end-to-end data integrity across media and advertising clients, helping ensure the accuracy, reliability, and performance of the data that powers decision-making. This role combines deep technical expertise with client partnership, requiring someone who can both solve complex data challenges and communicate clearly with internal and external stakeholders.

You’ll work closely with teams across Media, Account Services, Ad Operations, and Technology to implement tracking solutions, troubleshoot issues, validate performance data, and continuously improve how we scale analytics operations across the agency.

Key Responsibilities
  • Lead end-to-end onboarding for new clients, including discovery conversations, requirements gathering, tracking implementation, and validation of data flows

  • Partner directly with clients and technical teams to implement, test, and troubleshoot tracking pixels across websites, apps, and media platforms

  • Diagnose and resolve complex data discrepancies related to pixel firing, custom code conflicts, tagging issues, API sync failures, and media flight scheduling

  • Perform ongoing quality control checks to ensure data accuracy, consistency, and completeness across reporting systems and dashboards

  • Write advanced SQL queries and transformation logic to extract, reconcile, and analyze large datasets from multiple data sources

  • Serve as a trusted technical resource for clients, translating complex data challenges into clear, actionable insights and solutions

  • Build scalable QA frameworks, documentation, and repeatable processes that improve operational efficiency and reduce recurring issues

  • Collaborate cross-functionally with Media, Ad Operations, Engineering, Creative, and Account teams to ensure alignment across the campaign lifecycle

  • Support optimization and reporting efforts by identifying trends, anomalies, and opportunities within campaign and audience data

  • Contribute to the evolution of our analytics infrastructure and data best practices as the agency continues to scale

WHAT YOU’LL BRINGExperience & Technical Expertise
  • 4+ years of experience in data analytics, marketing analytics, advertising technology, or media analytics within an agency, SaaS, or client-facing environment

  • Advanced proficiency in Microsoft SQL Server, including T-SQL, CTEs, joins, window functions, stored procedures, and query optimization

  • Hands-on experience implementing and troubleshooting tracking technologies such as Google Tag Manager, Meta Pixel, Adobe Launch, or equivalent platforms

  • Strong understanding of digital media measurement, including attribution, conversion tracking, campaign pacing, impressions, clicks, and media flighting

  • Experience working with large datasets across multiple platforms and systems

  • Familiarity with BI and visualization tools such as Tableau, Power BI, or Looker

  • Exposure to cloud data environments such as Snowflake, BigQuery, or Azure is preferred

  • Experience with Python or R for data analysis or automation is a plus

  • Knowledge of programmatic media platforms such as DV360, The Trade Desk, or Amazon DSP is preferred

Capabilities
  • Exceptional analytical thinking and structured problem-solving skills

  • Strong attention to detail with a commitment to data accuracy and reliability

  • Ability to communicate technical concepts clearly to both technical and non-technical audiences

  • Strong organizational skills with the ability to manage multiple priorities in a fast-paced environment

  • Collaborative mindset with experience working across disciplines and stakeholder groups

  • Curiosity-driven approach to learning, testing, and continuous improvement

  • Confidence navigating ambiguity and solving complex, multi-layered technical challenges

WHO YOU ARE

At Attention Arc, how you work is just as important as what you deliver. Our core competencies define the skills and behaviors that drive strong performance and meaningful impact:

  • Credibility You apply strong craft and sound judgment to your work, using data, insight, and expertise to produce reliable, high-quality outcomes.

  • Clarity You organize thinking, communication, and outputs in a way that makes complex information easy to understand and act on.

  • Connection You work effectively across teams and disciplines, contributing to shared outcomes through alignment, transparency, and collaboration.

  • Care You demonstrate accountability and professionalism, considering both the quality of the work and its impact on clients and teammates.

  • Culture & Character You take ownership of your growth, show consistency in your approach, and contribute positively to the standards and expectations of the team.

Together, these behaviors define what it means to do great work here, building trust, driving impact, and creating a culture where people and ideas thrive.

WHO WE ARE

We’re a media agency built for brands that value intention. At Attention Arc, we combine deliberate media craft with technology designed to amplify it. We build trusted partnerships so every decision stays aligned with what matters most. Media doesn’t fail because of technology. It fails when intention is missing. That’s why we exist.

To restore intention to media.

At 160 people across four offices in Phoenix, Durham, Irvington, and New York City, we occupy a deliberate sweet spot: big enough to handle major brands and complex business, nimble enough to actually move, make decisions, and drive impact. No unnecessary layers. No slow-moving bureaucracy. Just sharp thinking, fast execution, and tech-enabled.

Our culture is shaped by our values:

  • All In we show up with intensity and ownership

  • No Sidelines we collaborate without ego or boundaries

  • Move With Curiosity we ask why, explore boldly, and learn fast

  • Truth With Heart we communicate with honesty and empathy

OUR COMMITMENT TO INCLUSION

At Attention Arc, we believe people do their best work when they feel they belong. Inclusion isn’t just about representation, it’s about creating an environment where people feel seen, supported, and comfortable showing up as themselves.

We value different lived experiences and perspectives, and actively create space for those voices to shape our work. We’re committed to building an agency where everyone has a genuine seat at the table and is trusted to step in and contribute, fostering collaboration, encouraging curiosity, and creating opportunities for people to take ownership and make an impact.

Because when people feel heard, respected, and confident to step forward, we all move forward, together.

WHAT WE OFFER

Compensation packages are based on the skill level and experience each candidate brings to the role.

We’re committed to rewarding our people fairly and supporting their growth with intention. Our salaries are competitive, thoughtfully benchmarked, and designed to ensure equity across roles, experience, and impact. Growth at Attention Arc isn’t tied to a calendar, it’s driven by performance, progress, and potential. We continuously invest in our people through ongoing feedback, development, and opportunities to take on more, so you can keep building your career in meaningful ways.

We’re committed to making sure that everyone at Attention Arc has what they need to thrive, not just professionally, but personally.

Here’s what you can expect:
  • Flexible Paid Time Off

  • Comprehensive Medical, Dental, and Vision plans

  • Competitive Parental Leave that gives you time to bond with your family

  • Hybrid work model with in-office collaboration

  • Mental health support

  • Annual agency contribution to 401(k)

  • Flexible Spending Accounts (FSAs) and Healthcare FSA

  • Commuter benefits and corporate discounts

  • Carrot Fertility and family-building support

  • Employee Assistance Program (EAP)

  • Casual work environment, team building, and other social events

LOCATION

We operate on a hybrid, in-office model designed to foster collaboration, mentorship, and hands-on learning. Employees are expected to work from the office three days per week (Tuesday, Wednesday, and Thursday) to fully experience the energy of our teams and build meaningful connections.

Candidates must reside in and be able to commute to one of the following office locations three days a week:

  • Phoenix, Arizona

  • Durham, North Carolina

  • Irvington, New York

RIGHT TO WORK IN THE US

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.

Skills Required

  • 4+ years of experience in data analytics, marketing analytics, advertising technology, or media analytics
  • Advanced proficiency in Microsoft SQL Server, including T-SQL, CTEs, joins, window functions, and query optimization
  • Hands-on experience implementing and troubleshooting tracking technologies such as Google Tag Manager, Meta Pixel, or Adobe Launch
  • Strong understanding of digital media measurement, including attribution and conversion tracking
  • Experience working with large datasets across multiple platforms
  • Familiarity with BI and visualization tools such as Tableau, Power BI, or Looker
  • Exposure to cloud data environments such as Snowflake or Azure is preferred
  • Experience with Python or R for data analysis or automation is a plus
  • Knowledge of programmatic media platforms such as DV360 or The Trade Desk is preferred
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, New York
99 Employees

What We Do

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.

Similar Jobs

In-Office
22 Locations
13446 Employees
90K-143K Annually

Citizens Logo Citizens

Senior Data Analyst

Digital Media • Fintech • Information Technology • Machine Learning • Financial Services • Cybersecurity • Automation
In-Office or Remote
2 Locations
17000 Employees
104K-138K Annually
Hybrid
Brooklyn, NY, USA
135 Employees
100K-125K Annually

IPG Mediabrands Logo IPG Mediabrands

Senior Data Analyst

AdTech • Digital Media • Marketing Tech
In-Office
New York, NY, USA
10936 Employees
75K-85K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account