Senior Data Analyst

Attention Arc
Irvington; New York, US
On-site

Why this role

Pace
Fast Paced
Collaboration
High
Autonomy
Medium
Decision Impact
Team
Role Level
Individual Contributor

Derived from job-description analysis by Serendipath's career intelligence engine.

What success looks like

  • end-to-end data integrity
  • implementation of tracking solutions
  • resolution of complex data discrepancies
Typical background
data analyticsmarketing analyticsadvertising technology

Transferable backgrounds

  • Coming from data engineer
  • Coming from data scientist

Skills & requirements

Required

Advanced SQLData IntegrityTracking TechnologiesData AnalysisBI ToolsLarge Datasets

Preferred

PythonRProgrammatic Media Platforms

Stack & domain

Microsoft Sql ServerGoogle Tag ManagerMeta PixelAdobe LaunchTableauPower BiLookerSnowflakeBigQueryAzurePythonRDv360The Trade DeskAmazon DspAnalytical ThinkingStructured Problem-solvingAttention To DetailCommunicationOrganizational SkillsData AnalyticsMarketing AnalyticsAdvertising TechnologyMedia Analytics

About the role

Original posting from Attention Arc

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 BRING

Experience & 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.

WHAT WE OFFER

Compensation: The estimated range for this role is $90,000 - $95,000. 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

Source: Attention Arc careers

Similar roles